1. Data:

Week	Sales	AdExp(X1)	ShelfSpc (X2)
1	2010	201	75
2	1850	205	50
3	2400	355	75
4	1575	208	30
5	3550	590	75
6	2015	397	50
7	3908	820	75
8	1870	400	30
9	4877	997	75
10	2190	515	30
11	5005	996	75
12	2500	625	50
13	3005	860	50
14	3480	1012	50
15	5500	1135	75
16	1995	635	30
17	2390	837	30
18	4390	1200	50
19	2785	990	30
20	2989	1205	30

2. Use Excel to create scatter plots to examine the bivariate relationships between the dependent and independent variables. Interpret the plots and formulate a multiple regression model.

3. Use Excel to compute estimates of the unknown parameters of the model. Interpret these parameters.

4. Evaluate the model utility (hypothesis tests) and interpret the correlation statistics.

5. Use the model for estimation or prediction.

6. Submit your work via the Canvas assignment link no later than the due date. Multiple submissions are allowed, if needed.

7. This is an individual (i.e., not group) assignment. Please adhere to the university policy regarding academic integrity.