Images | Horsepower |
---|---|
275 | |
300 | |
350 | |
365 | |
400 | |
525 | |
650 | |
760 | |
1050 | |
1775 |
Use the horsepower data to perform the following calculations:
Bins (x) | Frequency (f) | P(x) |
---|---|---|
_______ | _______ | _______ |
_______ | _______ | _______ |
_______ | _______ | _______ |
_______ | _______ | _______ | Sum: | _______________ | _______________ |
Confidence interval statistics | |||
---|---|---|---|
Degrees of freedom | df | = n-1 | =COUNT(data)-1 |
Find a zc value from a confidence level c | zc | =ABS(NORMSINV((1-c)/2)) | |
Find a tc value from a confidence level c | tc | =TINV(1-c,df) | |
Calculate an error tolerance E of a mean for any n using sx. | E | =tc*sx/SQRT(n) | |
Calculate a confidence interval for a population mean µ from a sample mean x and an error tolerance E | x-E≤ µ ≤x+E |