Question: data set in table as shown below: Excel File: data01-05.xlsx Brand Model Price ($) Overall Score Voice Quality Talk Time (hours) AT&T CL84100 60 73
data set in table as shown below: Excel File: data01-05.xlsx Brand Model Price ($) Overall Score Voice Quality Talk Time (hours) AT&T CL84100 60 73 Excellent 7 AT&T TL92271 80 70 Very Good 7 Panasonic 4773B 100 78 Very Good 13 Panasonic 6592T 70 72 Very Good 13 Uniden D2997 45 70 Very Good 10 Uniden D1788 80 73 Very Good 7 Vtech DS6521 60 72 Excellent 7 Vtech CS6649 50 72 Very Good 7 a. What is the average price for the phones (to 2 decimals)? b. What is the average talk time for the phones (to 3 decimals)? hours c. What percentage of the phones have a voice quality of excellent (to the nearest whole number)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
