# Question: Calculate the following probabilities using Excel a P t10 1 75

Calculate the following probabilities using Excel.

a. P(t10 ≥ 1.75), where t10 has a t distribution with 10 degrees of freedom.

b. P(t100 ≥ 1.75), 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(Z ≥ 1.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 these probabilities?

d. P(t20 ≤ 0.80), where t20 has a t distribution with 20 degrees of freedom.

e. P(t3 ≤ 0.80), where t3 has a 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(t10 ≥ 1.75), where t10 has a t distribution with 10 degrees of freedom.

b. P(t100 ≥ 1.75), 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(Z ≥ 1.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 these probabilities?

d. P(t20 ≤ 0.80), where t20 has a t distribution with 20 degrees of freedom.

e. P(t3 ≤ 0.80), where t3 has a t distribution with 3 degrees of freedom. How do you explain the difference between this result and the result obtained in part d?

**View Solution:**## Answer to relevant Questions

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 ...The manager of a local fast-food restaurant is interested in improving the service provided to customers who use the restaurant’s drive-up window.As a first step in this process, the manager asks an assistant to record the ...The same data as in the previous problem are stored in a different format in the last two sheets of the P08_15.xlsx file.a. Use StatTools to find a 95% confidence interval for the proportion who favor Crest from the data in ...A real estate agent has collected a random sample of 75 houses that were recently sold in a suburban community. She is particularly interested in comparing the appraised value and recent selling price of the houses in this ...You are trying to estimate the average amount a family spends on food during a year. In the past the standard deviation of the amount a family has spent on food during a year has been approximately $1000. If you want to be ...Post your question