# Question

The file S02_12.xlsx includes data on the 50 top graduate programs in the U.S., according to a recent U.S. News & World Report survey.

a. Create a table of correlations between all of the numerical variables. Discuss which variables are highly correlated with which others.

b. The Overall score is the score schools agonize about. Create a scatter plot and corresponding correlation of each of the other variables versus Overall, with Overall always on the Y axis. What do you learn from these scatter plots?

a. Create a table of correlations between all of the numerical variables. Discuss which variables are highly correlated with which others.

b. The Overall score is the score schools agonize about. Create a scatter plot and corresponding correlation of each of the other variables versus Overall, with Overall always on the Y axis. What do you learn from these scatter plots?

## Answer to relevant Questions

Recall from an example in the previous chapter that the file Supermarket Transactions.xlsx contains over 14,000 transactions made by supermarket customers over a period of approximately two years. Set up a single pivot table ...The file S03_66.xlsx lists a lot of data for each NFL team for the years 2004 to 2009. The variables are divided into groups: (1) Overall success, (2) Team Offense, (3) Passing Offense, (4) Rushing Offense, (5) Turnovers ...Suppose that 18% of the employees of a given corporation engage in physical exercise activities during the lunch hour. Moreover, assume that 57% of all employees are male, and 12% of all employees are males who engage in ...A study has shown that the probability distribution of X, the number of customers in line (including the one being served, if any) at a checkout counter in a department store, is given by P(X = 0) = 0.25, P(X = 1) = 0.25, ...The probability distribution of X, the number of customers in line (including the one being served, if any) at a checkout counter in a department store, is given by P(X = 0) = 0.25, P(X = 1) = 0.25, P(X = 2) = 0.20, P(X = 3) ...Post your question

0