You have been asked by company X 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. I am not sure in setting up a forecast weekly sale for Season 4 since I don't know whether the team won/ lost, home/away or old/new coach

Year	Game	Win = 1, Lose = 0	Home =1, Away = 0
1	1	1	1
1	2	1	1
1	3	1	1
1	4	0	0
1	5	0	0
1	6	0	1
1	7	0	1
1	8	0	0
2	1	1	0
2	2	1	0
2	3	1	0
2	4	0	1
2	5	0	1
2	6	0	1
2	7	0	1
2	8	0	1
3	1	0	1
3	2	1	0
3	3	1	1
3	4	1	1
3	5	1	1
3	6	1	0
3	7	1	0
3	8	1	1

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