Рет қаралды 239
#YOUCANLEARNECONOMICS
#ECONOMICS
To create a histogram in Excel, you provide two types of data - the data that you want to analyze, and the bin numbers that represent the intervals by which you want to measure the frequency. You must organize the data in two columns on the worksheet. These columns must contain the following data:
◾ Input data This is the data that you want to analyze by using the Histogram tool.
◾ Bin numbers These numbers represent the intervals that you want the Histogram tool to use for measuring the input data in the data analysis.
When you use the Histogram tool, Excel counts the number of data points in each data bin. A data point is included in a particular bin if the number is greater than the lowest bound and equal to or less than the greatest bound for the data bin. If you omit the bin range, Excel creates a set of evenly distributed bins between the minimum and maximum values of the input data.
The output of the histogram analysis is displayed on a new worksheet (or in a new workbook) and shows a histogram table and a column chart that reflects the data in the histogram table.
Subscribe me @ / ezclassesfaghsa
Like me on Facebook @ / faghsa
Follow me on Twitter @ ?l...
Mail ID: faghsa1760@gmail.com