Question
Perform the appropriate descriptive analysis of the data given in the frequency table below. Give the measures of variability using excel. The people surveyed answered
Perform the appropriate descriptive analysis of the data given in the frequency table below. Give the measures of variability using excel. The people surveyed answered the question of how many adults live in their household. There were a total of 12801 people surveyed. In the data table, -1 represents the 33 missing answers from the people who were surveyed. 1649 people stated that 1 person lives in the household, 3723 people said 2 people lived in the household, and so on.
Label: Number of adults who live in the household
Missing Values: -1
Measurement: Scale
# of Adults | Frequency |
1 | 1649 |
2 | 3723 |
3 | 2191 |
4 | 1743 |
5 | 1209 |
6 | 809 |
7 | 519 |
8 | 389 |
9 | 202 |
10 | 134 |
11 | 57 |
12 | 49 |
13 | 22 |
14 | 19 |
15 | 16 |
16 | 7 |
17 | 4 |
18 | 8 |
19 | 0 |
20 | 5 |
21 | 2 |
22 | 3 |
23 | 1 |
24 | 0 |
25 | 1 |
26 | 0 |
27 | 0 |
28 | 1 |
29 | 0 |
30 | 2 |
31 | 1 |
32 | 0 |
33 | 1 |
34 | 0 |
54 | 1 |
-1 | 33 |
12801 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
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