1 Answer

Alba Mendez · Answer 1 · 2019-07-31T07:14:07+0000

Steps:
1. Input the data in Excel
2. Find maximum and minimum values (2 and 87 respectively)
3. Calculate the range, that is,
Range = (maximum -minimum)/Number of intervals. For 10 intervals;
Range = (87-2)/10 = 8.5
4. Generate the Bin. That is,
From minimum and adding range until the maximum value.
Using Histogram tool in Excel, the histogram was generated as shown in the figures attached.

Create a histogram for the data set. 71, 55, 3, 34, 35, 54, 87, 2, 28, 27-example-1

Create a histogram for the data set. 71, 55, 3, 34, 35, 54, 87, 2, 28, 27-example-2

Create a histogram for the data set. 71, 55, 3, 34, 35, 54, 87, 2, 28, 27-example-3

0 Comments

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

0 Comments

Please log in or register to add a comment.

Other Questions