+ Reply to Thread
Results 1 to 2 of 2

Average and Standard Deviation Question

Hybrid View

ryankarmouta Average and Standard... 10-21-2011, 10:20 PM
ConneXionLost Re: Average and Standard... 10-22-2011, 01:19 AM
  1. #1
    Registered User
    Join Date
    10-21-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Average and Standard Deviation Question

    I had a question regarding simple averages and standard deviations. I am taking the Average of a number of data points in different sheets. I also am taking the standard deviation of the same data points.

    Is there anyway to obtain the standard deviation other than doing =AVERAGE(select data points), and then =STDEV(selecting same items from sheet)? Are there any short cuts that allow me to use the previously selected data points to perform a separate operation in a separate cell?

    Thanks in advance!

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Average and Standard Deviation Question

    You could select your data points and name them as a named range. Then use the name in the AVERAGE and STDEV functions.

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1