Question: help pls! pls include excel formulas !! thank you! 10.9 Is there a difference in the satisfaction rating of traditional cellphone providers who bill for

help pls! pls include excel formulas !! thank you!
help pls! pls include excel formulas !! thank you! 10.9 Is there
a difference in the satisfaction rating of traditional cellphone providers who bill
for service at the end of a month often under a contract

10.9 Is there a difference in the satisfaction rating of traditional cellphone providers who bill for service at the end of a month often under a contract and prepaid cellphone service providers who bill in advance without a contract? The file contains the satisfaction rating for 10 traditional cellphone providers and 13 prepaid cellphone service providers. Source: Data extracted from "Carrier Ratings: Why It Pays to Think Small," Consumer Reports, February 2016, p. 51 . a. Assuming that the population variances from both types of cellphone providers are equal, is there evidence of a difference in the mean ratings between the two types of cellphone providers? (Use =0.05.) b. Find the p-value in (a) and interpret its meaning. c. What other assumption is necessary in (a)? d. Assuming that the population variances from both cellphone providers are equal, construct and interpret a 95% confidence interval estimate of the difference between the population means of the two cellphone providers. e. What conclusions can you reach about the satisfaction rating of traditional cellphone providers who bill for service at the end of a month oftten under a contract and prepaid cellphone service providers who bill in advance without a contract? 10.9 Is there a difference in the satisfaction rating of traditional cellphone providers who bill for service at the end of a month often under a contract and prepaid cellphone service providers who bill in advance without a contract? The file contains the satisfaction rating for 10 traditional cellphone providers and 13 prepaid cellphone service providers. Source: Data extracted from "Carrier Ratings: Why It Pays to Think Small," Consumer Reports, February 2016, p. 51 . a. Assuming that the population variances from both types of cellphone providers are equal, is there evidence of a difference in the mean ratings between the two types of cellphone providers? (Use =0.05.) b. Find the p-value in (a) and interpret its meaning. c. What other assumption is necessary in (a)? d. Assuming that the population variances from both cellphone providers are equal, construct and interpret a 95% confidence interval estimate of the difference between the population means of the two cellphone providers. e. What conclusions can you reach about the satisfaction rating of traditional cellphone providers who bill for service at the end of a month oftten under a contract and prepaid cellphone service providers who bill in advance without a contract

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!