Calculate Fluctuation

  • Thread starter Thread starter Eileen
  • Start date Start date
E

Eileen

I need to calculate the fluctuation of the sales history
to better control the inventory levels. Is there a
formular in Excel that can help me? For example, I need
to calculate Group 1 is more "lumpy" than Group 2.

Aug. July June May
Group 1 10 20 30 15
Group 2 100 110 120 105


Does standard deviation/mean work? What is the formular?

Appreciate any input.
 
I need to calculate the fluctuation of the sales history
to better control the inventory levels. Is there a
formular in Excel that can help me? For example, I need
to calculate Group 1 is more "lumpy" than Group 2. ...
Does standard deviation/mean work? What is the formular?
Click to expand...

It would. It's sometimes called the coefficient of variation. If group 1 values
were in B2:E2, use =STDEV(B2:E2)/AVERAGE(B2:E2).
 
Back
Top