Hi, Please c heck the attached file for details, the calculation is in the excel file. Let me know if you have any questions, thank you. James,

1.
The first three columns, “Annual Food Spending”, “Annual Household Income” and “Non mortgage
household debt”, all in amount of dollars, is quantitative, because these variable are expressed in numerical
and represent a measurable quantity. In a quantitative variable, we can determine the two its values be
determining from their numerical values. The last two columns, “region” and “location” are qualitative
variables, because these are categorical, and their numbers are label. In quantitative variable, the assign
of numerical values are arbitrary. For example, we can be just as well to assign metro area as 2 and
outside metro area as 1.
2. The levels of measurement of first three columns are all ratio, because there all have a non-arbitrary
zero point, and the magnitude of one element can be compared directly to that of others. For example,
the household income of two families can be compare directly, and the ratio of two household incomes is
meaningful. The levels of measurement of last two columns are both nominal. They both belong to
qualitative classification variables. The numbers that are assigned to them are arbitrary and
interchangeable, and those numbers do not have regular numerical meaning that related to t...