Answer
The histogram for column e10mn, e10med , e20mn, e20med, e40mn, e40med and e80mn, e80med is:
Work Step by Step
To construct frequency histogram using Excel, the steps are listed below.
Step 1: Go to graph->histogram->simple->ok.
Step 2: Set the graph variable. The histogram will be obtained.
It can be seen from the graphs that as the sample size is increasing, the shape of the histogram is tending to be a bell-shaped graph. So, as the sample size increases, the sample mean and median distribution tends to be a normal distribution. For sample mean, with an increase in size, it tends to be normal but for size 80 it is slightly right-skewed.
