INTRVL_EST1
| z-Estimate: Mean |
| | | Column 1 |
| Mean | | 4.4 |
| Standard Deviation | | 2.8537 |
| Observations | | 40 |
| SIGMA | | 2.8699998856 |
| LCL | | 3.6535870932 |
| UCL | | 5.1464129068 |
The 90% confidence interval for the mean is 3.653587 to 5.146413.
MEAN1
| Z-Test: Mean |
| | | | Column 1 |
| Mean | | | 78.05 |
| Standard Deviation | | | 5.5958 |
| Observations | | | 20 |
| Hypothesized Mean | | | 75 |
| SIGMA | | | 12 |
| z Stat | | | 1.1367 |
| P(Z<=z) one-tail | | | 0.1278 |
| z Critical one-tail | | | 0 |
| P(Z<=z) two-tail | | | 0.2556 |
| z Critical two-tail | | | 0.6745 |
Answers:
1> H0 = the formal null hypotheses is not greater than 75.
Ha = the alternative hypothesis is greater than 75.
2> The average value of test statistic is 1.1367 and the decision is accept H0.
As it is designed to produced the mean score of 75 but the mean score of this class is 78.05 so it is considered to be above average.
Sheet3
| 79 |
| 79 |
| 78 |
| 74 |
| 82 |
| 89 |
| 74 |
| 75 |
| 78 |
| 73 |
| 74 |
| 84 |
| 82 |
| 66 |
| 84 |
| 82 |
| 82 |
| 71 |
| 72 |
| 83 |
Confidence Intervals
| 2 | 2.2324289682 | | | Column1 |
| 4 | 4.2518387402 |
| 2 | 2.3355815302 | | | Mean | 4.4 |
| 6 | 6.9042023988 | | | Standard Error | 0.4512092016 |
| 8 | 8.0028687399 | | | Median | 4.5 |
| 1 | 1.5012054811 | | | Mode | 2 |
| 2 | 2.0035401471 | | | Standard Deviation | 2.8536975564 |
| 8 | 8.3577990051 | | | Sample Variance | 8.1435897436 |
| 8 | 8.1496627705 | | | Kurtosis | -1.2347196337 |
| 9 | 9.9014252144 | | | Skewness | 0.0956077988 |
| 3 | 3.1922360912 | | | Range | 9 |
| 6 | 6.8941312906 | | | Minimum | 0 |
| 2 | 2.4231696524 | | | Maximum | 9 |
| 8 | 8.8586077456 | | | Sum | 176 |
| 6 | 6.7107150487 | | | Count | 40 |
| 8 | 8.003173925 |
| 5 | 5.6093020417 |
| 5 | 5.2507095553 |
| 3 | 3.217261269 |
| 0 | 0.8255256813 |
| 1 | 1.9293801691 |
| 6 | 6.476638081 |
| 5 | 5.3279213843 |
| 8 | 8.0877101962 |
| 6 | 6.4931180761 |
| 2 | 2.3496200446 |
| 3 | 3.1760612812 |
| 5 | 5.6605731376 |
| 7 | 7.8621784112 |
| 3 | 3.6548966948 |
| 9 | 9.9978637043 |
| 2 | 2.0657979064 |
| 0 | 0.7901242103 |
| 0 | 0.1773125401 |
| 9 | 9.2938016907 |
| 3 | 3.230384228 |
| 3 | 3.2032227546 |
| 6 | 6.0164189581 |
| 0 | 0.1397747734 |
| 2 | 2.8119754631 |
CHI-NORM2
| Chi-Squared Test of Normality |
| | Column 1 |
| Mean | 29.3181818182 |
| Standard deviation | 4.9221 |
| Observations | 22 |
| Intervals | Probability | Expected | Observed |
| (z <= -1) | 0.158655 | 3.49041 | 4 |
| (-1 < z <= 0) | 0.341345 | 7.50959 | 10 |
| (0 < z <= 1) | 0.341345 | 7.50959 | 4 |
| (z > 1) | 0.158655 | 3.49041 | 4 |
| chi-squared Stat | 2.6149 |
| df | 1 |
| p-value | 0.1059 |
| chi-squared Critical | 3.8415 |
MEAN2
| t-Estimate: Mean |
| | | | Column 1 |
| Mean | | | 29.3182 |
| Standard Deviation | | | 4.9221 |
| Observations | | | 22 |
| Standard Error | | | 1.0494 |
| LCL | | | 27.1358350495 |
| UCL | | | 31.5005285868 |
With 95% confidence we estimate the mean length of linch breaks at Giant Mart to be between 27.13584 to 31.50053.
Ex 031
| 30 |
| 24 |
| 38 |
| 35 |
| 27 |
| 35 |
| 23 |
| 28 |
| 28 |
| 22 |
| 26 |
| 34 |
| 29 |
| 25 |
| 28 |
| 34 |
| 24 |
| 26 |
| 28 |
| 32 |
| 29 |
| 40 |
T-Test Mean
| t-Test: Mean |
| | | | Column 1 |
| Mean | | | 4.5625 |
| Standard Deviation | | | 1.3405 |
| Hypothesized Mean | | | 4 |
| df | | | 7 |
| t Stat | | | 1.1869 |
| P(T<=t) one-tail | | | 0.137 |
| t Critical one-tail | | | 2.998 |
| P(T<=t) two-tail | | | 0.274 |
| t Critical two-tail | | | 3.4995 |
Sheet9
| percentage |
| 5.2 |
| 6.4 |
| 3.8 |
| 6.3 |
| 4.1 |
| 2.8 |
| 3.2 |
| 4.7 |
jack_96
sampleStatPart2savewala.xlsx
