A simple formula in Excel 2003 please

Would sks please help me (a real newby to excel) to calculate the average inflation rate for the period shown assuming 3.8% is A1 and 2.8% is G1 please. I can do the first bit, ie =sum(a1:g1) but surely the correct formula is not =sum(a1:g1)/7 I am guessing that counting the rows is counterproductive but I just can't get the second bit. 3.8% 1.5% -0.8% 0.0% 2.0% 3.9% 2.8%

TIA, regards Chris

Reply to
AussieGal
Loading thread data ...

Hi Chris,

Try this formula, =average(a1:g1) This will give you a simple average. For the complete list of formulas (more than you'll ever use), in Excel click on the smart button (at the top of the screen) with the symbol, fx

I hope this helps, Russell Tuncap, CMA, CPA

formatting link

Reply to
R

This depends more on the definition you wish for "average", but straightforward, how about

average(a1:g1)

??

Reply to
Duane Bozarth

An extremely easy way to get this answer is to highlight (by dragging the mouse over A1 to G1) and looking at the bottom right of the Excel spreadsheet. There you will see either the Sum of those items or some other item. By right clicking on that area with your mouse, you can get a number of answers from your highlighted list including: average, count, count nums, max, min, and sum. I hope this helps.

Wayne Brasch

Reply to
Wayne Brasch

Thank you Russell, Duane and Wayne, you cannot know how grateful I am. An such a simple answer has made me check out even more stuff and gain a knowledge of it all. Regards Chris.

Reply to
AussieGal

And, btw, the general expression for average compound rate if you have start and end values is v2/v1 = (1 + x)^n. To solve for x, take logs of both sides and then inverse log. Using natural logs, and recalling that "exp(ln(anything)) = anything",

ln(v2/v1) = n * ln(1 + x) ==> ln(1 + x) = (1/n) * ln(v2/v1)

exp(ln(1 + x)) = 1 + x = exp[(1/n) * ln(v2/v1)]

or

x = exp[(1/n) * ln(v2/v1)] - 1

Reply to
Duane Bozarth

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.