Question

Please help show me how to run this in excel for Statics

Example:

1) =NORM.INV()

2) =NORM.INV()

3) =NORM.INV()

4) =NORM.INV()

5) =NORM.INV()

6) =NORM.INV()

7) =NORM.INV()

8) =NORM.INV()

9) =NORM.INV()

10) =NORM.INV()

This is the Statics Question:

For questions 1-5, X1, X2, ... , X23 is a random sample from a distribution with mean μ = -1.02 and variance σ2 = 0.62.

For questions 5-10, X1, X2, ... , X28 is a random sample from a distribution with mean μ = -8.77 and variance σ2 = 1.28.

1. Find μx, the mean of the sample average.

2. Find σ2x, the variance of the sample average.

3. Find P(X ≤ -1.14).

4. Find P(X > -1.14).

5. Find P(-1.08 < X ≤ -0.94).

6. Find μx, the mean of the sample average.

7. Find σ2x, the variance of the sample average.

8. Find P(X ≤ -8.47).

9. Find P(X > -8.47).

10.Find P(-9.02 < X ≤ -8.64).

Answer 1