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

[answerhappygod]

Calculate The Following Quantities Using Excel If You Have Excel 2010 Or Later We Suggest Using Its New Functions F 1 (34.49 KiB) Viewed 62 times

Calculate the following quantities using Excel. (If you have Excel 2010 or later, we suggest using its new functions.) Found your answers to four decimal places, if necessary. a. P(−2.00≤t10≤1.00), where tro has a t distribution with 10 degrees of freedom, b. P(−2.00≤ tion ≤1.00}, where troo has a t distribution with 100 degrees of freedom. How do you explain the difference between this result and the one obtained in part a? The variance of t with a targe df is than a t with a small df. C. P(−2.00≤z<1.00), 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 these probabilities? The variance of z is than the variance of t. d. Find the 68t percentile of the t distribution with 20 degrees of freedom. (3) 6. Fied the 68th percentile of the f distribution with 3 degrees of freedom, (3) How do you tiplain the difference between this result and the resiat obtained in part d? the variance of t with a wrall of is than a t with a large df,