Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »
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 work for each question.
Answered Same Day Mar 02, 2021

Solution

Mohammad Wasif answered on Mar 04 2021
142 Votes
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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here