Calculating the standard deviation for TVs at ABC Electronics

The planner at ABC Electronics is trying to optimize stocking and ordering for a popular 50-inch plasma TV it stocks. The first step is to look at the pattern of demand to calculate the rate of sales. After looking back over the past 10 weeks of sales, the planner has determined the actual sales on the TV and has placed the values in the table below. The average of number of TVs sold during that period was 125.

Note: Enter values into cells colored GREEN only! Actual Sales 84 78 Week 1 2 3 4 5 Sales Forecast 125 125 125 125 125 125 125 125 125 125 155 155 170 Absolute Deviation 41 47 30 301 45 53 501 47 58 41 Deviation^2 1,681 2,209 900 900 2,025 2,809 2,500 2,209 3,364 1,681) 72 6 7 8 9 10 75 172 67 166 Absolute Deviation Squared Deviation Average (sq. dev.) Standard / Squared o MADO 442 20,278 2,253.11 47.47 55.25 Instructions Use the chart as a template to help you answer the questions (these are not the correct answers). Update the cells in green with the data from the case. The remaining blue cells will recalculate with the appropriate answers. Then proceed to answer the questions below. Question #1 Using the above table, calculate the squared deviation for Week 1. Answer #1) 012 Points Question #2 What would be the squared deviation for the 10 weeks? Answer #2 12 Points Question #3 What would be the standard deviation for the item? Answer #31 02 Points Question #4 In this case, what does the standard deviation represent? Answer #4 0 2 Points