Question

How do i plot the frequency distribution and normal PDF of these figures to give me histogram showing a bell shaped pdf in excel

3.8 4.6 4.6 4.9 5.2 5.3 5.3 5.4 5.6 5.6 5.7 5.8 5.9 6.0 6.1 6.1 6.3 6.3 6.4 6.5 6.6 6.8 7.0 7.4 7.6

Answer 1

Steps to plot the frequency distribution:

1) Click the Data tab’s Data Analysis command button to tell Excel that you want to create a frequency distribution and a histogram.

2) When Excel displays the Data Analysis dialog box, select Histogram from the Analysis Tools list and click OK.

3) In the Histogram dialog box that appears, identify the data that you want to analyze.

4) Tell Excel where to place the frequency distribution and histogram.

5) Click OK.