Question

The Carter Department Store has data on the sales volume by department for the past 200 days. The data are in an Excel spreadsheet where column A represents the department name and column B represents the sales for each day in that department. In order to construct a bar chart that illustrates the difference in total sales by department for the 200 days, a required step in Excel will be to:

A) determine the total sales by department.

B) use the frequency function to count the number of occurrences by department.

C) group the data into 5 to 20 classes.

D) determine the class widths.

Answer

This answer is hidden. It contains 10 characters.