Question: 2. Use the Excel data file x104-80 on ecentennial. The temperature in Canada in December is often below 40 degrees. The manager of the concession

2. Use the Excel data file x104-80 on ecentennial. 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 writ 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 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
