Question #3 please
PROBLEMS Note: Student solutions for problems whose numbers appear within or "Female"; (2) change Children to list "No a color box are available for purchase at www.cengagebrain.com. children" or "At least one child"; (3) change Salary Level A to be categorical with categories "Less than $40K,' "Between $40K and $70K." "Between $70K 1. The file P02_01.xisx indicates the gender and national- and $100K," and "Greater than $100K " (where ity of the MBA incoming class in two successive years you can treat the breakpoints however you like); at the Kelley School of Business at Indiana University. and (4) change Opinion to be a numerical code a. For each year, create tables of counts of gender and from 1 to 5 for Strongly Disagree to Strongly of nationality. Then create column charts of these Agree. Then create a column chart of counts for the counts. Do they indicate any noticeable change in new Salary variable. the composition of the two classes? 4. The file P02_04.xlex contains salary data on all Major b. Repeat part a for nationality, but recode this League Baseball players for each year from 2002 variable so that all nationalities that have counts of to 2011. (It is an older version of the data used for 1 or 2 are classified as Other. examples later in this chapter.) For any three selected 2. The file P02_02.xlex contains information on over 200 years, create a table of counts of the various positions, movies that were released in 2006 and 2007. expressed as percentages of all players for the year. Then a. Create two column charts of counts, one of the create a column chart of these percentages for these different genres and one of the different distributors. years. Do they remain fairly constant from year to year? b. Recode the Genre column so that all genres with a count of 10 or less are lumped into a category Level B called Other. Then create a column chart of counts 5. The file DJIA Monthly Close.xlex contains monthly for this recoded variable. Repeat similarly for the values of the Dow Jones Industrial Average from 1950 Distributor variable. through July 2015. It also contains the percentage 3. The file P02_03.xlex contains data from a survey of 399 changes from month to month. (This file is used in an people regarding a government environmental policy. example later in this chapter.) Create a new column for a. Which of the variables in this data set are categorical? recoding the percentage changes into six categories: Which of these are nominal; which are ordinal? Large negative (-3%), Small negative (-1%), Small positive of counts. (0%), Medium positive (1%), and Large c. Recode the data into a new data set, making four positive (>3%). Then create a column chart of the counts transformations: (1) change Gender to list "Male" of this categorical variable. Comment on its shape
