ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Normal Distribution line (https://www.excelbanter.com/excel-discussion-misc-queries/68480-normal-distribution-line.html)

oz_orlando

Normal Distribution line
 

I have a frequency chart, can show the graph in column charts, but I
want to map a normal distribution over the top.
so far I generated a normal distribution through the normdist function,
but I couldn't get an accurate stdev, and the curve was always centred
across the 15 x values instead of centring on the mean. Any ideas on a
good way to map a normal distribution, or possible ways of centering
what i have created over the mean rather than the 15 x values i have.
thanks


--
oz_orlando
------------------------------------------------------------------------
oz_orlando's Profile: http://www.excelforum.com/member.php...o&userid=31011
View this thread: http://www.excelforum.com/showthread...hreadid=506869



All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com