You 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.

Learning Goal: I’m working on a business question and need guidance to help me learn.

MBA576 Unit 2 Individual Assignment
You 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 fixed
Week 1
Sun 28
Mon 26
Tue 19
Wed 21
Thr 17
Fri 21
Sat 35
Week 2
Sun 30
Mon 27
Tue 21
Wed 18
Thr 20
Fri 24
Sat 33
a. 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.