Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 23rd 05, 05:17 PM
panducci
 
Posts: n/a
Default Is there a standard deviation calculation in Excel?

In regards to Statistics, I was wondering if there is a standard deviation
function in Excel that will eliminate the long math.

  #2   Report Post  
Old February 23rd 05, 05:40 PM
 
Posts: n/a
Default

hi,
yes there is. several. i have never used them because i
never had a need. on the fomula bar, click the equal sign.
then click the down arrow that appeared to the left. from
the dropdown, click more functions. from paste function
box click statistical. scroll down to
=STDEV
=STDEVA
=STDEVP
=STDEVPA
i don't know how to use them, but there are examples.

-----Original Message-----
In regards to Statistics, I was wondering if there is a

standard deviation
function in Excel that will eliminate the long math.
.

  #3   Report Post  
Old February 23rd 05, 05:42 PM
Jason Morin
 
Posts: n/a
Default

There is the STDEV worksheet function. Go into Excel Help
and look under "Statistical Functions".

HTH
Jason
Atlanta, GA

-----Original Message-----
In regards to Statistics, I was wondering if there is a

standard deviation
function in Excel that will eliminate the long math.
.



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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
time calculation excel Gate Keeper Excel Worksheet Functions 1 December 31st 04 08:27 AM
Is there a way to create a standard OHLC bar chart in Excel? [email protected] Charts and Charting in Excel 3 December 2nd 04 09:49 PM
Histrogramms: Calculating average and standard deviation Jens Eichelbaum Excel Worksheet Functions 2 November 23rd 04 02:10 AM
Insert a standard character in a cell of excel. JulieD Excel Worksheet Functions 5 November 19th 04 06:31 PM


All times are GMT +1. The time now is 02:49 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017