1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel: Finding deviation from mean

  1. Sep 30, 2012 #1
    Hi guys,

    I have to find the deviation from the mean for each individual entry of a column of numbers.

    Any one have any idea how to do this?

    I'm clueless when it comes to excel
  2. jcsd
  3. Sep 30, 2012 #2


    Staff: Mentor

    By deviation I'm assuming that you mean the difference from the mean. If you have already calculated the mean of the numbers in the column, then finding the deviation from the mean is simply a subtraction.

    Suppose your numbers are in column A, in rows 1 through 20, and the mean of these numbers is in column A, row 25.

    Starting in col. B, row 1, enter this formula: =A1 - $A$25
    Don't omit the = that starts the formula. The dollar signs mean that if the formula is copied to another cell, the 2nd term will remain A25.
    Next copy this formula and paste it into rows 2 through 20 of col. B.

    If you haven't already calculated the mean, that's pretty easy, too. In col A, row 25, enter this formula: = AVERAGE(A1:A20)
  4. Oct 1, 2012 #3
    Thanks Mark, I bloody knew it involved $s!
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Similar Threads - Excel Finding deviation Date
Finding Unknown Forces on a Beam Structure Today at 8:57 AM
Solving for Minimum point Excel May 9, 2017
Euler's Method Tutorial Nov 21, 2015
Graphing stress-strain plots on excel Oct 31, 2015
Basic calcs in excel for dc lap wound motor Oct 5, 2015