Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

09 Mar 2023

Posted on:

06 Mar 2023

0

Resolved: How to make a z-table?

We were given a z-table in the Course notes and it helped with Tasks 2 & 3 of the exercise, but what if we didn't have one? How would we make it? I have to admit I had to study the solution file very closely to understand what the correct answer was, and I had to watch the lesson multiple times . I did get the right answer for Tasks 2 & 3 eventually!

4 answers ( 1 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

08 Mar 2023

5

Hi Dylan,


This is what I have done (as attached at the bottom of the message).


In the first row I put 0.00, 0.01, ..., 0.09 and in the first column I put 0.0, 0.1, 0.2, ..., 3.5.  In Cell B2, I input the formula "=NORM.S.DIST($A2+B$1,TRUE)".  Afterwards, drag the formula to the rest of the table and the z-table is completed. 


Due to the symmetry property of the standard normal, I only include the positive z-value.


Hope this helps 


Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

08 Mar 2023

1

Thank you for this detailed answer! This may be an obvious answer but is there a reason you stopped at 0.09 and 3.5 respectively? Could you make the row extend to 1 and column to 15 for example? I don't understand the row or column limits of the z-table.

Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

09 Mar 2023

3

The column value (0.00, 0.01,..., 0.09) refers to the 2nd decimals of the z value.  For example, if z = 1.23, I will look for the row with value 1.2 and the column with value 0.03.  Hence, the value of P(Z<1.23) = 0.8907.  Of course , we can directly ask Excel to compute the exact value (I.e. =NORM.S.DIST(1.23, TRUE) ) instead of using the table.


Regarding the row extending to 15, there is no need to do this because when z is greater than 3.5 or even 4, the value in the table is very close to 1.

Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

09 Mar 2023

1

Thank you for this useful information and explanations Eugene!

Submit an answer