Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect result using AVEDEV formula
I am getting a result that I beleive is incorrect using the AVEDEV formula.
My data is .492, .580, .589, .735, .803, .819, 1.084, 1.413, 1.423 & 1.613. AVEDEV is giving me a result of 34.3%, but when I do the calculation by hand, I get 31.5%. Does anyone have an idea what I might be doing wrong? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect result using AVEDEV formula
Don,
AVEDEV returns the Average of the absolute values of the differences between the values and the average of the values. Using standard functions (actually, an array formula entered using Ctrl-Shift-Enter) this is the same as AVEDEV =AVERAGE(ABS(A2:A11-AVERAGE(A2:A11))) I get the same value as you for both calcs (34.3%). Unless you post your manual method, we cannot be sure what you are doing wrong. HTH, Bernie MS Excel MVP "Don F" <Don wrote in message ... I am getting a result that I beleive is incorrect using the AVEDEV formula. My data is .492, .580, .589, .735, .803, .819, 1.084, 1.413, 1.423 & 1.613. AVEDEV is giving me a result of 34.3%, but when I do the calculation by hand, I get 31.5%. Does anyone have an idea what I might be doing wrong? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect result using AVEDEV formula
You haven't explained how you did your calculation by hand, so it's not easy
for us to tell you what you did wrong, Don. The average of your numbers is 0.9551 The absolute values of the differences between your initial values and the average a 0.4631 0.3751 0.3661 0.2201 0.1521 0.1361 0.1289 0.4579 0.4679 0.6579 The sum of these values is 3.4252 Divide this by 10, and you get 0.34252, which is what Excel gives for AVEDEV. Perhaps you can explain how you got your 31.5%, and what the intermediate values in your calculation were? -- David Biddulph "Don F" <Don wrote in message ... I am getting a result that I beleive is incorrect using the AVEDEV formula. My data is .492, .580, .589, .735, .803, .819, 1.084, 1.413, 1.423 & 1.613. AVEDEV is giving me a result of 34.3%, but when I do the calculation by hand, I get 31.5%. Does anyone have an idea what I might be doing wrong? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect result using AVEDEV formula
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect result using AVEDEV formula
Bernie, David, & Joe:
Thank you for your replies to my post. I discovered my error, it was due to me misreading MEDIAN in the excel help for the formula instead of Mean. Sorry for not providing sufficient information in my original post, I will be more thorough next time. Don "Don F" wrote: I am getting a result that I beleive is incorrect using the AVEDEV formula. My data is .492, .580, .589, .735, .803, .819, 1.084, 1.413, 1.423 & 1.613. AVEDEV is giving me a result of 34.3%, but when I do the calculation by hand, I get 31.5%. Does anyone have an idea what I might be doing wrong? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect result using AVEDEV formula
Glad you found the cause of your problem.
-- David Biddulph "Don F" wrote in message ... Bernie, David, & Joe: Thank you for your replies to my post. I discovered my error, it was due to me misreading MEDIAN in the excel help for the formula instead of Mean. Sorry for not providing sufficient information in my original post, I will be more thorough next time. Don "Don F" wrote: I am getting a result that I beleive is incorrect using the AVEDEV formula. My data is .492, .580, .589, .735, .803, .819, 1.084, 1.413, 1.423 & 1.613. AVEDEV is giving me a result of 34.3%, but when I do the calculation by hand, I get 31.5%. Does anyone have an idea what I might be doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorrect result for simple SUM formula | Excel Discussion (Misc queries) | |||
Formula looks right but shows incorrect result | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
formula result incorrect | Excel Discussion (Misc queries) | |||
ACCRINT formula gives incorrect result | Excel Worksheet Functions |