how to get statistical parameters using excel 97?

[tony lincoln]

Dear friends,

I am sorry to ask this question, how to get statistical parameters
like median, standard deviation and get the histogram graph? Many
thanks.

regards.
tony

 

[J.E. McGimpsey]

Look for MEDIAN and STDEV in XL Help for those functions.

Look at Jon Peltier's site for help with histogram charts:

http://www.geocities.com/jonpeltier/Excel/Charts/Histograms.html

 

[George Lin]

Suppose you have numbers from B2 to B10, you can type in
formulaS "=average(b2:b10)", "=STDEV(B2:B10)", "=VAR
(B2:B10)" in B11, B12, and B13.

 

[David J. Braden]

Tony,
All sugestions I have seen are on target, IMHO. I also suggest you
consider simply using Excel's built-in Help for such stuff (it won't get
any help-file-of-the-year awards from me, but is fine for the sort of
stuff you ask, and has examples to boot).

Also, if you are interested in using Excel for stat analysis, consider
books by Mike Middleton and Bernard Liengme; at a business-analytic
level, that by Conrad Carlberg; for corrections to Excel's stat
functions, Google-search, within *.excel.*, newsgroup posts by Conrad,
Harlan Grove, Jerry W. Lewis, David J. Braden, Myrna Larsen, Jon Peltier
and Tushar Mehta, among many others. It may seem at first like a morass,
given the state of Excel and perhaps your own expertise, but we will
happily get you through it.

Dave Braden