Tell Excel where to place the frequency distribution and histogram.If your data ranges include labels, select the Labels check box. In the case of the example worksheet, the bin range is $E$1:$E$12. To identify the bins that you use for the frequency distribution and histogram, enter the worksheet range that holds the bins into the Bin Range text box. If you want to create a frequency distribution and histogram of unit sales data, for example, enter the worksheet range $B$1:$B$38 into the Input Range text box. Use the Input Range text box to identify the data that you want to use to create a frequency distribution and histogram. In the Histogram dialog box that appears, identify the data that you want to analyze.When Excel displays the Data Analysis dialog box, select Histogram from the Analysis Tools list and click OK.Click the Data tab’s Data Analysis command button to tell Excel that you want to create a frequency distribution and a histogram.To create a frequency distribution and a histogram, follow these steps: The bins information shown in the worksheet range E1:E12, for example, create hundred-unit bins: 0-100, 101-200, 201-300, and so on. The bins information shows Excel exactly what bins (categories) you want to use to categorize the unit sales data. This worksheet shows bins information in the worksheet range E1:E12. The histogram plots out how many times your data falls into each of these categories. To use the Histogram tool, you first need to identify the bins (categories) that you want to use to create a frequency distribution. Here’s an example of how all this works - everything will become clearer if you’re currently confused. A histogram shows the same information in a cute little column chart. A frequency distribution shows just how values in a data set are distributed across categories. By In Excel, you can use the Histogram Data Analysis tool toand, optionally, a histogram chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |