You will find in A1A250 data that is believed to be generate

You will find in A1:A250 data that is believed to be generated by a normal process. Compile the data into bins of width 5, giving both frequencies and relative frequencies in cells indicated. Give the mean (in cell G2) and standard deviation (in cell H2) of the normal process you believe to be generating the data. Generate the appropriate theoretical data in column F to allow for comparison. Plot a graphical comparison of the theoretical information with the data as a line-chart (use straight lines rather than smooth curves) in H4:L23.

Solution

It is given that the theoretical data is normally distributed. You have found the mean and standard deviation of the data. You can use the random normal variable generator function to find as much theoretical values you want.

Please use the values of mean and standard deviation in the formula above and you will get theoretical values.