EXCEL ASSIGNMENT

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.

Use printscreen to show the results and indicate the relevant dataon the Excel output.

2.

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.

Use printscreen to show the results and indicate the relevant data on 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?

Use printscreen to show the results, indicate the relevant data on the Excel output, and state the conclusion.

8. Last year, the class average mark in Professor Smith's history class was 100 (out of 150). In order to raise the class average mark, he has been providing extra tutorials. From a sample of 100 students, the sample average was 106 and the sample standard deviation was 35 marks. Using a 1% level of significance, has Professor Smith managed to raise the class average mark?

Use printscreen to show the results, indicate the relevant data on the Excel output, and state the conclusion.

9. In order to determine whether 50% of adult Canadians are married, STATSCAN conducted its own survey of 100 people and found that 47% were married. Using a 5% level of significance, is it true that 50% of adult Canadians are married?

Use printscreen to show the results, indicate the relevant data on the Excel output, and state the conclusion.

10. To test whether aspirin is effective in preventing heart attacks, 902 patients were given aspirin and 802 were not given aspirin. Data on the number of heart attacks was recorded as follows:

ASPIRIN: x₁ = 152 n₁=902 ₁ = .168

NO ASPIRIN: x₂ = 162 n₂=802 ₂= .201

Assume Case 1. Using Excel and a 1% level of significance, is the percentage of heart attacks significantly less with patients who took aspirin?

Use printscreen to show the results, indicate the relevant data on the Excel output, and state the conclusion.

11. A random sample of male and female drivers were asked how many miles he or she drove in the last year. The data was recorded as follows:

MALES: n₁=18 s₁²=9.07 ₁=359.51

FEMALES: n₂=17 s₂²=9.16 ₂=363.62

Using Excel and a 5% level of significance, can we conclude that male and female drivers differ in the number of miles driven? Assume equal population variances.

Use printscreen to show the results, indicate the relevant data on the Excel output, and state the conclusion.

12. SUPER SALADS makes salad dressings containing oil and vinegar. A litre of Italian dressing generates $1.75 profit and requires .5 litres of oil and .4 litres of vinegar. A litre of French dressing generates $3.12 profit and requires .6 litres of oil and .8 litres of vinegar. SUPER SALADS would like to maximize its profit but only has 20 litres of oil and 17 litres of vinegar left. How many litres of Italian and French salad dressing should SUPER SALADS make?

Use the EXCEL Solver feature to solve the problem.

Use printscreen to show the results and the formulas, and indicate the conclusion.