Question

Soma recorded in the table the height of each player on the basketball team

Basketball Players’ Heights (in inches)
66	66	68	57	64
65	67	67	64	65

Construct a normal probability distribution curve for this population! Indicate the number for the mean, 1SD, 2SD and 3SD (both sides of the mea) (1+ 6*0.5=4p)

Answer 1

I'll answer this with the help of MS Excel.

First, us take the given values in column A in ascending order. Now we need to calculate mean and standard deviation in excel before calculating the normal distribution and then we can make the excel normal distribution graph.

First calculate Mean of the data i.e. average of the data, in Cell D1 write the AVERAGE formula.

Now we will calculate the standard deviation for the given data, so in the cell, D2 write the STDEV.S formula.

For 1SD : 1st standard deviation above = mean + standard deviation

For 2SD : 2nd standard devation above = mean + 2standard deviation

For 3SD : 3rd standard devation above = mean + 3standard deviation

3rd standard deviation below = mean - 3standard deviation

Now in cell B2, we will calculate the normal distribution by the built-in formula for excel. Write down the NORM.DIST formula in cell B2 and drag to fill the column with data.

In cell B2 we have the normal distribution for the data we have chosen. To make a normal distribution graph go to Insert tab and in Charts select scatter chart with smoothed lines and markers.

When we insert the chart we can see that our bell curve or normal distribution graph is created as shown below: