ID
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
JOB
RACE
AGE
SEX
24.71
2.56 1.35
29.54 1.60
2.02
0.10 0.07
1.50 0.07
25.50
3.00 1.00
25.00 2.00
29.00
3.00 1.00
24.00 2.00
13.99
0.71 0
P(x)
x
0.99
0.01
#7
mean
std dev
P10
1060
0
No way to calculate probabilities in excel
will not have more than 2-4 outcomes on test
100
15
0.1
80.77673
answer is off from the table b/c making approximation on table (not absolute)
Using NormDist function
Mean
90
Std Dev
10
Value
80
p(-inf to value)
15.87%
Using NormInv Function
Mean
90
Std Dev
10
Value
100.3643
p(-inf to value)
0.85
90
10
95
69.15%
53.28%
10
10
3
3
18
20
0.99617 0.999571 0.003401