Question 150 pts Please refer to the data and data description attached. Case2(1
ID: 3180780 • Letter: Q
Question
Question 150 pts
Please refer to the data and data description attached. Case2(1).xlsx Case2(1).pdfUse Excel to run statistical analysis. Match the following statistics with the values you found for them. Please round to four decimals. If your excel cell only shows three, you need to right click -> Format cells to change the setting to four decimals. Otherwise it may lead to wrong answers.
Mean
[ Choose ] 7.7800 8.8970 8.5000 8.5040 8.4938 0.1033 8.4940 0.0107
Standard deviation
[ Choose ] 7.7800 8.8970 8.5000 8.5040 8.4938 0.1033 8.4940 0.0107
Variance
[ Choose ] 7.7800 8.8970 8.5000 8.5040 8.4938 0.1033 8.4940 0.0107
Minimum
[ Choose ] 7.7800 8.8970 8.5000 8.5040 8.4938 0.1033 8.4940 0.0107
Maximum
[ Choose ] 7.7800 8.8970 8.5000 8.5040 8.4938 0.1033 8.4940 0.0107
Q1
[ Choose ] 7.7800 8.8970 8.5000 8.5040 8.4938 0.1033 8.4940 0.0107
Median (Q2)
[ Choose ] 7.7800 8.8970 8.5000 8.5040 8.4938 0.1033 8.4940 0.0107
Q3
[ Choose ] 7.7800 8.8970 8.5000 8.5040 8.4938 0.1033 8.4940 0.0107
Part_Size 8.503 8.502 8.505 8.510 8.346 8.501 8.511 8.493 8.508 8.493 8.503 8.501 8.499 8.310 8.499 8.502 8.494 8.498 8.501 8.504 8.500 8.489 8.489 8.804 8.505 7.780 8.374 8.505 8.499 8.897 8.496 8.499 8.505 8.503 8.509 8.494 8.492 8.490 8.504 8.505 8.500 8.492 8.504 8.782 8.499 8.500 8.497 8.493 8.505 8.490 8.503 8.497 8.499 8.502 8.503 8.498 8.150 8.501 8.461 8.492 8.497 8.506 8.499 8.509 8.494 8.500 8.496 8.497 8.497 8.503 8.504 8.502 8.506 8.499 8.511 8.502 8.501 8.501 8.495 8.507 8.503 8.505 8.493 8.498 8.501 8.501 8.489 8.498 8.504 8.497 8.506 8.489 8.494 8.493 8.497 8.491 8.506 8.503 8.501Explanation / Answer
Mean = 8.4938
Standard Deviation = 0.1033
Variance = 0.0107
Minimum = 7.7800
Maximum = 8.8970
Q1 = 8.500
Q2 = 8.500
Q3 = 8.5040