Please complete question 15, 17, 20. a,b,c. Please Show all your work in Excel spreadsheets (not in Words files or pdf files); (2) Show both your manual work "and" the available Excel stats functional...

Q 15
    Sample Mean Range    5
    Mean    200
    Standard Deviation    50
    Sample Size    100
    a)
    z value for 195    -1
    z value for 205    1
    P (z < -1)    0.1587
    P (z < 1)    0.8413
    P (195 < x-bar < 205 )    0.6827
    b)
    z value for 190    -2
    z value for 210    2
    P (z < -2)    0.0228
    P (z < 2)    0.9772
    P (190 < x-bar < 210 )    0.9545
Q 17
    a)
    Sample size    50
    Standard Deviation    10
    Now,
    Standard...