Scribd
Upload
25 views2 pages

Exercise 2 - Excel

rththyt

Uploaded by

Shereen Grace Ganibo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
25 views2 pages

Exercise 2 - Excel

rththyt

Uploaded by

Shereen Grace Ganibo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

GANIBO, SHEREEN GRACE M.

A1A - BSA

Contemporary Mathematics for Business and Consumers, Third Edition


Robert A. Brechner
Copyright © 2003 Thomson/South-Western

Level 2
Chapter 21 - Section III - Exercise 1

You are the sales manager of the Esquire Sportswear Company. Last week, your 30
salespersons reported the following automobile mileage while making sales calls to
retail stores around the state:

385 231 328 154 283 86 415 389 575 117


211 432 271 93 515 376 328 183 359 136

a. Group the data into seven classes of equal size (0-99, 100-199, 200-299, 300-399,
etc.) and construct a frequency distribution of the mileage.

Class Tally Frequency


0-99 IIII 4
100-199 IIIII 5
200-299 IIII 4
300-399 IIIII I 6
400-499 III 3
500-599 II 2
600-699 0

b. Calculate the mean of the grouped data by using 49.5, 149.5, 249.5, etc., as the midpoints.

Class Tally Frequency Midpoint (m) fxm


0-99 IIII 4 49.5 198.0
100-199 IIIII 5 149.5 747.5
200-299 IIII 4 249.5 998.0
300-399 IIIII I 6 349.5 2,097.0
400-499 III 3 449.5 1,348.5
500-599 II 2 549.5 1,099.0
600-699 0 649.5 0.0

Totals = 24 6,488

Mean = 926
75 173
88 438

You might also like