Question

Notes:

Please type your work, or 10% credits will be deducted
Show your work for full credits
Follow the six steps for hypothesis testing
If Excel is used, please copy and paste Excel Output as part of your answer

How does cellphone service compare between different cities? The data stored in CellServicee represent the rating of Verizon and AT&T in 22 different cities. (Data extracted
from “Best Phones and Service,” Consumer Reports, January 2012, p. 28, 37.)
At the 0.05 level of significance, is there evidence of a difference in the mean cellphone service rating between Verizon and AT&T?

City	Verizon	AT&T
Atlanta	74	56
Austin	72	61
Boston	69	60
Chicago	73	55
Dallas-Fort Worth	76	65
Denver	72	56
Detroit	73	63
Houston	77	59
Kansas City	74	66
Los Angeles	73	56
Miami	74	61
Milwaukee	74	60
Minneapolis-St.Paul	71	60
New York	71	57
Philadelphia	71	63
Phoenix	76	62
San Diego	74	60
San Francisco	73	53
Seattle	72	59
St. Louis	73	64
Tampa	73	67
Washington D. C.	71	60

Answer 1

STep 1: Bring data in to excel. we need to find any major difference between means (Verizion and AT & T)

Step 2: comparing means is easiest way by using "t-Test: Paired Two Sample for Means" statistics

Step3: go to data tab --> choose data analysis --> choose "t-Test: Paired Two Sample for Means".

Step 4: if data analysis option is not available under data tab then go to excel options in the let mose corner and choose excel-addins and click go option. enable data analysis pak and click ok.

Step 5: Gie your input range in the t-Test: Paired Two Sample for Means input box.

the p-value is less than 0.05, we reject the null hypothesis that there's no difference between the means and conclude that a significant difference does exist.