Q1. The file P02_03.xlsx contains data from a survey of 399 people regarding a government environmental policy.
a) Which of the variables in this data set are categorical? Which of these are nominal; which are ordinal?
b) For each categorical variable, create a column chart of counts.
c) Record 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 $40K", "Between $40K and $70K", "Between $70K and $100K", (where you can treat breakpoints however you like); and
(4) Change opinion to be numerical code from 1 to 5 for Strongly Disagree to Strongly Agree. Then create a column chart of counts for the new Salary variable.
Q2. Recall that the file Baseball Salaries 2009.xlsx contains data on 818 MLB players as of May 2009. Using this data set, answer the following questions:
a) Find the mean and median of the salaries of all shortstops. Are any of these measures influenced significantly by one or more unusual observations?
b) Find the standard deviation, first and third quartiles, and 5th and 95th percentiles for the salaries of all shortstops. Are any of these measures influenced significantly by one or more unusual observations?
c) Create a histogram of the salaries of all shortstops. Are any of these measures influenced significantly by one or more unusual observations?
Attachment:- Assignment.rar