Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Normal distribution, graph
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Normal distribution, 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. On 3 sep, 14:07, "David Biddulph" <groups [at] biddulph.org.uk wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graph a normal distribution with skew and kurtosis | Charts and Charting in Excel | |||
How to graph normal distribution curve | Charts and Charting in Excel | |||
Graph a normal distribution chart? | Charts and Charting in Excel | |||
NORMAL DISTRIBUTION | Excel Worksheet Functions | |||
Normal Distribution? | Excel Discussion (Misc queries) |