Question: Calculate the following quantities using Excel. (If you have Excel 2010 or later, we suggest using its new functions.) a. Find the value of x

Calculate the following quantities using Excel. (If you have Excel 2010 or later, we suggest using its new functions.)

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?

Step by Step Solution

3.36 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

t and normal distributions Part a x with Pt10... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (3 attachments)

PDF file Icon

1209_60bca5b25fcbc_564788.pdf

180 KBs PDF File

Excel file Icon

1209-M-S-D-A(8817).xlsx

300 KBs Excel File

Word file Icon

1209_60bca5b25fcbc_564788.docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!