Urban Data analysis (statistics) questions

profileKnowledgeCats
 (Not rated)
 (Not rated)
Chat

 

 Use the table below to answer the following questions:

 

 

 

           

 

 

 

FREQUENCY

PERCENT

VALID PERCENT

CUMULATIVE PERCENT

Valid

Protestant

Catholic

Jewish

None

Other

953

333

31

140

35

63.5

22.2

2.1

9.3

2.3

63.9

22.3

2.1

9.4

2.3

63.9

86.2

88.3

97.7

100.0

Missing

Total

DK

NA

1492

1

7

99.5

.1

.5

100.0

 

 

Total

Total

8

1500

.5

100.0

 

 

 

 

 

1) How many respondents did not provide data?

 

 

 

2) What percentage of respondents is protestant?

 

 

 

3) How many of the respondents are protestant?

 

 

 

4) What proportion of respondents is catholic?

 

 

 

Use the table below to answer the following questions:

 

 

 

How Do You Get to Class?

 

Car

Public transportation

Walk

Bike

Other

 

 

37

18

28

12

20

Total

115

 

 

 

5) How many respondents provided data for this table?

 

 

 

6) What percent of respondents either bike or walk?

 

 

 

 

 

 

 

 

 

 

 

- Use the frequencies in the table below to fill in the percent, valid percent, and cumulative percent columns. Then use the table to answer the following questions

 

 

 

THINK OF SELF AS LIBERAL OR CONSERVATIVE

 

 

 

FREQUENCY

PERCENT

VALID PERCENT

CUMULATIVE PERCENT

Valid

Extremely Liberal

Liberal

Slightly Liberal

Moderate

Slightly Conservative

Conservative

Extremely Conservative

139

524

517

1683

618

685

167

 

 

 

 

Missing

Total

DK

NA

4333

154

23

 

 

 

Total

 

177

4510

100.0

 

 

 

 

 

7) Is this variable nominal, ordinal, or interval/ratio?

 

 

 

8) What percent of respondents are either slightly conservative or slightly liberal?

 

 

 

Construct a frequency table using the data below. Then use the table to answer the following questions.

 

 

 

How often do you use the library?

 

Daily

 

 

Several times a week

 

Weekly

 

 

Daily

 

 

Never

Several times a week

 

 

Daily

 

 

Daily

 

 

Several times a week

 

 

Weekly

Weekly

 

 

Several times a week

 

Never

 

 

Several times a week

 

Several times a week

Daily

 

 

Monthly

 

 

Several times a week

 

Several times a week

 

Monthly

Several times a week

 

Never

 

 

Several time a week

 

Daily

 

 

Weekly

 

 

 

9) How many attributes does this variable have?

 

 

 

10) How many respondents use the library on a daily basis

 

 

 

11) What percent of respondents use the library more often than monthly?

 

12) What proportion of respondents are married?

 

 

 

EXERSICE 2:

 

 

 

1) Calculate the median for the following raw data set:

 

3,6,2,4,3,5,4,7,4,2

 

 

 

2) Calculate the Mode and mean for the following raw data set:

 

9,6,5,5,10,7,3,5,6,15,8,9,10,2,3,11,4,6,7,13,10,5,6,6,3,9,

 

12

 

 

 

3) Calculate the median of the following frequency table (If the measure doesn’t apply, indicate so by answering “not applicable”):

 

 

 

Labor force status

 

 

 

FREQUENCY

PERCENT

VALID PERCENT

CUMULATIVE PERCENT

Valid

Working full time

Working part time

Temp not working

Unempl, laid off

Retired

School

Keeping House

Other

2321

440

84

143

712

139

490

177

51.5

9.8

1.9

3.2

15.8

3.1

10.9

3.9

51.5

9.8

1.9

3.2

15.8

3.1

10.9

3.9

51.5

61.3

63.1

66.3

82.1

85.2

96.1

100.0

 

 

Missing

 

Total

Total

 

NA

4506

 

4

 

4510

99.9

 

.1

 

100.0

100.0

 

 

 

 

4) For the table below calculate the Mode and Mean (if a measure doesn’t apply, indicate so by answering “not applicable”):

 

 

 

AGE OF RESPONDENT

 

 

FREQUENCY

PERCENT

VALID PERCENT

CUMULATIVE PERCENT

VALID 18

      19

      20

      21

      22

      23

19

47

50

52

72

63

6.3

15.5

16.5

17.2

23.8

20.8

6.3

15.5

16.5

17.2

23.8

20.8

6.3

21.8

38.3

55.4

79.2

100.0

     Total

303

100.0

100.0

 

 

 

 

5)For the table below:

 

 

 

a) Explain what happens to the mode if we add an outlier with a very high value.

 

 

 

b) Explain what happens to the median if we add an outlier with a very high value.

 

 

 

c) Explain what happens to the mean if we add an outlier with a very high value.

 

 

 

Education Spending

 

 

 

FREQUENCY

PERCENT

VALID PERCENT

CUMULATIVE PERCENT

Valid

Too little

About right

Too much

1111

281

95

24.6

6.2

2.1

74.7

18.9

6.4

74.7

93.6

100.0

 

Missing

Total

NAP

DK

1487

3002

21

33.0

66.6

.5

100.0

 

 

 

Total

Total

3023

 

4510

67.0

 

100.0

 

 

 

 

 

6) For the table below calculate the median (if the measure doesn’t apply, indicate so by answering “not applicable”)

 

 

 

Improving & Protecting Environment

 

 

 

FREQUENCY

PERCENT

VALID PERCENT

CUMULATIVE PERCENT

Valid

Too little

About right

Too much

506

178

37

33.7

11.9

2.5

70.2

24.7

5.1

70.2

94.9

100.0

 

Missing

Total

NAP

DK

NA

721

752

22

5

48.1

50.1

1.5

.3

100.0

 

 

 

Total

Total

 

 

779

 

1500

51.9

 

100.0

 

 

 

 

 

    • 10 years ago
    Urban Data analysis (statistics) questions Solution
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      urban_data_analysis_statistics_questions_solution.docx