.How does cellphone service compare between different cities?The data stored in CellService represents the rating of Verizon andAT&T in 22 different cities (Data extracted from “Best Phonesand Services,†Consumer Reports, January 2012, p. 28, 37).Is there evidence of a difference in the mean cellphone servicerating between Verizon and AT&T? (Use a 0.05 level ofsignificance)
I WANT THE ANSWER IN EXCEL USING THE DATAANALYSIS....DO NOT PROVIDE A HAND WRITTENANSWER...I'm trying to understand the functions inexcel
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 |
KansasCity | 74 | 66 |
LosAngeles | 73 | 56 |
Miami | 74 | 61 |
Milwaukee | 74 | 60 |
Minneapolis-St.Paul | 71 | 60 |
NewYork | 71 | 57 |
Philadelphia | 71 | 63 |
Phoenix | 76 | 62 |
SanDiego | 74 | 60 |
SanFrancisco | 73 | 53 |
Seattle | 72 | 59 |
St.Louis | 73 | 64 |
Tampa | 73 | 67 |
Washington D. C. | 71 | 60 |