(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

(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 nonconformity, and 95 of the 3,000 items are defective, find the upper and lower control limits for a p-chart.

Please be sure your work is organized, legible, and your responses are substantive. You need to submit all details of your work including excel sheets used to arrive to the solution. It is not enough to attach your excel sheet. You MUST provide interpretation of results and describe conclusions.

 

This is due asap !!!

2

>New car sales

9,810

1

1

1

1

1

1

1

1

1

1

1

2 Jan

2 Feb

2 Mar

2 Apr

2 May

2 Jun

2 Jul

2 Aug

2 Sep

2 Oct

2 Nov

2 Dec

3 Jan

3 Feb

3 Mar

3 Apr

3 May

3 Jun

3 Jul

3 Aug

3 Sep

3 Oct

3 Nov

3 Dec

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