#1   Report Post  
benb7760
 
Posts: n/a
Default ?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

  #2   Report Post  
MrShorty
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a combination graph with stackedColumns+lineGraph ChartQuestion Charts and Charting in Excel 1 June 14th 05 12:39 PM
Graph Help- 12 month graph, but only want months that have passed coal_miner Charts and Charting in Excel 4 June 3rd 05 03:03 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"