Tableau assignment
zxy0120
Fall2017MetadataforTableauAssignment.docx1
Column Variable
B Age 18-34
C Age 35-54
D Age 55 >
Region of Residence
E West
F North Central
G North East
H South
Gender
I Male
J Female
ETC
Note: Missing: PEXP variables
Meta data description
The first column is the year-month. The demographic variables are Age Group, Region Group, Gender Group, and Income Group.
Explanation of variables
For the first variable pexp_r, we have pexp_r_a1834, pexp_r_a3554, pexp_r_a5597 (Age Groups), pexp_r_w, pexp_r_nc, pexp_r_ne, pexp_r_s (Region Groups), pexp_r_m, pexp_r_f (Gender Groups), pexp_r_y13, pexp_r_y23, pexp_r_y33 (Income Groups).
The variable name is pexp_r. The suffix “_a1834” represents the age group 18-34. See the following tables for additional information.
Note: The “monthly” in the above data means that all of the data are monthly data.
The other variables are categorized into 5 groups: Personal Finance, Savings and Retirement, Household Goods Buying Conditions, Home Buying and Selling Conditions, Vehicle Buying Conditions.
Personal Finance Variables:
pexp_r - Expected Change in Financial Situation in a Year
rinc_r - Expected Change in Real Household Income during Next Year
pinc2_mean - Probability of Personal Income Increase during the Next Year
pinc_mean - Probability of Real Income Gains during the Next 5 Years
pjob_mean - Probability of Losing a Job During the Next 5 Years
Savings and Retirement:
inv_r50 - Current Value of Stock Market Investments
Household Goods Buying Conditions:
dur_r - Buying Conditions for Large Household Durables
Vehicle Buying Conditions:
veh_r - Buying Conditions for Vehicles
Home Buying and Selling Conditions
hom_r - Buying Conditions for Houses
homval_r - Change in Home Values During the Past Year
pexp_r_a1834 represents the survey result of pexp_r whose respondents’ age are between 18 to 34.
Check out the web site for additional information:
https://data.sca.isr.umich.edu/
