Article assgn 2

profilepatience_24
excelandcomparisonofmeans.xlsx
Home>Business & Finance homework help>Operations Management homework help>Article assgn 2

Sheet1

2017 2018 2019
January 65 26 19 t-Test: Two-Sample Assuming Equal Variances t-Test: Two-Sample Assuming Equal Variances
February 67 22 17
March 53 14 20 2017 2018 2018 2019
April 69 19 24 Mean 62.1666666667 24.25 Mean 24.25 24
May 81 24 26 Variance 2119.9696969697 28.3863636364 Variance 28.3863636364 18
June 43 22 19 Observations 12 12 Observations 12 12
July 36 20 29 Pooled Variance 1074.178030303 Pooled Variance 23.1931818182
August 36 29 25 Hypothesized Mean Difference 0 Hypothesized Mean Difference 0
September 33 27 27 df 22 df 22
October 31 25 26 t Stat 2.8337898666 t Stat 0.127155593
November 34 34 30 P(T<=t) one-tail 0.0048317101 P(T<=t) one-tail 0.4499861605
December 198 29 26 t Critical one-tail 1.7171443744 t Critical one-tail 1.7171443744
P(T<=t) two-tail 0.0096634202 P(T<=t) two-tail 0.8999723209
t Critical two-tail 2.0738730679 t Critical two-tail 2.0738730679