Question

For each variable:

Construct a frequency distribution

Calculate appropriate measures of central tendency

Calculate appropriate measures of dispersion

Write a sentence or two summarizing the frequency distribution, central tendency, and dispersion of each variable

Each item is worth 10 points for a total of 40 points.

Survey Items:

1. What is your age in years? (Values are actual ages.)

2. Educational level

                        0. Less than HS

                        1. High School

                        2. Jr. College

                        3. Bachelor's degree

                        4. Graduate school

3. Gender

                        1. Male

                        2. Female

4. "White people have a right to keep Blacks out of their neighborhoods. "

                        1. Agree strongly

                        2. Agree slightly

                        3. Disagree slightly

                        4. Disagree strongly

Please see the next page for the dataset.

Segregated

Case     Age    Degree    Sex    Neighborhoods

1         29       3          2                    4

2         38       3        2                    4

3         63       2        2                    4

4         30       1        1                    3

5         38       1        1                    2

6         48       3        1                    3

7         28       1        2                    2

8         30       3        2                    2

9         25       0        2                    3

10        35       1        1                    4

11        73       0        2                    3

12        55       3        1                    4

13        70       4        2                    4

14        50       1        2                    1

15        62       0        1                    2

16        45       3        1                    2

17        45       2        2                    4

18        35       1        1                    2

19        74       1        2                    4

20        32       0        1                    1

21        36       1        1                    4

22        29       1        2                    2

23        42       3        2                    1

24        40       1        2                    4

25        35       1        2                    3

26        68       3        2                    4

27        38       1        2                    2

28        32         2        2                    4

29        50       0        2                    3

30        26       1        2                    4

Answer 1

Age:

the distribution of age is approximately normally distributed as the value of skewness is 0.8. The best measure of Central tendency for a normally distributed variable is mean. The best measure of dispersion is the standard deviation. The average mean is 43 years with a low standard deviation of 15 units.

	Age	Excel function used
mean	43.367	AVERAGE
median	38	MEDIAN
mode	38	MODE
SD =	14.83584507	STDEV(B2:B31)
range = max-min	49	MAX(B2:B31)-MIN(B2:B31)
Q1=	32	QUARTILE(B2:B31,1)
Q3=	50	QUARTILE(B2:B31,3)
IQR = Q3-Q1	18
skew	0.832	SKEW

degree, sex, And neighbourhood:

degree, sex, And neighbourhood and measured by the nominal scale of measurement. Their corresponding frequency distribution is given below. The best measure of Central tendency for these variables is mode.

Degree	Count of Degree
0	5
1	13
2	3
3	8
4	1
Grand Total	30

High school is the best measure of Central tendency for a degree as it has the highest frequency of 13.

Gender	Count of Sex
1	10
2	20
Grand Total	30

Female is the best measure of Central tendency for gender as it has the highest frequency of 20 in comparison to males.

Neighbourhoods	Count of Neighborhoods
1	3
2	8
3	6
4	13
Grand Total	30

The best measure of Central tendency for the neighbourhood is a mode for the category of Disagree strongly. There are 13 individual followings under the category of disagree strongly for neighbourhoodFemale is the best measure of Central tendency for gender as it has the highest frequency of 20 in comparison to males.