The file S02_32.xlsx contains blood pressures for 1000 people, along with variables that can be related to blood pressure. These other variables have a number of missing values, probably because some people didn’t want to report certain information. For each of the Alcohol, Exercise, and Smoke variables, use StatTools to find the mean, median, and standard deviation of Blood Pressure, broken down by whether the data for that variable is missing. For example, there should be one set of statistics for people who reported their alcohol consumption and another for those who didn’t report it. Based on your results, does it appear that there is any difference in who didn’t?
Answer to relevant QuestionsThe file S02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. a. Create a table of correlations between the variables Age, Prior Experience, Beta Experience, Education, and Annual Salary. ...The file S02_39.xlsx lists the average high school student scores on the SAT exam by state. There are three components of the SAT: critical reading, math, and writing. These components are listed, along with their sum. The ...Solve problem 1 with pivot tables and create corresponding pivot charts. Express the counts as percentage of row. What do these percentages indicate about this particular data set? Then repeat, expressing the counts as ...The Wall Street Journal CEO Compensation Study analyzed CEO pay from many U.S. companies with fiscal year 2008 revenue of at least $5 billion that filed their proxy statements between October 2008 and March 2009. The data ...The file S03_50.xlsx lists NBA salaries for five seasons. a. Merge all of the data into a single new sheet called All Data. In this new sheet, add a new column Season that lists the season, such as 2006–2007. b. Note that ...
Post your question