Title: “Improving Order Accuracy: A Linear Regression Analysis for Dollar Wise Distribution Center”

Don Clarke, The Operations Manager of the Dollar Wise Distribution Center is concerned with the level of accuracy of the picking team under his responsibility. He has taken a sample of 75 recent orders and compiled the information in the Workbook WB5.xls.
The data is defined as follows:
Order Accuracy (%): Number of correct pieces in the order divided by the total number of pieces in the order, multiplied by 100.
Number of Lines in the Order: Number of SKUs in each order. The more lines in an order, the more stops the picker has to make to fulfill it.
Order Size: Number of pieces in each order. Larger orders require more attention from pickers as he/she counts the pieces.
Time within Shift: Each seven-hour shift is divided in 28 working blocks of 15 minutes each. This column shows the number of the block in which the order was picked.
Picker Experience: This is a Category Variable created to differentiate the level of experience of the picker assigned to each order.
You are to develop a linear regression model to assist Don in his analysis.
Open the MS Excel file WB5.xlsx.
Using the Correlation capability, create a matrix showing how the five variables correlate with one another.
Create a Word file and write your conclusions from the item above.
Create a single linear regression model using the variable with the highest correlation coefficient.
Interpret the results, including the weight of each coefficient, and summarize your findings in the Word file.