Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

The Excel file Cell Phone Survey reports opinions of a sample of consumers regarding the signal strength value for the dollar, and customer service for

The Excel file Cell Phone Survey reports opinions of a sample of consumers regarding the signal strength value for the dollar, and customer service for their cell phone carriers. Use PivotTables to find the following:

a. the average signal strength by type of carrier

b. average value for the dollar by type of carrier and usage level

c. variance of perception of customer service by

carrier and gender What conclusions might you reach from this information?

Note: I need excel docs. Kindly share your docs file. Thank you

image text in transcribed

Cell Phone Survey.xlsx - Microsoft Excel (Product Activation Failed) 9fe-5 Home Insert File Page Layout Formulas Data Review View OP X H J K L M M N N 0 P R AT&T 31 17 F H9 f A B D E F G 3 Gender Carrier Type Usage Signal strengtl Value for the Doll Customer Service 4 M AT&T &T Smart High 5 4 41 5 M AT&T Smart High 5 5 4 21 6 'M M AT&T Smart Average 4 4 4 41 7 M AT&T Smart Very high 2 3 3 8 IM AT&T Smart Very high 5 5 2 9 M Smart Very high 4 3 5 10 M AT&T Smart Very high 3 4 41 11 F AT&T Smart Very high 3 2 3 12 F AT&T Smart Very high 4 3 41 13 M AT&T Smart Very high 3 3 14 M Other Smart Average 1 2 15 IM Sprint Smart Very high 3 5 49 16 M Sprint Smart Very high 3 5 Sprint Smart Average 2 5 4 18 F Sprint Smart Average 3 5 41 19 M Verizon Smart Average 4 3 31 20 F Verizon Smart Very high 4 3 2 21 M Verizon Smart Very high 5 5 51 22 F Verizon Smart Average 3 3 23 IM Verizon Smart Very high 4 4 23 24 F Verizon Smart Very high 4 5 31 25 M AT&T Camera Average 5 4 5 26 M AT&T Camera Very high 2 1 31 AT&T Camera Average 2 4 31 28 F AT&T Camera Very high 3 3 3 31 29 M AT&T Camera Average 5 5 31 30 F AT&T Camera Average 4 3 34 31 M AT&T Camera Average 4 2 4 32 F AT&T Camera Very high 2 4 11 AT&T Camera Average 2 4 3 34 M AT&T Camera Average 3 3 3 4 35 F AT&T Camera Very high 3 2 AT&T Camera Very high 4 3 38 37 F AT&T Camera Low 4 2 KI Data Select destination and press ENTER or choose Paste 27 M 33 F 36 M 38 D IIII 100% i Type here to search o 75F 12:25 AM 12/10/2021

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting

Authors: Carl s. warren, James m. reeve, Philip e. fess

21st Edition

978-0324188004

Students also viewed these Accounting questions