PLEASE answer the WHOLE question, this is all one puestion. The email doesn't haven't to be exact, but maybe just some guidance on what to write. The basic model of pens is manufactured in large butches several times a year. "Pen's R Us" needs to determine the number of "production runs" that will be needed in 2022 and 2023 schedules. They have collected the following information: Past 3 Years Number of Production Runs 5 8 10 Number of Pre-Order Customers 6 2019 2020 2021 As you can see, the number of production runs has doubled over the last three years despite the number of proorders decreasing by a lot. Getting a forecast will help with the resource planning process. You have been hired to help Lisa Simpson and will need to use trend analysis and regression analysis to determine the most accurate number production runs needed for the next two years, 2022 and 2023. For the regression forecast, it is also known that the number of customers that have placed pre-orders in 2022 is 7 and in 2023 there are 5. In addition, if the standard deviation for production runs is 2. find the 80% confidence interval for your best 2022 forecast and a 90% confidence interval for your best 2023 forecast. Note: You may solve this "by hand" or in an "Excel spread sheet. Either way, you MUST show your evidence IN the exam Word document. In addition, if you used Excel, please turn-in the Excel spreadsheet with your exam (it also has document "properties"). Forecast for 2022 and 2023: Please provide evidence of your hand-written" or Excel solution. Pearson's Correlation Analysis (r): Please provide evidence of your "hand-written" or Excel solution. Confidence Interval Analysis: Please provide evidence of your "hand-written or Excel solution. Write a memo to Lisa that identifies the best forecasting method and your best forecasts for the number of production runs needed in 2022 and 2023. In addition, suggest a TWO qualitative model that could be used to enhance the forecasting process. The memo must have at least "10 GREAT sentences of with your opinions, decision, and your reasons why. Please Type Your Answer Below. Dear Ms. Lisa Simpson