1 developed multiple regression model categorical variables incorporate seasonality forecast

(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 !!!