Excel

[Graciepants]

How do you find the average (mean etc) on excel? i'm having a blonde moment and i have over 400 data points so dont want to do it manually


merci beaucoup

[orose]

=average(A1:A20) or whatever your range is

[embee]

"Insert", "function", "average"

or similar..............

[Sally]

What orose said..

=average(first data point cell reference:last data point cell reference)

:)

[Lou M]

Or, at the bottom right corner you'll see NUM. right hand click on this and select AVERAGE, then when you highlight the numbers you want, the average will be displayed here.

[Sally]

The possiblities are endless :)

[Lou M]

Perhaps we could start an excel question a day, and then all learn a bit more!!

No, ok that's a bit sad!

[Graciepants]

thanks all, i got pms as well so i now know about 15 ways to do it merci!!

[DarrenSV650S]

Hi Graciepants:smt039

[keith_d]

thanks all, i got pms as well so i now know about 15 ways to do it merci!!

Naah - pms means, "This ****** computer won't ****ing work!!".

[Stu]

thanks all, i got pms as well so i now know about 15 ways to do it merci!!
Hope you're feeling better soon.

[Baph]

Hope you're feeling better soon.

Stu, you're such a tart! :lol:

[Ed]

Even my 10yo can work out averages without a computer:rolleyes:

[Graciepants]

Hope you're feeling better soon.

thank you :kiss:

[Graciepants]

Even my 10yo can work out averages without a computer:rolleyes:

i can too, but when i have 432 data points it'll take 15 years!!!

[Baph]

i can too, but when i have 432 data points it'll take 15 years!!!

5mins on a calculator tops. You've already counted how many are in the set.

(I've been warned about 'poking the bear' before... but it's just TOO tempting...)