MBA576 Unit 2 Individual AssignmentYou just finished your MBA degree and your boss wants “to show you off” in an upcoming staff meeting because she feels you have a lot of potential. Needless to say, you feel some pressure.She is concerned about the loss form quality issues. In the past if an item failed quality inspection then it was discarded, so she has decided that the failed items that can be fixed will be. Below is the number of failed items per day for the past two weeks that can be fixed.Number of failed items per day that can be fixedWeek 1Sun 28Mon 26Tue 19Wed 21Thr 17Fri 21Sat 35Week 2Sun 30Mon 27Tue 21Wed 18Thr 20Fri 24Sat 33a. Using Excel, create a linear regression equation to model the number of failed items per day. b. Is the regression equation a good predictor of the number of failed items? Explain your answer.c. How many failed items does the regression equation predict for Monday of week 3?d. Suppose a technician can fix 5 units per day. How many technicians are needed to handle the load based on the average number of failed items per day?Use the regression function in the Data Analysis Toolpak in Excel to formulate the regression equation. Also create a scatter plot of the data in Excel.
