Chapter 19, Problem 1P

The scores of a test for an engineering class of 30 students are shown here. Organize the data in a manner similar to Table 19.1 and use Excel to create a histogram.

Scores: 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84

To determine

Create a histogram for the test scores of an engineering class students using Excel.

Explanation of Solution

Given data:

Number of students, $n=30$.

Students test scores are 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84.

Calculation:

The given test scores are organized in a grouped frequency distribution manner which is shown in Table 1. In the distribution, the frequency represents the number of test scores in a given range.

Table 1

Scores	Range	Frequency $\left(f\right)$
57, 55, 58, 51, 52	50-59	5
66, 62, 61, 66, 66, 63	60-69	6
77, 75, 78, 74, 72, 70, 75, 73, 79, 77	70-79	10
81, 86, 87, 82, 88, 84	80-89	6
94, 97, 91	90-99	3

Draw the histogram for the students test scores for the respective frequency $\left(f\right)$ value in Excel sheet by selecting the two columns of “range” and “frequency” and go to “insert tab” and click “column bar chart” and select “2-D column”, then the graph will be plotted as shown in Figure 1.

Therefore, the histogram for the test scores of engineering class students is shown in Figure 1.

Conclusion:

Thus, the histogram for the test scores of an engineering class students has been created using Excel.