View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Normal distribution, graph

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.
--
David Biddulph

"Henrootje" wrote in message
ups.com...
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