Calculate the following quantities using Lxcel. (U yeu have Excel 2010 or latet, we suggest using its new functions.) Ro

[answerhappygod]

Calculate The Following Quantities Using Lxcel U Yeu Have Excel 2010 Or Latet We Suggest Using Its New Functions Ro 1 (30.95 KiB) Viewed 38 times

Calculate the following quantities using Lxcel. (U yeu have Excel 2010 or latet, we suggest using its new functions.) Round your answers to four decimal places, if necessary. a. P(−2.00≤40≤1.00), where tro has a t distrbution with 10 degrees of freedom. b. P(-2.00 ≤1 tso ≤1.00), where tsoo has a t distribution with 100 degrees of freedom. How do you explain the difference between this result and the one obtained in part al? The variance uf t with a large df is than a t aith a small di, C. P−2.00≤Z≤1.00), ​ where Z is a standard normal random vanable. Cempore this pesult to the results obenined in parts a and b. How do you explain the diterences in theae probubstues? The varanci of z is than the variance of t. (4) (3) The variance od 1 whth a smat ulf in than a 1 with a large du!