Lab report rewrite
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 , 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://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 7Diameter (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 2Height (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 515