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.

Question

Quizplus · Accepted Answer

In order 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 enable us to plot a bar chart with the total sales by department on the y-axis and the department names on the x-axis. The frequency function (B) is used to count the number of occurrences of a particular value or category, which is not useful in this case. Grouping the data into classes (C) and determining class widths (D) are steps used in constructing a histogram, which is not suitable for this scenario since we want to compare total sales by department and not the frequency of sales in different ranges.

The Carter Department Store Has Data on the Sales Volume