- #1

Darth Frodo

- 211

- 1

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

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter Darth Frodo
- Start date

- #1

Darth Frodo

- 211

- 1

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

Mark44

Mentor

- 36,334

- 8,293

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)

- #3

Darth Frodo

- 211

- 1

Thanks Mark, I bloody knew it involved $s!

Share:

- Last Post

- Replies
- 1

- Views
- 270

- Last Post

- Replies
- 4

- Views
- 1K

Engineering
Can you find a surface from a metric?

- Last Post

- Replies
- 2

- Views
- 278

- Replies
- 5

- Views
- 1K

- Last Post

- Replies
- 1

- Views
- 727

Engineering
Gas turbine (mean line) analysis question

- Last Post

- Replies
- 0

- Views
- 303

Engineering
Finding the Impedance

- Last Post

- Replies
- 3

- Views
- 439

- Last Post

- Replies
- 5

- Views
- 793

Engineering
Finding Thevenin Equivalent

- Last Post

- Replies
- 5

- Views
- 385

- Last Post

- Replies
- 3

- Views
- 582