Studyportal

Assignment Task

Getting to know the data and the variables of the data set.

1. Rename the sheet: “Survey_data”
2. Determine the number of variables in the dataset.
3. Determine the number of observations contained in the dataset.
4. What are the quantitative and qualitative variables?
5. Identify the variables that are measured on a ratio scale, interval scale, ordinal scale, and nominal scale.
6. What are the categories of the variable “Sex Household Head Marita Status Hea Household
7. How many categories does the variable Educ level Household Head have? Primary income source?
8. For each variable, insert a note to describe the variable.
9. Sort the data household size (ascending order)
10. Sort the data by education level.

Exploring the distribution of each variable

1. Generate a frequency table for each categorical variable.
2. From the frequency table generated for each categorical variable, determine the mode.
3. Generate cross tables for each pair of categorical variables.
4. After adding a filter to the crosstabs generated.

Computing summary statistics

1. Calculate the central tendency measures for each variable: mean, median, and mode.
2. Calculate the spread for each variable: variance, standard deviation, and range.
3. For each quantitative variable, provide the summary statistics (using data analysis tab)
4. Calculate the covariance and correlation between each pair of quantitative variables.
5. Generate an ordinal variable for age and income: “age_range”, income_range.
6. Generate a crosstab for age_range and income range. Can you calculate the correlation between these two variables? Why?