Lab report rewrite

profilemoly89
molymolycopycopy.docx

TO:

FROM:

DATE: 02/18/2019

SUBJECT: Statistical Analysis of Experimental Data Density of Cylinders with an Unknown Material

Introduction

This experiment goes through the statistical methods of a given data which will be used to analyze the experiment. These statistical methods are used to calculate important values such as: the mean, median, mode, stander deviation, and confidence level of the mean. Other than that one will be able eliminate a measurement based on Chauvenant’s criterionIn this experiment the data specified with 50 cylinders with unknown material. Each cylinder has it own mass, diameter, and height. Based on that one will be able to apply all of the statistical methods required in this lab. The determination of the nominal density, and uncertainty of density of cylinder an unknown material is also required in this lab.

Experimental Methods

Since the experiment was theoretical, the values of 50 cylinder was given to the student. Most of the calculations and findings was done using Excel.

1- From the given data the histogram was plotted for mass, diameter and height.

2- After that the centural tendency and dispersion was measured.

3- Assuming the distribution was Gaussian, using the Chuvenat’s criterion the data was studied to check if any of the measurement could be discarded.

4- In addition, 90% and 98% confidence interval was found for each of the mean values.

5- From the available information volume and density was both found.

6- Step 2 and 4 was done for the volume and dencity except 95% confidence interval.

7- An equaiton was driven and uncertainty was calculated for volume and density based on 95% confidence level, and compared to the previous step.

8- The mass as a function of volume was plotted and the least fit square curve was shown.

= for the mean

for Standard deviation equation (S.D)

Z = to get the Chauvenet’s criterion (T)

CI = for confidence interval.

Analysis and Results

You need to answer the following questions in the memo report and show any sample calculations in the attachments:

1. Plot a histogram of each of the three measurements: mass, diameter, and height of the cylinders. Each histogram must contain at least 5 bins.

Figure 1 Mass Histogram

Figure 2 Diameter Histogram

Figure 3 Height Histogram

2. Determine the central tendency of each measurement using the mean, the median, and the mode.

Table 1 Central Tendency of Mass

Central Tendency of Mass

Mean

0.67274

Standard Error

0.001329972

Median

0.6745

Mode

0.675

Count

50

Table 2 Central Tendency of Diameter

Central Tendency of Diameter

Mean

25.366

Standard Error

0.070601497

Median

25.5

Mode

25.5

Count

50

Table 3 Central Tendency of Height

Central Tendency of Height

Mean

15.002

Standard Error

0.017552254

Median

15

Mode

15

Count

50

3. Determine the dispersion measure of each measurement using the standard deviation.

S.D of Mass

0.009404319

S.D of Height

0.124113181

S.D of Diameter

0.499227975

4. Assume that the distribution of each measurement is Gaussian or normal error distribution. Using Chauvenant’s criterion, can any of these measurements be discarded? If yes, determine the new central tendency and dispersion measure (i.e., repeat steps 2 and 3).

Chauvenant’scriterion values for n=50 is 2.576

Calculating values using

Sample calculation

Table 4Chauvenant’scriterion Table

Mass

Diameter

Height

0.929787234

0.733173

1.62772

0.240425532

2.135417

0.016116

1.036170213

1.734776

0.789686

1.836170213

1.133814

0.386785

0.610638298

0.332532

1.192587

0.240425532

0.068109

0.419017

0.929787234

0.268429

0.821918

0.504255319

1.133814

4.045125

1.836170213

1.734776

0.386785

1.304255319

1.270032

0.016116

1.887234043

2.736378

0.016116

1.887234043

0.733173

1.595488

0.240425532

0.268429

2.401289

0.240425532

0.869391

1.192587

1.836170213

0.132212

0.386785

0.823404255

0.869391

0.419017

0.559574468

0.268429

0.821918

1.568085106

1.270032

0.419017

0.717021277

0.733173

0.016116

0.717021277

2.271635

0.016116

0.453191489

0.268429

0.386785

0.240425532

0.869391

0.386785

1.461702128

0.268429

0.016116

1.623404255

0.132212

0.821918

0.185106383

0.132212

1.224819

0.134042553

0.268429

0.419017

0.823404255

0.869391

0.386785

0.39787234

1.133814

0.789686

1.887234043

2.271635

0.789686

0.453191489

1.133814

0.386785

0.185106383

1.270032

0.386785

0.772340426

0.733173

0.386785

0.240425532

0.268429

0.419017

0.504255319

0.733173

0.016116

0.610638298

0.132212

0.016116

0.134042553

0.733173

0.789686

0.559574468

0.268429

0.821918

0.878723404

0.268429

0.419017

1.304255319

0.132212

0.016116

0.610638298

0.268429

0.821918

0.665957447

0.132212

0.016116

0.985106383

0.869391

0.016116

0.772340426

0.869391

0.821918

0.291489362

0.268429

0.419017

1.355319149

0.132212

0.386785

0.823404255

0.268429

0.789686

0.240425532

0.268429

0.789686

1.304255319

0.132212

1.595488

0.665957447

1.270032

2.03062

0.985106383

0.268429

0.386785

Based on calculation we can reject 24mm value for diameter as outlier

Central tendency and dispersion after removing outlier

Table 5 Central tendency and dispersion after removing outlier

Diameter

Mean

25.39387755

Standard Error

0.066202133

Median

25.5

Mode

25.5

Standard Deviation

0.463414934

Count

49

5. Determine the 90% and 98% confidence interval for each of the mean values.

Table 6 90%, 98% confidence interval for Mass

Mass

Lower

Upper

90%

0.670552197

0.674927803

98%

0.669641166

0.675838834

Table 7 90%, 98% confidence interval for Diameter

Diameter

Lower

Upper

90%

25.2498605

25.48213946

98%

25.2014985

25.20149851

Table 8 90%, 98% confidence interval for Height

Height

Lower

Upper

90%

14.97312654

15.03087346

98%

14.96110325

14.96110325

6. Determine the volume and density of each cylinder in cm3 and kg/m3 respectively.

Table 9 Volume and Density Table

Cylinder

Mass (kg)

Diameter (mm)

Height (cm)

Volume(cm3)

Density(kg/m3)

1

0.664

25.0

14.80

72.61

9144.43

2

0.675

24.3

15.00

69.53

9708.01

3

0.663

24.5

15.10

71.15

9318.26

4

0.690

24.8

15.05

72.66

9495.98

5

0.667

25.2

15.15

75.52

8831.66

6

0.675

25.4

14.95

75.71

8915.09

7

0.664

25.5

14.90

76.06

8730.35

8

0.668

24.8

14.50

70.01

9541.91

9

0.690

24.5

15.05

70.92

9729.95

10

0.685

26.0

15.00

79.60

8605.64

11

0.655

24.0

15.00

67.82

9657.35

12

0.655

25.0

15.20

74.58

8783.10

13

0.675

25.5

15.30

78.10

8642.96

14

0.675

25.8

15.15

79.16

8526.72

15

0.690

25.3

15.05

75.62

9124.35

16

0.665

25.8

14.95

78.12

8512.78

17

0.678

25.5

14.90

76.06

8914.43

18

0.658

26.0

14.95

79.33

8294.08

19

0.666

25.0

15.00

73.59

9049.68

20

0.666

26.5

15.00

82.69

8054.18

21

0.677

25.5

15.05

76.82

8812.56

22

0.675

25.8

15.05

78.64

8583.38

23

0.659

25.5

15.00

76.57

8606.85

24

0.688

25.3

14.90

74.87

9189.49

25

0.671

25.3

14.85

74.62

8992.60

26

0.674

25.5

14.95

76.31

8832.20

27

0.665

25.8

15.05

78.64

8456.22

28

0.669

24.8

15.10

72.90

9176.48

29

0.655

26.5

15.10

83.24

7868.70

30

0.677

24.8

15.05

72.66

9317.07

31

0.671

26.0

15.05

79.86

8401.75

32

0.680

25.0

15.05

73.84

9209.22

33

0.675

25.5

14.95

76.31

8845.30

34

0.668

25.0

15.00

73.59

9076.86

35

0.667

25.3

15.00

75.37

8849.60

36

0.674

25.0

15.10

74.08

9097.73

37

0.678

25.5

14.90

76.06

8914.43

38

0.681

25.5

14.95

76.31

8923.92

39

0.685

25.3

15.00

75.37

9088.42

40

0.667

25.5

14.90

76.06

8769.80

41

0.679

25.3

15.00

75.37

9008.82

42

0.682

25.8

15.00

78.38

8701.30

43

0.680

25.8

14.90

77.86

8734.01

44

0.670

25.5

14.95

76.31

8779.78

45

0.660

25.3

15.05

75.62

8727.64

46

0.665

25.5

15.10

77.08

8627.69

47

0.675

25.5

15.10

77.08

8757.43

48

0.685

25.3

15.20

76.38

8968.84

49

0.679

26.0

14.75

78.27

8674.84

50

0.682

25.5

15.05

76.82

8877.65

7. Determine the following statistics of the calculated values of the volume and density of the cylinders:a) Mean, b) Median, c) Mode, d) Standard Deviation, e) 95% confidence level of the mean.

Table 10 Mean, Median, Mode and S.D for Volume

Volume

Mean

75.80285257

Standard Error

0.428644322

Median

76.05649125

Mode

76.05649125

Standard Deviation

3.030973068

Count

50

 

Lower

Upper

95%

74.9627097

76.643

Table 11 Mean, Median, Mode and S.D for Density

Density

Mean

8889.029584

Standard Error

53.8486439

Median

8847.452344

Mode

8914.426486

Standard Deviation

380.7674126

Count

50

 

Lower

Upper

95%

8783.486242

8994.573

8. Derive an equation and calculate the uncertainty in the volume and density calculations based on the 95% confidence level.

The volume and density of cylinders is calculated by measuring dimensions D, and H.

It is assumed that the measurements will follow Gaussian distribution with standard deviation \sigma, which is same for all the measurements.

Therefore uncertainties at 95% confidence levels are given by

Or in other words

The error formula is

Table 12 Uncertainty in Volume and Density

Uncertainty in Volume

Uncertainty in density

1.162835487

155.5857316

1.145468273

169.6416852

1.162598262

161.5781978

1.172967663

162.7867762

1.199825251

149.1379357

1.193427288

149.4367126

1.194134479

145.8023515

1.130175735

163.5843566

1.158754933

168.7178399

1.225749224

141.1242772

1.131303959

170.7418688

1.19420826

149.4315207

1.226133969

144.3363801

1.228443607

140.8437058

1.19665749

153.5101733

1.212256067

140.6166338

1.194134479

148.8764975

1.221671064

136.0159001

1.178521692

153.9702215

1.249366787

129.7452959

1.20613411

147.1727779

1.220349788

141.7811509

1.202134209

143.7381053

1.184751806

154.6087353

1.180783292

151.2970298

1.198134332

147.5023469

1.220349788

139.6806894

1.176857975

157.3089426

1.257679736

126.7557791

1.172967663

159.719779

1.22982741

137.7799121

1.182443301

156.6837032

1.198134332

147.7211931

1.178521692

154.4325945

1.192688905

148.8886357

1.186364932

154.7861284

1.194134479

148.8764975

1.198134332

149.0342703

1.192688905

152.9066199

1.194134479

146.461097

1.192688905

151.5672919

1.216302915

143.7298054

1.208209244

144.2717956

1.198134332

146.626962

1.19665749

146.8358179

1.210134035

144.0846113

1.210134035

146.2512972

1.208563384

150.891398

1.205358684

142.2634173

1.20613411

148.2597261

9. Compare the uncertainties calculated in Step 8 with the statistics found in Step 7.

While comparing uncertainties in step 8 with the confidence interval we found out that these uncertainties fall within the range 95% confidence interval.

10. Plot the mass of each cylinder as a function of the volume of each cylinder. Fit a leastsquares curve to this plot. Physically, what does the slope of the least squares linerepresent? Compare, if possible.

Figure 4 Mass as a function of Volume

The slope of the curve means how mass is changing with respect to volume. As in this case slope is -0.0001 means mass and volume are not dependent on each other.

Conclusions and Recommendations

In this lab we have used statistical methods to analyze experimental data. Also determined the nominal density, and uncertainty of density, of cylinders of an unknown material. Using the raw data of 50 measurements (diameter, height, and mass) of cylinders of an unknown material we first made the histogram of mass, diameter and height of cylinder. The volume and density of each of the cylinder is found using the raw data. We also determined the uncertainty in volume and density of the cylinder and found out that uncertainty lie within the range of 95% confidence interval.

References

http://www.statisticshowto.com/chauvenets-criterion/

http://sphweb.bumc.bu.edu/otlt/MPH-Modules/BS/BS704_Confidence_Intervals/BS704_Confidence_Intervals_print.html

http://www.phy.olemiss.edu/~thomas/weblab/221%20Miscellaneous%20folder/221_web_uncertainty/No_quad_uncertainty_fall_09.pdf

http://spiff.rit.edu/classes/phys273/uncert/uncert.html

72.612499999999983 69.530197500000014 71.150633750000011 72.662363200000016 75.523719600000007 75.714364700000075 76.056491249999979 70.006928000000002 70.915035625000087 79.599000000000004 67.823999999999998 74.575000000000003 78.098276249999998 79.162901099999957 75.621832824999913 78.117846300000011 76.056491249999979 79.333670000000012 73.59375 82.689937499999942 76.822160624999981 78.640373700000012 76.56693749999998 74.86812685000001 74.616891525000014 76.31171437499998 78.640373700000012 72.903766400000023 83.241203750000096 72.662363200000016 79.86433000000001 73.839062499999983 76.31171437499998 73.59375 75.370597499999988 74.08437499999998 76.056491249999979 76.31171437499998 75.370597499999988 76.056491249999979 75.370597499999988 78.379110000000011 77.85658260000001 76.31171437499998 75.621832824999913 77.077383749999981 77.077383749999981 76.375538799999887 78.272349999999989 76.822160624999981 0.6640000000000007 0.67500000000000071 0.6630000000000007 0.69000000000000039 0.6670000000000007 0.67500000000000071 0.6640000000000007 0.6680000000000007 0.69000000000000039 0.68500000000000005 0.65500000000000058 0.65500000000000058 0.67500000000000071 0.67500000000000071 0.69000000000000039 0.6650000000000007 0.67800000000000071 0.65800000000000058 0.6660000000000007 0.6660000000000007 0.67700000000000071 0.67500000000000071 0.65900000000000059 0.68799999999999994 0.67100000000000071 0.67400000000000071 0.6650000000000007 0.66900000000000071 0.65500000000000058 0.67700000000000071 0.67100000000000071 0.68 0.67500000000000071 0.6680000000000007 0.6670000000000007 0.67400000000000071 0.67800000000000071 0.68100000000000005 0.68500000000000005 0.6670000000000007 0.67900000000000071 0.68200000000000005 0.68 0.67000000000000071 0.66000000000000059 0.6650000000000007 0.67500000000000071 0.68500000000000005 0.67900000000000071 0.68200000000000005

Volume

Mass

Mass (kg)

0.655-0.661 0.662-0.668 0.669-0.675 0.676-0.682 0.683-0.689 0.69-0.696 3 3 14 12 11 7

Diameter (mm)

24-24.4 24.5-24.9 25-25.4 25.5-25.9 26-26.4 26.5-26.9 1 3 10 24 10 2

Height (cm)

14.5-14.65 14.66-14.81 14.82-14.97 14.98-15.13 15.14-15.29 15.3-15.45 1 0 2 14 28 5

15