Two Questions: Multiple regression model and non conformity sample test.

1. Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting sales using the last three years of data in the excel file new car sales (see attached excel sheet). 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