1 . Use the data in the above table and regression analysis to forecast the orders for the next 12 months ( 4 th year ) . Include your excell work sheet and your work in your write up . Show the regression equation , values of intercept , slope , correlation coefficient and coefficient determination and the forecast of orders for the next 12 months . 2. Explain how you could make your forecast's results more reliable by incorporating a qualitative research to your quantitative results