Open the worksheet labelled "Distributions" in the “Class Exercise 2 Data.xlsx” file.
In cell B3, calculate the probability associated with the Standard Normal distribution Z value that's in cell A3, using the "=NORM.S.DIST( A3 , false )" function. Drag this formula down to calculate the probabilities for the rest of the Z values.
In cell E3, generate the probability associated with the X value from a Student's t distribution with n = 5 (thus the degrees of freedom will equal 4), using the "=T.DIST( D3 , 4 , false )" function. Drag this formula down to calculate the remaining probabilities.
From the graph provided of the resulting distributions, which of the following do you notice?

Question

Open the worksheet labelled "Distributions" in the “Class Exercise 2 Data.xlsx” file. 
 In cell B3, calculate the probability associated with the Standard Normal distribution Z value that's in cell A3, using the "=NORM.S.DIST( A3 , false )" function. Drag this formula down to calculate the probabilities for the rest of the Z values. 
 In cell E3, generate the probability associated with the X value from a Student's t distribution with n = 5 (thus the degrees of freedom will equal 4), using the "=T.DIST( D3 , 4 , false )" function. Drag this formula down to calculate the remaining probabilities. 
 From the graph provided of the resulting distributions, which of the following do you notice?

Answer

The normal distribution has larger tails than the t distribution to account for more uncertainty in population data.

Answer

The t distribution has larger tails than the normal distribution to account for more uncertainty in sample data.

Answer

The normal distribution has larger tails than the t distribution to account for less uncertainty in population data.

Answer

The t distribution has larger tails than the normal distribution to account for less uncertainty in sample data.

Crowdly

Open the worksheet labelled "Distributions" in the “Class Exercise 2 Data.xlsx” ...

Want instant access to all verified answers on learning.monash.edu?