A sample of 14 days show daily cargo volumes processed at the airport of Atlanta

Question

A sample of 14 days show daily cargo volumes processed at the airport of Atlanta. Another sample of 16 from the airport of Chicago show daily cargo volumes processed at the airport of Chicago. Observation Atlanta [ton th] Chicago [ton th] 1 42 34 2 45 5 3 18 19 4 17 36 5 12 30 6 25 7 7 31 24 8 35 13 9 24 38 10 22 14 11 24 15 12 15 25 13 40 16 14 45 9 15 8 16 8 2 points 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) Get the p-value (from the output) to test whether the Atlanta airport daily cargo is greater than the Chicago daily cargo. 1 point <----enter p-value inside this cell step by step please A sample of 14 days show daily cargo volumes processed at the airport of Atlanta. Another sample of 16 from the airport of Chicago show daily cargo volumes processed at the airport of Chicago. Observation Atlanta [ton th] Chicago [ton th] 1 42 34 2 45 5 3 18 19 4 17 36 5 12 30 6 25 7 7 31 24 8 35 13 9 24 38 10 22 14 11 24 15 12 15 25 13 40 16 14 45 9 15 8 16 8 2 points 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) Get the p-value (from the output) to test whether the Atlanta airport daily cargo is greater than the Chicago daily cargo. 1 point <----enter p-value inside this cell step by step please

Explanation / Answer

Hypothesis Test: Independent Groups (t-test, pooled variance) Group 1 Group 2 28.21 18.81 mean 11.43 11.03 std. dev. 14 16 n 28 df 9.402 difference (Group 1 - Group 2) 125.814 pooled variance 11.217 pooled std. dev. 4.105 standard error of difference 0 hypothesized difference 2.29 t .0149 p-value (one-tailed, upper)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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