Question

For the next six month period Sammy wants to calculate the monthly deviation from the average.

Month    sales       Average   Deviation
July       $1,750      1,460.83   [                ]

Aug       $1,800     

1,460.83   [                 ]

Sept.     $ 1,625 1,   1,460.83  [                ]

Oct.      $1,395       1,460.83        -65.83

Nov.      $1, 215 1    1,460.83   [               ]

Dec.       $980        1,460.83    [               ]

Answer 1

The details are shown below. When sales is less than average we get negative sign.

Explanation:

Month sales Average Deviation

July $1,750 1,460.83 [ 290.17 ]

Aug $1,800 1,460.83 [ 340 .17 ]

Sept. $1,6251, 1,460.83 [ 164 .27 ]

Oct. $1,395 1,460.83 -65.83

Nov. $1, 2151 1,460.83 [ -245.73 ]

Dec. $980 1,460.83 [ ]

Answer 2

Deviation:

July ----- 289.17

August ----- 339.17

September ----- 14800.17

October ----- -65.83

November ----- 10690.17

December ----- -480.83