ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   ?Percentile? Graph (https://www.excelbanter.com/charts-charting-excel/31325-percentile-graph.html)

benb7760

?Percentile? Graph
 

I am trying to create a graph like this:

http://www.ergonomics4schools.com/im...nthrograph.gif

Any help would be greately appreciated


--
benb7760
------------------------------------------------------------------------
benb7760's Profile: http://www.excelforum.com/member.php...o&userid=24382
View this thread: http://www.excelforum.com/showthread...hreadid=380211


MrShorty


Are you working from raw data, or are you trying to generate a
"theoritical" normal distribution curve based on a given
sample/population mean and standard deviation? The former would be
easy enough to do by putting the "bin" values in one column and use the
FREQUENCY function to get the distribution. The latter would use the
NORMDIST function to generate the frequency distribution.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=380211



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

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