Question

You are given a dataset of test scores: 55, 60, 65, 70, 75, 80, 85, 90, 95, 100. You want to create a histogram to visualize the distribution of these test scores. Which of the following is not a valid step when creating a histogram in Excel?

A Determine the bin ranges based on the distribution of the data.
B Use the "Insert" tab and select "Histogram" chart under "Charts".
C Specify the number of bins based on how granular you want the grouping of data to be.
D Ensure that each bin contains at least one data point.
E Change the chart type to a "Column Chart" after selecting the data.
Practice Next

Hey! Ask a query