



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
An overview of the ratio statistics procedure in spss, which calculates descriptive statistics for the ratio of two variables. Notations, data requirements, and various statistics such as minimum, maximum, range, median, average absolute deviation, coefficient of dispersion, coefficient of concentration, mean, standard deviation, coefficient of variation, weighted mean, and price related differential. It also explains the concept of assessment regressivity and progressivity, and provides formulas for confidence intervals for the median and mean.
Typology: Study notes
1 / 5
This page cannot be seen from the preview
Don't miss anything!




This procedure provides a variety of descriptive statistics for the ratio of two variables.
The following notation is used throughout this chapter unless otherwise stated:
n Number of observations Ai Numerator of the^ I -th ratio^ ( i^ = 1, …,^ n ). This is usually the appraisal roll value. S (^) i Denominator of the^ i -th ratio^ ( i^ = 1, …,^ n ). This is usually the sale price. Ri The i -th ratio ( i = 1, …, n ). Often called the appraisal ratio. f (^) i Case weight associated with the^ i -th ratio^ ( i^ = 1, …,^ n ).
This procedure requires for i = 1, …, n that:
i i i^ n i
The smallest ratio and is denoted by R min.
The largest ratio and is denoted by R max.
The difference between the largest and the smallest ratios. It is equal to R max (^) − R min.
The middle number of the sorted ratios if n is odd. The mean (average) of the two middle ratios if the n is even. The median is denoted as R
∑ ∑ = =
n
i
i
n
i
AAD fi Ri R f 1 1
Given a percentage 100% × g , the coefficient of concentration is the percentage of ratios falling within the interval [( g ) R ( g ) R ]
1 − +. The higher this coefficient, the better uniformity.
∑ ∑ = =
n
i
i
n
i
AS R fi Ri f 1 1
( ) ∑ (^ ) =
n
i
fi Ri R F
s 1
2 1
n
i
F fi 1
An equivalent formula is
( ) (^) ∑
−
=
1
0
r
k
n (^) k
n I n r r α .
Since the rightmost term is the cumulative Binomial distribution and it is discrete, r is solved as the largest value such that
∑
−
=
1
(^20)
r
k
n (^) k
α n .
Thus the confidence interval has coverage probability of at least 1 − α.
Normal Distribution
Assuming the ratios follow a normal distribution, a two-sided 100%× ( 1 −α) confidence interval for the median of a normal distribution is
( R + g (α 2 ; 0. 5 , d ) × s , R + g ( 1 − α 2 ; 0. 5 , d )× s )
where g ( (^) γ ; p , d )are values defined in Table 1 of Odeh and Owen (1980).
The value g ( (^) γ ; p , d )is, in fact, the solution to the following equations:
Pr^ ( T^ d ≤ g n |δ = Kp n )=γ
with Td follows a noncentral Student t -distribution where d is degrees of freedom associated with the standard deviation s , δ is noncentrality parameter, γ is the probability, n is the sample size, and K (^) p is the upper p percentile point of a standard normal distribution.
The normal distribution is used to approximate the distribution of the ratios. The 100%× ( 1 −α)confidence interval for the mean is:
n
i
1
2 α 2 ; 1
n
i
F fi 1
Using the Delta method, variance of the weighted mean is approximated as
( ) ( ) ( ) 4
2 2 3
var 2 cov , var var S
where
( ) ( )
( ) 2 1
2 1
2 1
var f A A f F F
n
i
i
n
i
∑ i^ i ∑ = =
( ) ( )
( ) 2 1
2 1
2 1
var f S S f F F
n
i
i
n
i
∑ i^ i ∑ = =
= , and
( ) ( )
( )( ) 2 1
2 (^11)
cov , f A A S S f F F
n
i
i
n
i
∑ i^ i i ∑ = =
References
International Association of Assessing Officers (1990). Property Appraisal and Assessment Administration. International Association of Assessing Officers: Chicago, Illinois. Odeh, Robert E., and Owen, D. B. (1980). Tables for Normal Tolerance Limits, Sampling Plans, and Screening. Marcel Dekker: New York.