![]() ![]() These values are calculated in cells L5 and L6 of Figure 2. What we want is a normal curve with the same mean and standard deviation as the original data. We now need to add the normal curve to this chart. ![]() Next place the formula =COUNTIF($B$4:$B$23,” Charts|Scatter (the Scatter with Straight Lines version), you get the histogram shown on the right side of Figure 1. Here, cell E5 contains the number 3 and cell D11 contains 12 we then place the formula =D9-$E$5 in cell D8, highlight the range D8:D10 and press Ctrl-D. The result is shown in columns D, E and F of Figure 1. We start out by creating a frequency table with bin size of 3 and a maximum bin of 12, as described in Frequency Tables. We now show how to create the histogram with overlay for the data in Example 1 of Using Histograms to Test for Normality. Second, we need a way to scale the normal curve so that the areas match. First, to place the two graphs on the same chart we can’t use a bar chart for the histogram instead, we need to use a scatter plot. There are two complications with this approach. ![]() In this approach, we create a histogram and then add to this chart a normal curve whose area under the curve is the same as the area of the histogram. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |