1:214 ( Back BAN 280 Homework 6.docx shows temperature and unit sales over 20 days. Answer the following questions. a. Develop a scatter chart for these data with temperature as the independent variable describe what the scatter chart indicates about the relationship between temperature and sales? b. Develop an estimated regression equation showing how sales is related to temperature. What is the estimated regression model equaon? c. How much of the variation in the sample values of sales does the model estimated explain (what is R2)? Is the model a good fit? d. What is the correlation between sales and temperature? e. Based on Significance F, is the model a good fit overall? f. EXTRA CREDIT: Predict the sales of ice cream if the temperature is 86. 2. Auto Champions provides a variety of vehicles. MPG is impacted by a variety of factors with engine size being one of them. We want to investigate the relationship between MPG and engine size. The Auto Champions tab shows MPG and engine size for 15 vehicles. Answer the following questions. a. Develop a scatter chart for these data with engine size as the independent variable m describe what the scatter chart indicates about the relationship between engine size and MPG? b. Develop an estimated regression equation showing how MPG is related to engine size. What is the estimated regression model equaon? c. How much of the variation in the sample values of MPG does the model estimated explain (what is R2)? Is the model a good fit? d. What is the correlation between MPG and engine size? 6. Based on P-value, is engine size statistically significant? f. EXTRA CREDIT: Predict the MPG if engine size is 280. a E Q E Dashboard Calendar To Do Notications Inbox 1:21 7 .0 5GE BAN 280 Homework 6 - Excel Data File.... Ice Cream Sales Auto Champions MPG Engine Size 27 250 29 122 24 97 25 91 23 113 20 98 21 97 13 140 14 122 15 350 14 400 17 318 11 351 13 304 19 350 OF 5 000 Dashboard Calendar To Do Notifications Inbox1:214