7-12: 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.
Tips for problem 7-12: This is a multiple regression problem based on monthly data. You will need to create dummy variables for the months to represent seasonality in the model.
Here is a video about the concept:
Here is part of what want to do:
You will fill all entries for three years, then run regression in excl.
8-4: 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.