Question: 1. What would be the simple linear regression (trend projection) forecast for week 4 for Small Town Restaurant (see downloaded file) if the regression equation

1. What would be the simple linear regression (trend projection) forecast for week 4 for Small Town Restaurant (see downloaded file) if the regression equation for our data is: y = 3061.7 + 0.2364x ? Provide two decimal places and use normal rounding.
2. What would be the simple linear regression (trend projection) forecast for week 53 for Small Town Restaurant (see downloaded file) if the regression equation for our data is: y = 3061.7 + 0.2364x ? Provide two decimal places and use normal rounding.
Situation: The "Small Town Restaurant" uses a forecast of weekly sales revenue to plan their inventory ordering and staffing for the upcoming week. They have been using a regression forecast for the past year and wonder if it is the most accurate method. You have been brought in to determine if another forecasting technique would be more accurate. Data for their weekly sales for the past year is below: Week Revenue $ 3,157 Week Revenue 14 $ 3,157 1 $ Week Revenue 40 $ 3,298 41 $ 3,201 3,016 15 $ 3,016 Week Revenue 27 $ 2,899 28 $ 2,942 29 $ 3,062 30 $ 3,074 N 3 $ 3,062 16 $ 3,019 42 $ 3,156 4 $ 3,074 17 43 $ 3,017 $ 3,045 $3,046 5 $ 3,002 18 31 $ 3,013 44 $ 3,156 6 $ 3,054 19 32 45 $ 3,097 $ 3,067 $ 3,148 7 3,002 20 33 46 $ 2,978 V $ 3,157 $ 3,016 $ 3,078 $ 2,984 2,984 21 34 $3,146 47 $ 3,120 8 9 10 $ 3,078 22 35 $3,198 48 $ 3,156 $ 3,010 23 $ 3,002 36 $ 3,082 49 $ 3,048 11 $ 3,148 24 $ 3,054 37 $ 3,146 50 $ 2,948 3,146 25 $ 3,002 38 $3,150 51 $ 2,840 12 13 $ 3,198 26 $ 2,941 39 $3,221 52 $ 2,921 $ 159,532 Annual total
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
