Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

In the Excel file Cell Phone Survey, test the hypothesis that the mean responses

ID: 2929157 • Letter: I

Question

In the Excel file Cell Phone Survey, test the hypothesis that the mean responses for Value for the Dollar and Customer Service do not differ by gender.

Cell Phone Survey Gender Carrier Type Usage Signal strength Value for the Dollar Customer Service M AT&T Smart High 5 4 4 M AT&T Smart High 5 4 2 M AT&T Smart Average 4 4 4 M AT&T Smart Very high 2 3 3 M AT&T Smart Very high 5 5 2 M AT&T Smart Very high 4 3 5 M AT&T Smart Very high 3 4 4 F AT&T Smart Very high 3 2 3 F AT&T Smart Very high 4 3 4 M AT&T Smart Very high 3 3 1 M Other Smart Average 1 2 4 M Sprint Smart Very high 3 5 4 M Sprint Smart Very high 3 5 3 F Sprint Smart Average 2 5 4 F Sprint Smart Average 3 5 4 M Verizon Smart Average 4 3 3 F Verizon Smart Very high 4 3 2 M Verizon Smart Very high 5 5 5 F Verizon Smart Average 3 3 3 M Verizon Smart Very high 4 4 2 F Verizon Smart Very high 4 5 3 M AT&T Camera Average 5 4 5 M AT&T Camera Very high 2 1 3 M AT&T Camera Average 2 4 3 F AT&T Camera Very high 3 3 3 M AT&T Camera Average 5 5 3 F AT&T Camera Average 4 3 3 M AT&T Camera Average 4 2 4 F AT&T Camera Very high 2 4 1 F AT&T Camera Average 2 4 3 M AT&T Camera Average 3 3 4 F AT&T Camera Very high 3 2 3 M AT&T Camera Very high 4 3 3 F AT&T Camera Low 4 2 3 M Other Camera Average 3 3 3 F Other Camera Average 2 3 3 M Other Camera Average 4 3 4 M Sprint Camera Average 3 4 4 F Verizon Camera Very high 3 4 3 F Verizon Camera Very high 4 3 1 M AT&T Basic Average 3 3 3 M AT&T Basic Average 3 3 2 M AT&T Basic Low 3 3 3 M Other Basic Average 3 3 5 M Other Basic Very high 4 3 3 M Other Basic Very high 1 3 4 M Other Basic Low 4 4 2 F Other Basic Average 2 3 3 F T-mobile Basic Low 3 4 4 M T-mobile Basic Average 3 4 3 M Verizon Basic Low 3 3 4 M Verizon Basic Average 4 2 4

Explanation / Answer

Answer:

In the Excel file Cell Phone Survey, test the hypothesis that the mean responses for Value for the Dollar and Customer Service do not differ by gender.

MINITAB used.

Two-Sample T-Test and CI: Value for the Dollar, Gender

Method

: mean of Value for the Dollar when Gender = F

µ: mean of Value for the Dollar when Gender = M

Difference: - µ

Equal variances are assumed for this analysis.

Descriptive Statistics: Value for the Dollar

Gender

N

Mean

StDev

SE Mean

F

18

3.389

0.979

0.23

M

34

3.441

0.960

0.16

Estimation for Difference

Difference

Pooled
StDev

95% CI for
Difference

-0.052

0.966

(-0.618, 0.513)

Test

Null hypothesis

H: - µ = 0

Alternative hypothesis

H: - µ 0

T-Value

DF

P-Value

-0.19

50

0.853

Calculated t=-0.19, P=0.853 which is > 0.05 level. Ho is not rejected.

We conclude that the mean responses for Value for the Dollar do not differ by gender.

Two-Sample T-Test and CI: Customer Service, Gender

Method

: mean of Customer Service when Gender = F

µ: mean of Customer Service when Gender = M

Difference: - µ

Equal variances are assumed for this analysis.

Descriptive Statistics: Customer Service

Gender

N

Mean

StDev

SE Mean

F

18

2.944

0.873

0.21

M

34

3.382

0.985

0.17

Estimation for Difference

Difference

Pooled
StDev

95% CI for
Difference

-0.438

0.948

(-0.993, 0.117)

Test

Null hypothesis

H: - µ = 0

Alternative hypothesis

H: - µ 0

T-Value

DF

P-Value

-1.58

50

0.119

Calculated t=-1.58, P=0.119 which is > 0.05 level. Ho is not rejected.

We conclude that the mean responses for Customer Service do not differ by gender.

: mean of Value for the Dollar when Gender = F

µ: mean of Value for the Dollar when Gender = M

Difference: - µ