Excel: Finding deviation from mean

Click For Summary
SUMMARY

This discussion focuses on calculating the deviation from the mean in Excel. Users can find the deviation by subtracting the mean from each individual entry in a specified column. The mean can be calculated using the formula =AVERAGE(A1:A20), and the deviation can be computed with the formula =A1 - $A$25, where $A$25 contains the mean value. This method allows for easy copying of the formula across multiple rows to obtain deviations for all entries.

PREREQUISITES
  • Basic understanding of Excel formulas
  • Knowledge of the AVERAGE function in Excel
  • Familiarity with absolute cell references (using $ in formulas)
  • Ability to copy and paste formulas in Excel
NEXT STEPS
  • Learn how to use the AVERAGE function in Excel for different ranges
  • Explore advanced Excel functions for statistical analysis
  • Understand the concept of absolute vs. relative cell references
  • Investigate data visualization techniques to represent deviations graphically
USEFUL FOR

This discussion is beneficial for Excel users, data analysts, and anyone looking to perform statistical calculations in spreadsheets.

Darth Frodo
Messages
211
Reaction score
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
 
Physics news on Phys.org
Darth Frodo said:
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

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)
 
Thanks Mark, I bloody knew it involved $s!
 

Similar threads

Undergrad Error bars in Excel (standard deviation, standard error, percentage)
  • · Replies 4 ·
Replies
4
Views
3K
Standard deviation calculators on the Internet are not for grouped data
  • · Replies 2 ·
Replies
2
Views
3K
Engineering Advanced control systems, state-space controllers
  • · Replies 11 ·
Replies
11
Views
2K
Engineering Transverse shear stress calculation in non-slender built up members
  • · Replies 6 ·
Replies
6
Views
3K
Engineering Checking a component for a lathe slideway for straightness
  • · Replies 6 ·
Replies
6
Views
2K
Engineering Spinodal and Isotherms graph on P-V diagram
  • · Replies 8 ·
Replies
8
Views
3K
Standard Deviation (bell graph) in excel
  • · Replies 3 ·
Replies
3
Views
8K
How can I calculate the uncertainty of the mean with Gaussian error propagation?
  • · Replies 15 ·
Replies
15
Views
1K
C Programming - First assignment not sure how to approach
  • · Replies 10 ·
Replies
10
Views
2K
High School What does this distance of an atom mean?
  • · Replies 7 ·
Replies
7
Views
3K