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.

  1. Plot the data, and comment on what you observe.

  2. Find the correlation coefficient.

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

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

  5. 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 re-measured their cholesterol levels. The data are contained in the file Cholesterol.xls.

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

  2. 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.

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

  4. 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.

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

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

  3. 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 socio-economic 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).

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

  2. 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.

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

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

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


Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Our customer is the center of what we do and thus we offer 100% original essays..
By ordering our essays, you are guaranteed the best quality through our qualified experts.All your information and everything that you do on our website is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The paper ordered is very original. Orders are checked by the most advanced anti-plagiarism software in the industry which ensures that the the essay written is 100% original. In that regard,we have a zero tolerance policy for plagiarism.

Read more

Free-revision policy

Our Company thrives on excellence and thus we help ensure the Customer’s total satisfaction with the completed Order.To do so, we provide a Free Revision policy as a courtesy service. To receive free revision the Company requires that the Customer provides the request within Fifteen (15) days from the first completion date and within a period of thirty (30) days for dissertations and research papers.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endeavor to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages