Normal distribution, graph

  • Thread starter Thread starter Henrootje
  • Start date Start date
H

Henrootje

I know that a company produces 1,800,000 items a year.
I know that production is 4 times as high in the month May, whereas
the other months are more or less equal.
In december production is at about 25% of 'normal'

How would one go about estimating production in each of the twelve
months and displaying this in a graph?

I did something like this when I was 17 but do not remember how it
should be done :s

If sb could give me a clue I would be most gratefull!

Keep in mind that the value '1,800,000" can change so that should be
variable :s

If anybody knows how to do this, thank you!

grtz Henrootje
 
I don't think you mean a "normal distribution" as in Gaussian. By the
sounds of it you are saying that if your "normal" month's production is N,
then you have one month with 4*N, one month with 25%*N, and the other 10
months with N. Hence the total for the year is 14.25*N, and that's your
1800000, hence N=1800000/14.25. If your 1800000 is in cell A1 then you can
put the formula =A1/14.25 in 10 of your 12 monthly cells, and =4*A1/14.25 in
May's cell and =25%*A1/14.25 in December's. Put those in your graph.
 
Suddenly the light came to me during lunch and I was contemplating
this approach when I saw your response.
You describe exactly what I was doubting, now I know it is the right
approach. Thank you David.
 
Back
Top