(1) Developed a multiple regression model with categorical variables that incorporate seasonality for forecasting sales using the last three years data in the excel file attached New Car sales (2) If 30 samples of 100 items are tested for nonconfor

profilejsaibu
newcarsales.xlsx
Home>Applied Sciences homework help> (1) Developed a multiple regression model with categorical variables that incorporate seasonality for forecasting sales using the last three years data in the excel file attached New Car sales (2) If 30 samples of 100 items are tested for nonconfor

New car sales

New Car Retail Sales
Year Month Units
1 Jan 39,810
1 Feb 40,081
1 Mar 47,440
1 Apr 47,297
1 May 49,211
1 Jun 51,479
1 Jul 46,466
1 Aug 45,208
1 Sep 44,800
1 Oct 46,989
1 Nov 42,161
1 Dec 44,186
2 Jan 42,227
2 Feb 45,422
2 Mar 54,075
2 Apr 50,926
2 May 53,572
2 Jun 54,920
2 Jul 54,449
2 Aug 56,079
2 Sep 52,177
2 Oct 50,087
2 Nov 48,513
2 Dec 49,278
3 Jan 48,134
3 Feb 54,887
3 Mar 61,064
3 Apr 53,350
3 May 59,467
3 Jun 59,370
3 Jul 55,088
3 Aug 59,349
3 Sep 54,472
3 Oct 53,164
3 Nov 48,793
3 Dec 46,956