Gaussian distribution question

Hello all,

please help me with this problem.

say if I have 2000 units for a category A that is to be made in time frame of 10 months.

i was wondering if we can make something in excel to create a Gaussian distribution for these 2000 units over 10 months. X axis scale being 1 month.

would there be a generalized equation to fit a well distributed curve for such kind of data??

Thank you in advance

-VK

Re: Gaussian distribution question

Read this.

An Introduction to Excel's Normal Distribution Functions

99.7% of the values should fall between -3 & 3, so rescale that interval to be between 0 & 10 and you are done.