Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The file P 0 2 _ 0 3 . xlax contsins date from a sunvey of 3 9 9 people regerding a govemment environmentsl policy.

The file P02_03. xlax contsins date from a sunvey of 399 people regerding a govemment environmentsl policy. Which of the verisble: in this dats set are categorical? Which of
these are nominst; which are ordinal? For each categorical varibble, creste a column chart of counts. Recode the data into a new date set, making four transfometions: (1)
chenge Gender to list "Male" or Femsle"; (2) chenge Children to list "No children" or "At lesst one child"; (3) chenge Selary to be categorical with categories "Less then S40K,".
Between $40K and $70K, "Between $70K and $100K" and "Greater than $100K"(where you can treat the bresipoints however you like); and (4) change Opinion to be a
numeric code from 1 to 5 for Strongly Diagree to Strongly Agree. Then create a column chart of count: for the new Selsry verisble Person Age Gender State Children Selsry
Opinion 4 Young 2 Califomis 05.36,025 Agres 15 Young 2 Texes 2 S47,172 Neutral 20 Young 2 lllinois 1553,3.35 Strongly dissgree 29 Young 2 Califomis 2 S.37,963 Strongly
dissgres 32 Young 2 Virginis 2549, S05 Strongly disegree 33 Young 1 Calfomis 3 $49,723 Strongly dissgres 36, Young 2 Arizone 3 $39,645 Strongly diasgree 40 Young 2 Virginis
$.30,020 Neutrel 64 Young 2 New York 0 $37,25.5 Dissgree 66. Young 1 Arizone 2 $45,424 Diasgree 75 Young 2 Virginis 0 $55,26.9 Strongly sgree 76 Young 2 Arizona 2 $26,600
Agree Bo Young 1 Floride 2 S4B,213 Agree B8 Young 2 Ohio 2 S39,733 Neutral 90 Young 2 Virginis 2 S3B,097 Strongly sgree 92 Young 2 Celifornis 3 S48,251 Strongly diaggree
96 Young 2 Chio 2 $41,734 Neutral 101 Young 2 Arizone 2 $4.3,267 Strongly agree 117 Young 1 New York 0 $72,2.39 Neutral 130 Young 1 Virginia 1 $52,16.3 Disegree 132
Young 2 Ohio 2 $54,784 Agree 138 Young 2 Floride 2 $46,015 Disegree 149 Young 2 Colfomia 0 $53,306 Neutrel 150 Young 2 Florids 2 $41,978 Strongly dissgree 152 Young 1
Floride 3 $49,16.5 Agree 156 Young 1 Ohio 0 $51,612 Neutral 159 Young 1 Texs: 0 $57,217 Strongly agree 163 Young 2 Ohio 3 $51,169 Neutral 169 Young 2 Michigen 1 $
36,564 Agree 180 Young 2 Ohio 2 $28,124 Disegree 185 Young 1 Virginis 1 St5,992 Agree 186 Young 2 Californis 0 $46, B4B Strongly diasgree 187 Young 2 New York 2 S45,950
Neutral 193 Young 1 Minnesote 2 $41,774 Neutral 196 Young 1 Calfomia 1 $57,429 Strongly disagree 197 Young 1 Arizone 0 $.37,929 Strongly s9ree 207 Young 1 Floride 3 $
47,017 Agres 216 Young 1 Arizons 0 $43,045 Strongly sgree 22.3 Young 2 Miehigsn 2 $50,386 Strongly dissgree 224 Young 2 lllinois 2 S23,109 Strongly disegree 230 Young 2
Michigen 0 $50, S16 Strongly disegres 277 Young 2 Ohio 2 $23,657 Strongly agree 278 Young 2 New York 3 $45,022 Strongly sgree 293 Young 2 Michigen 2 $5B, S44 Strongly
sgres 295 Young 2 Floride 2 $38,514 Strongly disegree 303 Young 1 Virginie 2 $44,006 Strongly disegree 304 Young 2 Californis 1 $46,239 Strongly egree 307 Young 1
California 2 $52,686 Strongly sgree 312 Young 2 New York 2 $20,687 Strongly sgres 317 Young 1 Arizons 1 S3B,114 Strongly sgree 320 Young 2 Mikhigsn 2 S43,604 Agree 322
Young 2 Virginia 2 $44,107 Dissgres 324 Young 1 Arizons 0 $43,773 Agree 328 Young 2 Texes 2 $48,643 Disegree 331 Young 1 Arizone 2 $40, B83 Disegree 333 Young 1 Virginis
Agree 352 Young 1 New York 2 $44,964 Strongly dasgree 354 Young 2 Ohio 2 $44,511 Agree 356 Young 1 Virginis 1 $50,729 Strongly sgree 359 Young 2 Texs: 2 $69,78.
Dissgres 364 Young 1 Arizons 3 S42,300 Dissgree 376 Young 2 Arizons 0 S41,126, Agres 381 Young 2 Virginis 2 $46,198 Neutral 383 Young 2 Florids 2 S49,538 Disagree 388
Young 1 Minnesots 1 $43,918 Strongly sgres 390 Young 2 Florids 2 $47,293 Strongly diasgree 392 Young 1 Arizone 1 $50,434 Strongly diasgree 1 Middle eged 2 Texs: 2$
Strongly diasgree 10 Midale sged 1 llincis 3 S8
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transport Operations

Authors: Allen Stuart

2nd Edition

978-0470115398, 0470115394

More Books

Students also viewed these General Management questions