Extraprice Rental Car rented 6 different vehicle types last year at the frequencies shown in the table:
a. Prepare a frequency columnar chart [use Excel for parts a, b & c]
Vehicle Type
Frequency
Sub-compact
545
Compact
892
Full-size
740
Luxury
360
SUV
280
Van
168
Total
2985
b. Prepare a relative frequency columnar chart
c. Prepare a pie chart showing relative frequency
d. If a 20 % increase in all rentals is expected for next year, how many luxury rentals should they expect?