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
t and normal distributions Part a x with Pt10... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (3 attachments)
1209_60bca5b25fcbc_564788.pdf
180 KBs PDF File
1209-M-S-D-A(8817).xlsx
300 KBs Excel File
1209_60bca5b25fcbc_564788.docx
120 KBs Word File
