You have been asked by the Wincraft to do an analysis of jersey sales to better understand the impact that game performance and other factors have on sales. Using descriptive statistics and modeling appropriate for such a problem, you must provide clear guidance. The owner understands that sales may be difficult to predict, however they do believe predictions can be made. Your P values for all variables should be <= 0.10, your Significance of F should be <= 0.10 and your R-Squared should be >=.15. The question came with four separate sheets in excel. How do I set it up and forecast weekly sales for Season 4 since I dont know whether the team won/ lost.

Year	Game	New Coach = 1, Old Coach = 0
1	1	0
1	2	0
1	3	0
1	4	0
1	5	0
1	6	0
1	7	0
1	8	0
2	1	0
2	2	0
2	3	0
2	4	0
2	5	0
2	6	0
2	7	0
2	8	0
3	1	0
3	2	0
3	3	1
3	4	1
3	5	1
3	6	1
3	7	1
3	8	1

Date	Weekly Total Jersey Sales
8/29/2016	180
9/5/2016	184
9/12/2016	133
9/19/2016	70
9/26/2016	67
10/3/2016	75
10/10/2016	68
10/17/2016	95
8/27/2017	63
9/3/2017	70
9/10/2017	55
9/17/2017	65
9/24/2017	75
10/1/2017	73
10/8/2017	65
10/15/2017	72
8/27/2018	54
9/3/2018	61
9/10/2018	132
9/17/2018	181
9/24/2018	178
10/1/2018	73
10/8/2018	81
10/15/2018	113

Year	Game	Date
1	1	8/29/2016
1	2	9/5/2016
1	3	9/12/2016
1	4	9/19/2016
1	5	9/26/2016
1	6	10/3/2016
1	7	10/10/2016
1	8	10/17/2016
2	1	8/27/2017
2	2	9/3/2017
2	3	9/10/2017
2	4	9/17/2017
2	5	9/24/2017
2	6	10/1/2017
2	7	10/8/2017
2	8	10/15/2017
3	1	8/27/2018
3	2	9/3/2018
3	3	9/10/2018
3	4	9/17/2018
3	5	9/24/2018
3	6	10/1/2018
3	7	10/8/2018
3	8	10/15/2018