xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
Is it possible to graph a curve based on descriptive statistics in Excel?
For example:
mean: 8.147
standard deviation: 0.142
Assuming a normal curve, I am told that I can graph this, but I don't believe it's possible with Excel.
That is, I can do the following: generate a random number set with a normal distribution, then create a histogram.
<img alt="curve" src="http://northernocean.net/etc/mrexcel/20101228_curve.png" />
What I'd like to do is create a continuous line curve of the kind you see in textbooks, to illustrate rejection regions and critical values, etc. I suspect I'll need to look into some other software package or browser-based statistical application but before I say good bye to Excel on this I thought I'd check here.
Cheers
ξ
(note - in anticipation of a statistics class next year where there will be a lot of hypothesis testing for the first section. I sort of blew it in the first half of the course by just drawing all my graphs by hand, much to my prof's "delight").
For example:
mean: 8.147
standard deviation: 0.142
Assuming a normal curve, I am told that I can graph this, but I don't believe it's possible with Excel.
That is, I can do the following: generate a random number set with a normal distribution, then create a histogram.
<img alt="curve" src="http://northernocean.net/etc/mrexcel/20101228_curve.png" />
What I'd like to do is create a continuous line curve of the kind you see in textbooks, to illustrate rejection regions and critical values, etc. I suspect I'll need to look into some other software package or browser-based statistical application but before I say good bye to Excel on this I thought I'd check here.
Cheers
ξ
(note - in anticipation of a statistics class next year where there will be a lot of hypothesis testing for the first section. I sort of blew it in the first half of the course by just drawing all my graphs by hand, much to my prof's "delight").