Question: EXCEL ASSIGNMENT P.S ( I need all these answers in excel with formula) Use the Excel data file Xr04-94: Increasing tuition has resulted in some

EXCEL ASSIGNMENT

P.S ( I need all these answers in excel with formula)

Use the Excel data file Xr04-94:

Increasing tuition has resulted in some students being saddled with large debts upon graduation. To examine this issue, a random sample of recent graduates was asked to report how much debt they had upon graduation. Use Excel to calculate the following:

The mean and the median of the data.

The variance and the standard deviation of the data.

2. Use the Excel data file Xr04-80

The temperature in Canada in December is often below 40 degrees. The manager of the concession stand in an outdoor football stadium has noticed a correlation between temperature and the number of cups of coffee she sells. Use Excel to calculate the following.

Compute the covariance and coefficient of correlation. Interpret the coefficient of correlation, and put your written answer on the page with the Excel output.

Using a scatter diagram, determine the equation of the least squares line. Describe what the line tells you about the relationship between temperature and coffee sold, and write your answer on the page with the Excel output.

3. PLATINUM PRODUCTS sells jewelry. The lengths of necklaces that it sells are normally distributed with a population average length of 18.73 inches and a population standard deviation of 2.98 inches. Use Excelto calculate the probability that a necklace selected at random will be 23.14 inches or less?

Use printscreen to show the results and the formulas.

4. A parking control officer is conducting an analysis of the amount of time left on parking meters. A survey of 34 cars that have just left their metered parking spaces produced a sample mean of 41.55 minutes and a sample standard deviation of 6.31 minutes. Use Excel, to estimate with 95% confidence, the mean amount of time left for all the city's meters.

Use printscreen to show the results.

5. The amount of time teenagers spend weekly working at part-time jobs has a population standard deviation of 29 minutes.A random sample of 117 teenagers was drawn and the sample average was 617.02 minutes. Using a 99% confidence level, use Excel to estimate the population average amount of time spent at part-time jobs.

Use printscreen to show the results.

6.In a survey, 504 presidents of large companies were asked whether they had an MBA degree. 41% of the presidents said that they did. Use Excel, to estimate with 95% confidence, the proportion of all presidents of large companies who have MBAs.

Use printscreen to show the results.

7. A national car magazine says that it takes 15 minutes to change a tire. The manager at COUGAR MOTORS feels his mechanics take less time. A sample of 25 customers showed that it took the company 14.30 minutes to change a tire. The population standard deviation is 2 minutes. Using a 10% level of significance, do the mechanics take less time?