How many miles do you drive per day? Responses from 18 Los Angeles residents and

Question

How many miles do you drive per day? Responses from 18 Los Angeles residents and 22 Atlanta residents are shown below Atlanta (in miles) 15 18 Los Angeles (in miles) 28 19 15 37 10 12 13 19 15 17 18 31 35 38 37 21 Use the appropriate Excel Add-in to conduct an hypothesis test and generate the output inside this green box ignore the fact that these numbers keep changing, just generate the output) 3 points Get the p-value (from the output) to test whether the Los Angeles residents drive more miles than Atlanta residents enter p-value inside this cell

Explanation / Answer

Q-2 Since same samples is compared at 2 times So paired sample t-test is being used

Difference Scores Calculations

Mean: 29.47
? = 0
S2 = SS?df = 369670.74/(19-1) = 20537.26
S2M = S2/N = 20537.26/19 = 1080.91
SM = ?S2M = ?1080.91 = 32.88

T-value Calculation

t = (M - ?)/SM = (29.47 - 0)/32.88 = 0.90

The value of t is 0.896479. The value of p is 0.381831. The result is not significant at p ? 0.05.

Because the p-value is 0.381831, which is greater than the significance level of 0.05, So fail to reject the null hypothesis and concludes that the mean ticket price during current and porevious year is same. The 95% CI is used.

Diff (T2 - T1) Dev (Diff - M) Sq. Dev 259 229.53 52682.33 -45 -74.47 5546.33 127 97.53 9511.38 65 35.53 1262.12 -149 -178.47 31852.86 -43 -72.47 5252.43 47 17.53 307.17 -122 -151.47 22944.28 -72 -101.47 10296.91 94 64.53 4163.65 215 185.53 34420.01 116 86.53 7486.8 -117 -146.47 21454.54 -7 -36.47 1330.33 -260 -289.47 83795.01 46 16.53 273.12 304 274.53 75364.7 31 1.53 2.33 71 41.53 1724.43 M: 29.47 S: 369670.74

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.