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 that 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.

Question

Quizplus · Accepted Answer

To construct a bar chart that illustrates the difference in total sales by department, we need to determine the total sales by department. This will allow us to create a chart with each department represented by a bar of a height proportional to the sales it has achieved. Therefore, we need to calculate the total sales for each department across the 200 days, which will give us the necessary information to make the chart.

The Carter Department Store Has Data on the Sales Volume