please do all 3 problems and make model and explain how you did on excel

Many supply managers use a monthly reported survey result known as the purchasing managers' index (PMI) as a leading indicator to forecast future sales for their businesses. Suppose that the PMI and your business sales data for the last 10 months are the following: 4. Construct a causal regression model using PMI as the causal variable. 5. Suppose that the PMI is truly a leading indicator. That is, the PMI value in one period influences sales in the following period.. Construct a new regression model using this information. 6. Given the demand data below, calculate the forecasts for periods 7 through 11 using moving average models with n=2,n=4, and n=6. Many supply managers use a monthly reported survey result known as the purchasing managers' index (PMI) as a leading indicator to forecast future sales for their businesses. Suppose that the PMI and your business sales data for the last 10 months are the following: 4. Construct a causal regression model using PMI as the causal variable. 5. Suppose that the PMI is truly a leading indicator. That is, the PMI value in one period influences sales in the following period.. Construct a new regression model using this information. 6. Given the demand data below, calculate the forecasts for periods 7 through 11 using moving average models with n=2,n=4, and n=6