PSJupiter2
New Member
- Joined
- Mar 18, 2015
- Messages
- 7
I wish to create a UDF that calculates a formula used in Mass Appraisal of Real Estate
I use MS Excel 2007, and Windows 7
This is a sample what my Data looks like:
<tbody>
</tbody>
My data ranges will be different every time I use the UDF ("n" is based on the number of data points available)
To my knowledge, there is no built-in formula for the following:
Control - Shift - Enter:
{=((AVERAGE(ABS(C2:C15-(MEDIAN(C2:C15)))))/(MEDIAN(C2:C15)))*100}
I thought a UDF would be the way to go. I am trying to accomplish the following:
Function COD(Ratio, Median)
COD= {((AVERAGE(ABS("Range of available data" - "Median of Available Data"))))/(MEDIAN("Median of Available Data"))*100}
End Function
Any help on this would be greatly appreciated! Thank You!
I use MS Excel 2007, and Windows 7
This is a sample what my Data looks like:
AssessedValue | SalePrice | Ratio = AV/SP |
90 | 88 | 1.02 |
90 | 93 | 0.97 |
90 | 87 | 1.03 |
90 | 94 | 0.96 |
90 | 85 | 1.06 |
90 | 96 | 0.94 |
90 | 95 | 0.95 |
90 | 98 | 0.92 |
90 | 100 | 0.90 |
90 | 90 | 1.00 |
90 | 90 | 1.00 |
90 | 98 | 0.92 |
90 | 97 | 0.93 |
90 | 90 | 1.00 |
<tbody>
</tbody>
My data ranges will be different every time I use the UDF ("n" is based on the number of data points available)
To my knowledge, there is no built-in formula for the following:
Control - Shift - Enter:
{=((AVERAGE(ABS(C2:C15-(MEDIAN(C2:C15)))))/(MEDIAN(C2:C15)))*100}
I thought a UDF would be the way to go. I am trying to accomplish the following:
Function COD(Ratio, Median)
COD= {((AVERAGE(ABS("Range of available data" - "Median of Available Data"))))/(MEDIAN("Median of Available Data"))*100}
End Function
Any help on this would be greatly appreciated! Thank You!