A paired difference test, based on time of day and day of the week, was conducte

Question

A paired difference test, based on time of day and day of the week, was conducted to compare the difference, between the Ambassador Bridge and the Detroit-Windsor Tunnel, in their average times for drivers to cross the border. A random sample of 10 times were randomly selected. One car from each selected time was observed crossing the border at each location and their times (in minutes) were recorded as shown on the Excel file. At the .025 level of significance, is there sufficient evidence that the true average time to cross at the Tunnel is greater than the true average time to cross at the Bridge? question asks you to test the difference in two population means using matched or paired samples. Use Excel to show your work.

Pair tunnel bridge
1 15.7 11.1
2 22.5 17.8
3 38.6 37.2
4 5.4 3.2
5 18.5 14.1
6 12.9 9.1
7 45.1 41.8
8 26.3 27.3
9 32.6 29.4
10 3.8 4.2

Explanation / Answer

from above as p value is less then 0.05 level of signfiicance we can reject null hypothesis,

we have sufficient evidecne to conclude that  the true average time to cross at the Tunnel is greater than the true average time to cross at the Bridge.

please revert if you need any help with excel formula used,

tunnel bridge difference(d) 15.7 11.1 4.6 22.5 17.8 4.7 38.6 37.2 1.4 5.4 3.2 2.2 18.5 14.1 4.4 12.9 9.1 3.8 45.1 41.8 3.3 26.3 27.3 -1 32.6 29.4 3.2 3.8 4.2 -0.4 mean 2.620 std deviaition 2.0411 sample size 10.0000 std error= std dev/(n)^(1/2) 0.6455 t stat= (d)/std error 4.0591 p value = 0.0014

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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