Statistical formulas

[cparaske]

I'm trying to create some formulas in a spreadsheet that will do th
following:

look at values in one column (i.e. N, S, E, W) and then give me bac
the MEAN, STD DEV, COUNT, etc for each of the four values. We us
about 2.500 data points to do these calculations and manually takes
long time.

Should I be using database filtering and the SUBTOTAL formula or i
there something else I could do to simplify these calculations

 

[Frank Kabel]

Hi
try the following kind of array formula (entered with
CTRL+SHIFT+ENTER):
=MEAN(IF(A1:A2500="N",B1:B2500))

 

[Bernard Liengme]

Of course, Frank meant to write =AVERAGE(IF(A1:A2500="N",B1:B2500))

You might want to experiment with pivot tables to get all the required
results
Read Help and come back with questions

best wishes


--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

Hi
try the following kind of array formula (entered with
CTRL+SHIFT+ENTER):
=MEAN(IF(A1:A2500="N",B1:B2500))

 

[cparaske]

I did catch that Bernard. Thanks, Frank. The formula worked well.

I will be using Pivot Tables with the new information from the
formulas, since in addition to checking by Region, we will also be
checking by month.

Thanks again.
Cristo Paraskevas