Question

Time Period t	Daily Sales
1	40
2	28
3	37
4	46
5	35
6	33
7	52
8	49
9	50
10	28
11	44
12	30
13	69
14	58
15	61
16	58
17	46
18	59
19	48
20	64

Given the Data Above for the first 20 days Daily Sales of a new restaurant, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following:
Slope of Regression Equation =

Hint: Value should be between 1.2 and 1.5
Y Intercept for the Regression Equation =

Correlation Coefficient =

(Round to Nearest 100^th, e.g., 0.9762123 = 0.98)
Coefficient of Determination =

(Round to Nearest 100^th, e.g., 0.95299 = 0.95)


Using your Regression Equation, Predict Daily Sales for Periods t=21, t=22, and t=23:
Daily Sales (21) =

Daily Sales (22) =

Daily Sales (23) =

Unless otherwise stated, Round all answers to the nearest “tenth”, e.g., 16.41234 = 16.4 Enter whole numbers like 24 as 24.0

Answer 1

From The regression output we can see the following answers-

Slope of Regression = Coefficient of '1' = 1.4

Y Intercept of Regression Equation = Coefficient of Intercept = 31.7

Correlation Coefficient = Multiple R = 0.62

Coefficient of Determination = R Square = 0.39

Our Regression Equation is- y = 1.4*x + 31.7

Thus at x= 21, y = 1.4*21 + 31.7 = 61.1

Thus at x= 22, y = 1.4*22 + 31.7 = 62.5

Thus at x= 23, y = 1.4*23 + 31.7 = 63.9

Please Like & Provide your reviews in comments. :-)