The file P$02\_03.$xlsx contains data from a survey of $399$ people regarding a government environmental policy.

Which of the variables in this data set are categorical? Which of these are nominal; which are ordinal?

For each categorical variable, create a column chart of counts.

Recode the data into a new data set, making four transformations: $(1)$ change Gender to list $$Male$$ or $$Female$$; $(2)$ change Children to list $$No children$$ or $$At least one child$$; $(3)$ change Salary to be categorical with categories $$Less than $$40$K$,$Between $$40$K and $$70$K$,$Between $$70$K and $$100$K$,$ and $$Greater than $$100$K $($where you can treat the breakpoints however you like$)$; and $(4)$ change Opinion to be a numeric code from $1$ to $5$ for Strongly Disagree to Strongly Agree. Then create a column chart of counts for the new Salary variable.Person Age Gender State Children Salary Opinion

$4$ Young $2$ California $0$ $$36,025$ Agree

$15$ Young $2$ Texas $2$ $$47,172$ Neutral

$20$ Young $2$ Illinois $1$ $$53,335$ Strongly disagree

$29$ Young $2$ California $2$ $$37,963$ Strongly disagree

$32$ Young $2$ Virginia $2$ $$49,505$ Strongly disagree

$33$ Young $1$ California $3$ $$49,723$ Strongly disagree

$36$ Young $2$ Arizona $3$ $$39,665$ Strongly disagree

$40$ Young $2$ Virginia $2$ $$47,927$ Disagree

$49$ Young $2$ Ohio $0$ $$35,629$ Disagree

$51$ Young $1$ California $0$ $$41,967$ Strongly disagree

$56$ Young $2$ Minnesota $2$ $$55,958$ Disagree

$63$ Young $1$ Minnesota $2$ $$30,020$ Neutral

$64$ Young $2$ New York $0$ $$37,255$ Disagree

$66$ Young $1$ Arizona $2$ $$45,424$ Disagree

$75$ Young $2$ Virginia $0$ $$55,269$ Strongly agree

$76$ Young $2$ Arizona $2$ $$26,600$ Agree

$80$ Young $1$ Florida $2$ $$48,213$ Agree

$88$ Young $2$ Ohio $2$ $$39,733$ Neutral

$90$ Young $2$ Virginia $2$ $$38,097$ Strongly agree

$92$ Young $2$ California $3$ $$48,251$ Strongly disagree

$96$ Young $2$ Ohio $2$ $$41,734$ Neutral

$101$ Young $2$ Arizona $2$ $$43,267$ Strongly agree

$117$ Young $1$ New York $0$ $$72,239$ Neutral

$130$ Young $1$ Virginia $1$ $$52,163$ Disagree

$132$ Young $2$ Ohio $2$ $$54,784$ Agree

$138$ Young $2$ Florida $2$ $$46,015$ Disagree

$149$ Young $2$ California $0$ $$53,306$ Neutral

$150$ Young $2$ Florida $2$ $$41,978$ Strongly disagree

$152$ Young $1$ Florida $3$ $$49,165$ Agree

$156$ Young $1$ Ohio $0$ $$51,612$ Neutral

$159$ Young $1$ Texas $0$ $$57,217$ Strongly agree

$163$ Young $2$ Ohio $3$ $$51,169$ Neutral

$169$ Young $2$ Michigan $1$ $$36,564$ Agree

$180$ Young $2$ Ohio $2$ $$28,124$ Disagree

$185$ Young $1$ Virginia $1$ $$65,992$ Agree

$186$ Young $2$ California $0$ $$46,848$ Strongly disagree

$187$ Young $2$ New York $2$ $$45,950$ Neutral

$193$ Young $1$ Minnesota $2$ $$41,774$ Neutral

$196$ Young $1$ California $1$ $$57,429$ Strongly disagree

$197$ Young $1$ Arizona $0$ $$37,929$ Strongly agree

$207$ Young $1$ Florida $3$ $$47,017$ Agree

$216$ Young $1$ Arizona $0$ $$43,045$ Strongly agree

$223$ Young $2$ Michigan $2$ $$50,386$ Strongly disagree

$224$ Young $2$ Illinois $2$ $$23,109$ Strongly disagree

$230$ Young $2$ Michigan $0$ $$53,071$ Strongly disagree

$232$ Young $2$ Illinois $1$ $$55,677$ Agree

$233$ Young $1$ Illinois $3$ $$40,741$ Disagree

$239$ Young $2$ Virginia $0$ $$36,973$ Strongly agree

$242$ Young $2$ Florida $0$ $$52,109$ Disagree

$243$ Young $2$ California $3$ $$44,176$ Disagree

$245$ Young $1$ Florida $2$ $$47,096$ Strongly agree

$249$ Young $1$ Michigan $0$ $$51,081$ Agree

$250$ Young $2$ Minnesota $1$ $$31,314$ Strongly agree

$252$ Young $1$ Virginia $0$ $$53,173$ Disagree

$266$ Young $2$ Texas $1$ $$36,749$ Agree

$271$ Young $2$ Minnesota $1$ $$60,924$ Disagree

$272$ Young $2$ Michigan $0$ $$50,516$ Strongly disagree

$277$ Young $2$ Ohio $2$ $$23,657$ Strongly agree

$278$ Young $2$ New York $3$ $$45,022$ Strongly agree

$293$ Young $2$ Michigan $2$ $$58,544$ Strongly agree

$295$ Young $2$ Florida $2$ $$38,514$ Strongly disagree

$303$ Young $1$ Virginia $2$ $$44,006$ Strongly disagree

$304$ Young $2$ California $1$ $$46,239$ Strongly agree

$307$ Young $1$ California $2$ $$52,686$ Strongly agree

$312$ Young $2$ New York $2$ $$20,687$ Strongly agree

$317$ Young $1$ Arizona $1$ $$38,114$ Strongly agree

$320$ Young $2$ Michigan $2$ $$43,604$ Agree

$322$ Young $2$ Virginia $2$ $$44,107$ Disagree

$324$ Young $1$ Arizona $0$ $$43,773$ Agree

$328$ Young $2$ Texas $2$ $$48,643$ Disagree

$331$ Young $1$ Arizona $2$ $$40,883$ Disagree

$333$ Young $1$ Virginia $2$ $$36,607$ Neutral

$335$ Young $1$ Michigan $1$ $$48,225$ Neutral

$340$ Young $2$ Virginia $2$ $$38,258$ Neutral

$344$ Young $1$ Virginia $2$ $$44,628$ Neutral

$351$ Young $2$ Arizona $1$ $$49,687$ Agree

$352$ Young $1$ New York $2$ $$44,964$ Strongly disagree

$354$ Young $2$ Ohio $2$ $$44,511$ Agree

$356$ Young $1$ Virginia $1$ $$50,729$ Strongly agree

$359$ Young $2$ Texas $2$ $$69,785$ Disagree

$364$ Young $1$ Arizona $3$ $$42,300$ Disagree

$376$ Young $2$ Arizona $0$ $$41,126$ Agree

$381$ Young $2$ Virginia $2$ $$46,198$ Neutral

$383$ Young $2$ Florida $2$ $$49,538$ Disagree

$388$ Young $1$ Minnesota $1$ $$43,918$ Strongly agree

$390$ Young $2$ Florida $2$ $$47,293$ Strongly disagree

$392$ Young $1$ Arizona $1$ $$50,434$ Strongly disagree

$1$ Middle$-$aged $2$ Texas $2$ $$63,017$ Strongly agree

$2$ Middle$-$aged $2$ Virginia $3$ $$100,302$ Strongly disagree

$3$ Middle$-$aged $2$ California $0$ $$144,043$ Strongly agree

$5$ Middle$-$aged $1$ Texas $0$ $$97,543$ Neutral

$6$ Middle$-$aged $1$ California $3$ $$69,222$ Disagree

$7$ Middle$-$aged $2$ Michigan $2$ $$81,799$ Disagree

$8$ Middle$-$aged $2$ Texas $1$ $$101,894$ Agree

$9$ Middle$-$aged $1$ Virginia $0$ $$83,843$ Strongly disagree

$10$ Middle$-$aged $1$ Illinois $3$ $$8$