Individual assignment two linear regression and multiple regression
Question 1 (10 marks)
Baseball is a sport that generates a lot of data, which fans use to try to predict the factors that lead to successful teams. One fan compiled the team batting average and the team percentage of games won for the 14 American League teams at the end of a recent season. The presumption is that a team with a greater batting average should win more games. Supposing that these data represent a random collection of observations of these two measures, let’s explore whether batting average can predict winning percentage. The data are stored in the file Baseball.xls.

Plot the data, and comment on what you observe.

Find the correlation coefficient.

Find the coefficient of determination R2, for this data, and interpret its meaning.

Find the sample regression line, and interpret the meaning of the coefficients of your equation.

Is there evidence at a 5% level of significance, that batting average can be used to predict winning percentage?
Question 2 (10 marks)
Physicians are recommending more exercise for patients, especially those who are overweight. One benefit of regular exercise is thought to be a reduction of bad cholesterol. To study the relationship, a doctor selected a sample of patients who did not do regular exercise, and measured their cholesterol level. She then started the patients on a program of exercise, and asked them to record the number of minutes per week that they exercised. After 4 months, she remeasured their cholesterol levels. The data are contained in the file Cholesterol.xls.

Plot the data. Does it appear that amount of exercise and cholesterol level change is related?

Determine the regression equation relating cholesterol reduction to amount of exercise, and find a 95% confidence interval for the intercept. Provide a brief and meaningful written interpretation of the coefficients and the confidence interval.

Can we conclude that exercise affects the change in cholesterol level of the exerciser?

How well does the linear model fit this data? Justify.
Question 3 (10 marks)
Hardwood trees are harvested in a selective manner for the manufacture of fine furniture. Environmental groups are concerned that as few trees are selected for cutting as possible while companies feel that they need a certain amount of wood for manufacturing. To help each group predict the volume of lumber in a selected tree, various measurements are made before the tree is cut. Unfortunately, volume is not easily determined before harvesting.
Two common measurements made before cutting down the tree are DBH (the diameter of the tree at breast height, 4.5 feet off the ground) and the height of the tree measured with sighting instruments. After the tree is harvested the volume of lumber may be measured.
Both groups believe that a regression model relating volume to diameter and/or height will be helpful. The data file below gives the diameters, heights, and volumes of 31 trees harvested in the Allegheny National Forest in Pennsylvania.
The data are contained in the file Wood.xlsx.

Estimate the two simple regression models and the multiple regression model that is appropriate for these data.

Which model would you recommend that the two groups use? Why?

A tree with a height of 72 and a diameter of 15.9 has just arrived at the mill. What volume can be expected?
Question 4 (10 marks)
Lotteries are important sources of revenue for governments and charities. Many people have criticized lotteries, however, as taxes on the poor and uneducated. To explore the issue, a sample of 100 adults was asked how much they spend on lottery tickets and a number of socioeconomic variables. The study was meant to test the following beliefs:
I. Relatively uneducated people spend more on lotteries that do educated people.
II. Older people spend more on lotteries than do younger.
III. People with more children spend more that people with fewer.
IV. Relatively poor people spend a greater proportion of their income on lotteries that the better off.
The file Lottery.xls contains data for the 100 respondents on the amount spend on lottery tickets as a percentage of household income, number of years of education, age, number of children and personal income (in thousands of dollars).

Develop a regression model relating lottery expenditures to all of the variables.

Test each of the four beliefs at the 5% level using your model. What conclusions can you draw?
Question 5 (10 marks)
A large corporation was recently accused of discriminating against female managers. A random sample of 100 managers from the firm found that the mean annual salary of the 38 female managers in the sample was $76,189, and the mean annual salary of the 62 male managers was $97,832. This looks like pretty damning evidence of discrimination. The CEO of the corporation was indignant, claiming that the firm followed a strict policy of equal pay for equal work, and that maybe some other factor or factors were responsible for the perceived differences. He has asked you to look into this, and you were able to find the number of years of education and years of experience for each member of the sample. These data are contained in the file Discrimination.xls, which records the member’s gender/sex as a 0 for males and a 1 for females.

Do these data taken as a whole explain a substantial amount of the variation in salaries among these managers?

What is your best estimate of the systematic difference between male and female salaries?

Does it appear that gender/sex is a significant factor in the differences in salary in this sample?