Question

Referring to Chapter 2 Excel Guide, EG2, Section EG2.4 in the textbook, create a histogram on some sample data using Microsoft Excel. Post your file to the Main Forum in response to this DQ. What are some specific challenges related to creating a histogram in Microsoft Excel?

Answer 1

We create a histogram based on some data using Excel. On having a data we have to dicide upon making the class limits. Once we get the Class limits we store them as bins in a column of Excel. The we procced to make the histogram. Screen shot of the work is given below. The data in raw form is also given.

data: 23.8,19.7,7.5,32.6,15.8,22,8.6,21.5,11,10.2,28.3,19.7,31.6,22.4,8.5,20.2,33.6,7.9,11.2,12.1,12.7,18.5,46.8,25.3,15.9,27.8,2.3,15.1,29.7,18.7,9.3,32.4,30.4,20.6,6.2,37.8,15.4,18.3,27.1,31.5,8.6,3.2,9.6,37.2,17.1,2.9,6.86,16.2,32.1,16.9