MindTap-Cengage Learning TAP Assignment at 11 PM EDT eBook O Refer to the data s
ID: 3298927 • Letter: M
Question
MindTap-Cengage Learning TAP Assignment at 11 PM EDT eBook O Refer to the data set in Table 1.7 as shown below: Excel File: data01-05.xisx TABLE 1.7 DATA FOR EIGHT CORDLESS TELEPHONES Overall Handset Talk Time Price (S) Score Volce Quality on Base Hours) Brand Model AT&T; CL84100 60 Excellent Very Good Very Good Very Good Very Good Very Good Excellent Very Good 73 70 Yes AT&T; TL 92271 Panasonic 47738 Panasonic 6592T Uniden D2997 Uniden D1788 72 73 72 13 13 10 Vlech 50 a. What is the average pnice for the cordiess telephones (to 2 decimals)? b. what is the average talk time for th·codless telephones to 3 decimals? e. what percentage of the cordiess telephones have a voice quaity of excelient? d. What percentage of the cordess telephones have a nandset on the base?Explanation / Answer
a) Th average price for the cordless telephones are = 545/8 = $68.125
b) the average talktime for cordless phones are = 71/8 = 8.875hours
c) Percentage of cordless phones have voice quality of excelent = (2/8)*100 = 25%
d) Percenage of Cordlss phones have handset on base = (4/8)*100= 50%