Please show the regression model in excel and show how to solve these questions and give the answers: you should investigate the trendline before and after the 8/15 initiative. What impact did the changes have? If they had not made any changes, how many defects would you have predicted in 2017 and 2018? How does this compare to the actual number of defects?

In reviewing the data in the Performance Lawn Equipment Database, Elizabeth Burke noticed that defects received from suppliers have decreased (worksheet Defects After Delivery). Upon investigation, she learned that in 2014, PLE experienced some quality problems due to an increasing number of defects in materials received from suppliers. The company instituted an initiative in August 2015 to work with suppliers to reduce these defects, to more closely coordinate deliveries, and to improve materials quality through reengineering supplier production policies. Ms. Burke noted that the program appeared to reverse an increasing trend in defects; she would like to predict what might have happened had the supplier initiative not been implemented and how the number of defects might further be reduced in the near future. \begin{tabular}{|r|r|} \hline Aug-17 & 688 \\ \hline Sep-17 & 671 \\ \hline Oct-17 & 645 \\ \hline Nov-17 & 617 \\ \hline Dec-17 & 603 \\ \hline Jan-18 & 571 \\ \hline Feb-18 & 575 \\ \hline Mar-18 & 547 \\ \hline Apr-18 & 542 \\ \hline May-18 & 532 \\ \hline Jun-18 & 496 \\ \hline Jul-18 & 472 \\ \hline Aug-18 & 460 \\ \hline Sep-18 & 441 \\ \hline Oct-18 & 445 \\ \hline Nov-18 & 438 \\ \hline Dec-18 & 436 \\ \hline \end{tabular} In reviewing the data in the Performance Lawn Equipment Database, Elizabeth Burke noticed that defects received from suppliers have decreased (worksheet Defects After Delivery). Upon investigation, she learned that in 2014, PLE experienced some quality problems due to an increasing number of defects in materials received from suppliers. The company instituted an initiative in August 2015 to work with suppliers to reduce these defects, to more closely coordinate deliveries, and to improve materials quality through reengineering supplier production policies. Ms. Burke noted that the program appeared to reverse an increasing trend in defects; she would like to predict what might have happened had the supplier initiative not been implemented and how the number of defects might further be reduced in the near future. \begin{tabular}{|r|r|} \hline Aug-17 & 688 \\ \hline Sep-17 & 671 \\ \hline Oct-17 & 645 \\ \hline Nov-17 & 617 \\ \hline Dec-17 & 603 \\ \hline Jan-18 & 571 \\ \hline Feb-18 & 575 \\ \hline Mar-18 & 547 \\ \hline Apr-18 & 542 \\ \hline May-18 & 532 \\ \hline Jun-18 & 496 \\ \hline Jul-18 & 472 \\ \hline Aug-18 & 460 \\ \hline Sep-18 & 441 \\ \hline Oct-18 & 445 \\ \hline Nov-18 & 438 \\ \hline Dec-18 & 436 \\ \hline \end{tabular}