# Question: Repeat the previous problem with the basketball data in the

Repeat the previous problem with the basketball data in the file P03_56.xlsx.

a. Rearrange the data so that there are four long columns: Team, Year, Salary, and Wins. There should be 6*30 values for each.

b. Create a scatter plot of Wins (Y) versus Salary (X). Is there any indication of a relationship between these two variables? Is it a linear relationship?

c. Run a regression of Wins versus Salary. What does it say, if anything, about teams buying their way to success?

a. Rearrange the data so that there are four long columns: Team, Year, Salary, and Wins. There should be 6*30 values for each.

b. Create a scatter plot of Wins (Y) versus Salary (X). Is there any indication of a relationship between these two variables? Is it a linear relationship?

c. Run a regression of Wins versus Salary. What does it say, if anything, about teams buying their way to success?

**View Solution:**## Answer to relevant Questions

Repeat Problem 51 with the football data in the file P03_57.xlsx. a. Rearrange the data so that there are four long columns: Team, Year, Salary, and Wins. There should be 6*30 values for each. b. Create a scatter plot of ...The file P02_35.xlsx contains data from a survey of 500 randomly selected households. For this problem, use Monthly Payment as the dependent variable in several regressions, as explained below. a. Beginning with Family Size, ...Suppose you run a regression on a data set of Xs and Ys and obtain a least squares line of Y = 12 - 3X.a. If you double each value of X, what is the new least squares line?b. If you triple each value of Y, what is the new ...Howie’s Bakery is one of the most popular bakeries in town, and the favorite at Howie’s is French bread. Each day of the week, Howie’s bakes a number of loaves of French bread, more or less according to a daily ...The file P10_10.xlsx contains data on 150 homes that were sold recently in a particular community. a. Find a table of correlations between all of the variables. Do the correlations between Price and each of the other ...Post your question