Discuss the below:
• Here are tables of the Standard Normal and Student's t distributions. The formulas for the first value in each P column are, respectively =NORMSDIST(A3) and =TDIST(C3,20,2), where column A is the one labeled "Z" and column C is labeled "t".
1) What is the meaning of the number given in the P column under NORMSDIST?
2) What is the meaning of the number given in the P column under TDIST?
• Please do not discuss how this table of numbers applies to hypothesis testing. Instead, focus on what these numbers mean.
|
NORMSDIST
|
TDIST
|
|
Z
|
P
|
T
|
P
|
|
0.0
|
|
0.1
|
|
0.2
|
|
0.3
|
|
0.4
|
|
0.5
|
|
0.6
|
|
0.7
|
|
0.8
|
|
0.9
|
|
1.0
|
|
|
0.5000
|
|
0.5398
|
|
0.5793
|
|
0.6179
|
|
0.6554
|
|
0.6915
|
|
0.7257
|
|
0.7580
|
|
0.7881
|
|
0.8159
|
|
0.8413
|
|
|
0.0
|
|
0.1
|
|
0.2
|
|
0.3
|
|
0.4
|
|
0.5
|
|
0.6
|
|
0.7
|
|
0.8
|
|
0.9
|
|
1.0
|
|
|
1.0000
|
|
0.9213
|
|
0.8435
|
|
0.7673
|
|
0.6934
|
|
0.6225
|
|
0.5552
|
|
0.4920
|
|
0.4331
|
|
0.3788
|
|
0.3293
|
|