Question

Age					Formulas
30		Sample size	47
38
27		Sample mean (2 decimals)	31.51		=AVERAGE(A:A)
35
26		Sample Standard Deviation (4 decimals)	4.1852		=STDEV.S(A:A)
36
29		Hypothesized Mean	32
34
33		Test Statistic (3 decimals)	-0.802		=(D4-D8)/(D6/SQRT(D2))
33
29		Degrees of Freedom	46		=D2-1
31
40		p-value (3 decimals)	need this		need this
25
35		Level of Significance (Alpha)	0.05
32
27		Reject Null Hypothesis?			#N/A
31
36
34
34
32
31
31
32
30
39
25
29
31
37
37
31
36
31
27
26
31
26
36
32
25
27
33
25
39
27

hello i have been trying to do this but i can not figure out the formula to get the p-value. i have been using t-distribution. what should i input as a formula to get it correct. my result has bee 0.213 but is wrong.

TIA

Answer 1

Use below formula if your test is one sided: fTDIST(ABS(-0.802),46,1) 0.213338 Or if the test is two sided then use: TDIST(ABS(-0.802),46,2) 0.426677