Question 3 (3 points)

Saved

Question 3 options:

Time Period t	Daily Sales
1	48
2	47
3	49
4	51
5	48
6	49
7	48
8	54
9	55
10	52
11	57
12	63
13	53
14	54
15	57
16	58
17	58
18	66
19	59
20	69

iven 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 0.7 and 1.3 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