Likely answers to graded foxpro assignment

(remember appropriate selection criteria, including filtering out blank cities as needed)

OWNERS	PROPERTIES
James Clark	42
Pheasant Ridge	31
Atlantic Ltd	20
Condo - multiple owners	17
Hawkeye RE	17

OWNERS	UNITS
James Clark	438
Atlantic Ltd	400
Barker Partner	288
Pheasant Ridge	248
Hawkeye RE	186

MANAGERS	PROPERTIES
AUR	68
Keystone	30
Lincoln	26
Chambers	21
Westwinds	21

MANAGERS	UNITS
AUR	815
Atlantic Ltd	400
Lincoln	385
Keystone	314
Barker	288

ABSENTEE OWNERS	PROPERTIES	STATE
Atlantic Ltd	20	MI
Craig H	4+3	CA
Cedarwood	3	VA
Autumn Park	2	MO
R Ziock	2	MO
T Huff	2	CA

ABSENTEE OWNERS	UNITS	STATE
Atlantic Ltd	400	MI
Holiday	104	OR
Autumn Park	64	MO
Cedarwood	64	VA
T Huff	58	CA
Craig H	41+36	CA

 
 
958 out of state owned units, if the city is set to be not blank on selection criteria. Total of 8891 units. 958/8891=10.8%

OWNER	UNITS	% of UNITS
James Clark	438	4.9%
Atlantic Ltd	400	4.5%
Barker Partner	288	3.2%
Pheasant Ridge	248	2.8%
Hawkeye Real Estate	186	2.1%
Condo - mult	161	1.8%
Edwin Barker	158	1.8%
Holiday Retirement	104	1.2%
Town & Campus	100	1.1%
Uptown	97	1.1%
SUBTOTAL	2180	24.5%
TOTAL UNITS	8891