I need help solving the answer in EXCEL. a. Find the value of x such that P(t10

Question

I need help solving the answer in EXCEL.

a. Find the value of x such that P(t10 > x) = 0.75, where t10 has a t distribution with 10 degrees of freedom.

b. Find the value of y such that P(t100 > y) = 0.75, where t100 has a t distribution with 100 degrees­ of freedom. How do you explain the difference­ between this result and the result obtained in part a?

c. Find the value of z such that P(Z > z) = 0.75, where Z is a standard normal random variable. Compare this result to the results obtained in parts a and b. How do you explain the differences in the values of x, y, and z?

Explanation / Answer

a)

=T.INV((1-0.75),10)

b)

=T.INV((1-0.75),100)

c)

=NORMSINV((1-0.75))

Answer are

As degree of freedom increases t-distribution converges to normal distribution

we see that as we increased df from 10 to 100, t-value became close to z in part c)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.