The file P02_35.xlsx contains (fictional) data from a survey of 500 randomly selected households. a. Indicate the type of data for each of the variables
The file P02_35.xlsx contains (fictional) data from a survey of 500 randomly selected households.
a. Indicate the type of data for each of the variables included in the survey.
b. For each of the categorical variables in the survey, indicate whether the variable is nominal or ordinal, and why.
c. Create a histogram for each of the numerical variables in this data set. Indicate whether each of these distributions is approximately symmetric or skewed. Which, if any, of these distributions are skewed to the right? Which, if any, are skewed to the left?
d. Find the maximum and minimum debt levels for the households in this sample.
e. Find the indebtedness levels at each of the 25th, 50th, and 75th percentiles.
f. Find and interpret the interquartile range for the indebtedness levels of these households.
Step by Step Solution
3.45 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
The household data is given below a The type of data for each type of variable is as follows Family Size First Income Second Income Monthly Payment Utilities and Debt are Numerical Variables as the me...See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started