Statistics in Excel

• Jun 3, 2004

• #2

IRstuff

Aerospace

Jun 3, 2002

44,892

US

If you go to the menu Insert|Paste Function, there is a selection of statistical functions available already in Excel.

Also, try using the Help function.

TTFN

 

Upvote 0 Downvote

• Jun 3, 2004

• Thread starter
• #3

gb433054

Aerospace

Jul 24, 2003

28

GB

I have tried that, but it only gives you the value of the normal distribution and std dev. I want to plot a distribution curve for a sample of data. However there doesnt seem to be the facility to do so.

 

Upvote 0 Downvote

• Jun 3, 2004

• #4

johnwm

Computer

Sep 26, 2002

806

GB

I'd start out from Insert|Chart|X-Y scatter

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

 

Upvote 0 Downvote

• Jun 3, 2004

• #5

pmover

Mechanical

Sep 7, 2001

1,507

US

gb433054,

what you need to do in install the analysis toolpak that comes with excel.

from menu, select: tools-addins
select anaylsis toolpak and analysis toolpak - vba.

once add-ins are installed, from main menu, select tools-data analysis and you will find all the statistical information you requested.

good luck!
-pmover

 

Upvote 0 Downvote

• Jun 3, 2004

• #6

BillPSU

Industrial

Oct 28, 2003

832

US

I don't think the toolpak will give you the ability to automatically graph what you want. I have gotten a commercial product which I feel works well, QI Macros. It is a very good SPC Excel add-in. Its available at

http://www.qimacros.com/excel-spc.html.

 

Upvote 0 Downvote

• Jun 3, 2004

• #7

MortenA

Chemical

Aug 20, 2001

2,998

DK

The "histogram analysis" function in the analysis toolpack will what you mention allthough its not very elegant. I think you must do the std. plot yourself (also the transformation because excel dont have a plot with std. dev. axis).

Best regards

Morten

 

Upvote 0 Downvote

• Jun 4, 2004

• #8

BML

Industrial

Jun 22, 1999

104

US

In order to get the plot, you will have to enter the discrete X values of the coordinates in one column or row, then calculate the probability mass function based on your statistics and each independent X in another column/row. Then make a chart with those two arrays as the inputs.

Hope this helps!

 

Upvote 0 Downvote

• Jun 7, 2004

• #9

pmover

Mechanical

Sep 7, 2001

1,507

US

all,

i was checking all my favorites and observed this tip.

see item #19 at:

http://www.xl-logic.com/pages/formulas.html

i did not investigate, so good luck!
-pmover

 

Upvote 0 Downvote