STUDYSHIELDS ASSIGNMENT HELP

  • Home
  • Blog
  • Courses
    • Child Category 1
    • Child Category 2
    • Child Category 3
    • Child Category 4
  • Services
  • Country
    • Childcare
    • Doctors
  • Home
  • Blog
  • Sample Works
  • Order Now

Wednesday, March 30, 2016

Linear Regression

 March 30, 2016     No comments   

 
 Linear Regression


In this assignment, you will use a spreadsheet to examine pairs of variables, using the method of linear regression, to determine if there is any correlation between the variables. Afterwards, you will postulate whether this correlation reveals a causal relationship (and why).

This spreadsheet (in attachment) contains the data from a study that attempted to see if there is a correlation between the hours that students studied and the grade that they earned on a test. The correlation test you are about to run will help you to determine if there is, in fact, a correlation between study time and test score. If you find a strong correlation, then you will postulate whether you feel this indicates a causal relationship.

Below are instructions on how to perform this correlation test in Microsoft Excel.

In the Excel spreadsheet, perform the following operations:

Save the spreadsheet to your computer.
With your mouse, highlight all of the data on the spreadsheet in columns A and B.
In the tabs at the top of the page, click Insert.
In the Insert ribbon, in the Charts section, click Scatter. Be sure to select the option where it will just plot dots, it will be called Scatter with only Markers. If you do this right, then you'll see a chart on the page.
Now, on the chart, right-click on one of the data points (dots). Just pick a dot somewhere near the middle of the distribution.
Select Add Trendline from the drop-down menu that appears when you right-click on a dot.
A new menu will appear. Select Linear, select Automatic, and click the boxes next to Display Equation on chart and Display r-squared value on chart.
Click Close.
Now, you should see a line drawn through the dots. It will roughly cut through the middle of the dot distribution.
You'll also see the linear regression equation and r2 value displayed next to the line.
(Example of A Spreadesheet with Completed Analysis is also attached)

Now that you’ve completed your analysis and determined the linear regression formula and r2, it is now time to report on the results of your study and examine your findings.

In a Microsoft Word document, respond to the following:

Report the sample you selected and the question that was explored in the study.
Report the r2 linear correlation coefficient and the linear regression equation produced in the Excel spreadsheet.
What would be the value of Pearson’s r (simply the square root of r2)?
Would Pearson’s r be positive or negative? What does this imply about the relationship between the factors in this study?
What is the implication of any correlation found between the variables in the study you picked?
Does this correlation imply a causal relationship? Explain.
Are there other variables that you think should have been examined that would have improved this study or helped to pinpoint what factors are causal?
For this assignment, you will submit a spreadsheet and a report. The spreadsheet will be the Microsoft Excel file containing your scatterplot and analysis

  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook

Related Posts:

  • An Overlooked Essential Nutrient The title of your presentation is Water: An Overlooked Essential  Nutrient. A law firm has requested that you introduce yourself, explain w… Read More
  • Describe how healthcare insurance has factored In a 3-5 page academic paper, describe how healthcare insurance has factored or will factor into your future job search. Select a minimum of thr… Read More
  • Neuroscience meme Option B: Neuroscience memeMeme is an idea, an item of cultural knowledge, an interesting/amusing thing that spreads in a culture and is often e… Read More
  • Turn in one page from the orchestral score of a famous composer. Turn in one page from the orchestral score of a famous composer. Write a few sentences about the different elements regarding time: rhythmic pat… Read More
  • Describe Digital Literacy  Answer each these questions in a paragraph with at least 3-4 sentences: Include the question and number your responses accordingly. Provide a ci… Read More
Newer Post Older Post Home

0 comments:

Post a Comment

Click Here to Place order

Popular Posts

  • A “criminal minds” Aileen Wournos individual will be your “patient”
     A “criminal minds” Aileen Wournos individual will be your “patient”  A brief history of the patient including diagnoses (documented or your...
  • CEO Jane Lionel has some hard decisions to make with regard to some of the company’
     CEO Jane Lionel has some hard decisions to make with regard to some of the company’solder hands, and even on the eve of that decision, I be...
  • Problem in Supply Chain
    Problem in Supply Chain Problem 2. (Chapter 11: The Storage and Handling System) Compare the constrast private ownership of storage space to...

Recent Posts

Unordered List

Pages

  • Home

Text Widget

Blog Archive

  • November 2022 (20)
  • October 2022 (50)
  • September 2022 (119)
  • August 2022 (107)
  • February 2022 (501)
  • January 2022 (443)
  • December 2021 (488)
  • November 2021 (1574)
  • October 2021 (28)
  • September 2021 (11)
  • July 2021 (8)
  • June 2021 (15)
  • May 2021 (39)
  • April 2021 (15)
  • March 2021 (303)
  • February 2021 (712)
  • January 2021 (903)
  • December 2020 (2)
  • September 2020 (33)
  • April 2016 (5183)
  • March 2016 (3763)
  • February 2016 (4356)
  • January 2016 (1749)
  • December 2015 (22)
  • November 2015 (147)
  • October 2015 (23)

Sample Text

Copyright © 2025 STUDYSHIELDS ASSIGNMENT HELP | Powered by Blogger
Design by Hardeep Asrani | Blogger Theme by NewBloggerThemes.com | Distributed By Gooyaabi Templates