Question: Plot your data in an appropriate plot and include the plot along with a short discussion in your report. Fit an appropriate model that gives

Plot your data in an appropriate plot and include the plot along with a short discussion in your report.
Fit an appropriate model that gives a sufficiently large R-square and low standard error value. You may want to initially use the Add Trendline tool in excel in order to gauge best models. Provide the model in your report.
Important Note: You should not implement the same type of model, i.e., simple linear regression model, or other model, for all four questions because the same model may not be a good model for different data sets.
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 2018, PLE experienced some quality problems due to an increasing number of defects in materials received from suppliers. The company instituted an initiative in August 2019 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 you to predict what might have happened had the supplier initiative not been implemented (only include Jan. 2018 to Aug. 2019 data for the regression analysis).
Ms. Burke would also like your groups to use all of the Defects After Delivery data (from Jan. 2018 to Dec. 2022) and find an appropriate model that predicts Defects for each month in 2019. How do your models differ between questions 1) and 2)?
PLEASE INCLUDE MODELS AND SOLVE FOR THE QUESTIONS!!! Need answers not just an explanation of steps to solve the problem.
 Plot your data in an appropriate plot and include the plot

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!