PC Review


Reply
Thread Tools Rate Thread

Charting a normal distribution within excel..

 
 
=?Utf-8?B?QnJlbnRmb3JkIExlZ2VuZA==?=
Guest
Posts: n/a
 
      25th May 2004
Hi - I have calculated some normal distriubtions results for a number of numbers in a sample.. (Using the normdist function).. How do I then go about charting this distribution?? or is there another way of charting a distribution without using the normdist function.. Any help received would be much appreciate

Rgd

Mark..
 
Reply With Quote
 
 
 
 
Michael R Middleton
Guest
Posts: n/a
 
      25th May 2004
Brentford Legend Mark -

> I have calculated some normal distriubtions results for a number of

numbers in a sample.. (Using the normdist function).. How do I then go about
charting this distribution?? <

To plot the "theoretical" distribution, enter a column of X values and a
column of NormDist values. Then use an XY (Scatter) chart.

> or is there another way of charting a distribution without using the

normdist function. <

To plot frequencies of data, use the Histogram tool.

- Mike Middleton, www.usfca.edu/~middleton



 
Reply With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      25th May 2004
Tushar Mehta tells about plotting these distributions on his web site:

http://tushar-mehta.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Brentford Legend wrote:

> Hi - I have calculated some normal distriubtions results for a
> number of numbers in a sample.. (Using the normdist function).. How
> do I then go about charting this distribution?? or is there another
> way of charting a distribution without using the normdist function..
> Any help received would be much appreciated
>
> Rgds
>
> Mark..


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a graph for a normal distribution in Excel? Dag0709 Microsoft Excel Charting 2 25th Sep 2008 05:01 PM
can i create normal distribution curves in excel? =?Utf-8?B?SHVnc2llIEJlYXI=?= Microsoft Excel Misc 1 14th Jul 2006 12:12 PM
How do i set up a normal distribution in excel? =?Utf-8?B?ZGltaQ==?= Microsoft Excel New Users 1 30th May 2006 10:22 AM
Normal distribution test in excel? =?Utf-8?B?c3RyaWRlcjI1Nw==?= Microsoft Excel Misc 1 8th Mar 2006 04:55 PM
Can I chart normal distribution in excel? desi Microsoft Excel Charting 1 18th Jan 2006 05:22 PM


Features
 

Advertising
 

Newsgroups
 


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