Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to input a calculation in excel to find the geometric mean
how do you input the formulas in excel to calculate the geometric mean?
|
#2
|
|||
|
|||
Hi the
Try this: =PRODUCT(A1:A10)^(1/COUNT(A1:A10)) Regards, KL "student1" wrote in message ... how do you input the formulas in excel to calculate the geometric mean? |
#3
|
|||
|
|||
On Sun, 3 Jul 2005 14:48:01 -0700, "student1"
wrote: how do you input the formulas in excel to calculate the geometric mean? Look at HELP for the GEOMEAN worksheet function. --ron |
#4
|
|||
|
|||
IF GEOMEAN() is overflowing, then so will KL's equivalent formula.
=EXP(AVERAGE(LN(data))) or =EXP(AVERAGE(IF(ISNUMBER(data),LN(data)))) is a more robust calculation. Both formulas must be array entered (Ctrl-Shift-enter). The second formula permits empty and non-numeric cells in the data range. Jerry student1 wrote: how do you input the formulas in excel to calculate the geometric mean? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
find and replace links in Excel 2003 | Excel Worksheet Functions | |||
Find and replace Excel, Office pro 2003 | Excel Discussion (Misc queries) | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) |