# Question: Calculate the following quantities using Excel a P 2 00 t10

Calculate the following quantities using Excel.

a. P(-2.00 ≤ t10 ≤ 1.00), where t10 has a t distribution with 10 degrees of freedom.

b. P(-2.00 ≤ t100 ≤ 1.00), where t100 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?

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?

d. Find the 68th percentile of the t distribution with 20 degrees of freedom.

e. Find the 68th percentile of the t distribution with 3 degrees of freedom. How do you explain the difference between this result and the result obtained in part d?

a. P(-2.00 ≤ t10 ≤ 1.00), where t10 has a t distribution with 10 degrees of freedom.

b. P(-2.00 ≤ t100 ≤ 1.00), where t100 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?

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?

d. Find the 68th percentile of the t distribution with 20 degrees of freedom.

e. Find the 68th percentile of the t distribution with 3 degrees of freedom. How do you explain the difference between this result and the result obtained in part d?

## Answer to relevant Questions

Calculate the following quantities using 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 ...Continuing Problem 5, generate a random sample of 50 players for each of the eight years in the P08_05.xlsx file. For each of these samples, construct a 95% confidence interval for the mean total salary for that year. What ...The employee benefits manager of a large public university would like to estimate the proportion of full-time employees who prefer adopting the first (plan A) of three available health care plans in the next annual ...The Wall Street Journal CEO Compensation Study analyzed CEO pay from many U.S. companies with fiscal year 2008 revenue of at least $5 billion that filed their proxy statements between October 2008 and March 2009. The data ...In past years, approximately 20% of all U.S. families purchased potato chips at least once a month. You are interested in determining the fraction of all U.S. families that currently purchase potato chips at least once a ...Post your question