A company currently uses Supplier A but will switch to Supplier B if its average
ID: 3160265 • Letter: A
Question
A company currently uses Supplier A but will switch to Supplier B if its average delivery time is less than that for Supplier A. Use Excel to conduct the appropriate hypothesis test. Use alpha = .10. Use data analysis/tools: t-test - two-sample assuming unequal variances.
What is the t test statistic? Enter your answer using 3 decimals, rounding as appropriate (e.g. 2.7386 would be entered as 2.739).
What is the p-value of the t test statistic? Enter your answer using 3 decimals, rounding as appropriate (e.g. 0.7386 would be entered as 0.739).
Is the following statement true or false?
Accept the null hypothesis. (TRUE or FALSE)
Explanation / Answer
supplier A supplier B Ho : miu A = miu B 10 3 Ha : miu A > miu B 13 6 12 15 t = ( 11.57 - 9.06) / ( srqt [ 2.06^2/14 + 6.15^2/16 ] ) 14 4 t = 1.54 14 7 p value : 0.08 12 6 alpha = 0.10 10 2 df = 14+16-2 = 28 12 4 critical value : 1.313 8 18 8 16 since t > critical value we reject Ho 10 20 14 18 13 9 12 4 5 8 x-bar 11.57 9.06 SD 2.06 6.15 n 14 16
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.