Answered! manager of Sarah's Ice c cream. The store orders ice cream from a distributor a week ahead, and if too little is…

Please use Excel
manager of Sarahs Ice c cream. The store orders ice cream from a distributor a week ahead, and if too little is ordered the store loses business. If it orders too much, it must be thrown away.The manager believes that a major determinant of ice cream sales is temperature, that is, the hotter it is, the more ice cream people buy. Using an almanac, the manager determined the average temperature for 10 weeks selected at random and then, from store records, has determined the ice cream consumption for the same 10 weeks.The data are summarized as follows:
media%2F87e%2F87e69f4c-9a30-4a80-a656-65

manager of Sarah’s Ice c cream. The store orders ice cream from a distributor a week ahead, and if too little is ordered the store loses business. If it orders too much, it must be thrown away.The manager believes that a major determinant of ice cream sales is temperature, that is, the hotter it is, the more ice cream people buy. Using an almanac, the manager determined the average temperature for 10 weeks selected at random and then, from store records, has determined the ice cream consumption for the same 10 weeks.The data are summarized as follows:

Expert Answer

 (a) Simple linear regression to model the relationship between average temperature and ice-cream sold is as follows

Answered! manager of Sarah's Ice c cream. The store orders ice cream from a distributor a week ahead, and if too little is... 1

Forecast of ice-cream consumption for temperature of 86 = -6.7789 + 1.5489*86 = 126.4265

Don't use plagiarized sources. Get Your Custom Essay on
Answered! manager of Sarah's Ice c cream. The store orders ice cream from a distributor a week ahead, and if too little is…
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay

(b) Prediction of y using correlation is as follows

Answered! manager of Sarah's Ice c cream. The store orders ice cream from a distributor a week ahead, and if too little is... 2

We see that both prediction using linear regression and correlation yield same result.

Still stressed from student homework?
Get quality assistance from academic writers!