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.