Question
The manager of Gilleys Ice Cream Parlor needs an accurate forecast of the demand for ice cream. The store orders ice cream from a distributor
The manager of Gilley’s Ice Cream Parlor needs an accurate forecast of the demand for ice cream. The store orders ice cream from a distributor a week ahead; if the store orders too little, it loses business, and if it orders too much, the extra must be thrown away. The manager believes that a major determinant of ice cream sales is the temperature (i.e., the hotter the weather, the more ice cream people buy). Using an almanac, the manager has determined the average day time temperature for 14 weeks, selected at random, and from store records, he has determined the ice cream consumption for the same 14 weeks. These data are summarized as follows:
a. Develop a linear regression model for these data and forecast the ice cream consumption if the average weekly daytime temperature is expected to be 85 degrees.
b. Determine the strength of the linear relationship between temperature and ice cream consumption by using correlation.
c. What is the coefficient of determination? Explain its meaning
Gilley's Ice Cream Parlor | |||
x | y | ||
Ave. Temp | Ice cream Sold | ||
Week | (degrees) | (gal.) | |
1 | 68 | 80 | |
2 | 70 | 115 | |
3 | 73 | 91 | |
4 | 79 | 87 | |
5 | 77 | 110 | |
6 | 82 | 128 | |
7 | 85 | 164 | |
8 | 90 | 178 | |
9 | 85 | 144 | |
10 | 92 | 179 | |
11 | 90 | 144 | |
12 | 95 | 197 | |
13 | 80 | 144 | |
14 | 75 | 123 | |
Place regression output here |
(a) | Y = A + Bx | ||||||
A = | |||||||
B = | |||||||
(b) | Correlation Coefficient | ||||||
(c') | Coefficient of Determination | ||||||
Explain the meaning of the coefficient of Determination below. What does it indicate? |
Average Temperature Ice Cream Sold Week (Degrees) (gal.) 1 68 80 2 70 115 3. 73 91 4 79 87 5 77 110 6. 82 128 7 85 164 8. 90 178 9. 85 144 10 92 179 11 90 144 12 95 197 13 80 144 14 75 123
Step by Step Solution
3.42 Rating (158 Votes )
There are 3 Steps involved in it
Step: 1
Gilleys Ice Cream Parlor x y Ave Temp Ice cream Sold Week degrees x galy XY X2 Y2 1 68 80 5...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 1 attachment)
607010246daed_711934.xlsx
300 KBs Excel File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started