# Question: Calculate the following quantities using Excel a Find the value

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 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?

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?

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

A manufacturing company’s quality control personnel have recorded the proportion of defective items for each of 500 monthly shipments of one of the computer components that the company produces. The data are in the file ...The file P02_16.xlsx contains the number of arrivals at a turnpike tollbooth for each of four 5-minute intervals for each of 256 days. For this problem, assume that each column, such as arrivals from 8:00 AM to 8:05 AM, is a ...A market research consultant hired by a leading soft drink company wants to determine the proportion of consumers who favor its low-calorie brand over the leading low-calorie competitor in a particular geographic region. A ...A company employs two shifts of workers. Each shift produces a type of gasket where the thickness is the critical dimension. The average thickness and the standard deviation of thickness for shift 1, based on a random sample ...Continuing Problem 32, suppose that the officials in this city want to estimate the proportion of taxpayers whose annual real estate tax payments exceed $2000. a. What sample size is required to generate a 99% confidence ...Post your question