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:

  • Your Discussion Board has raised interest concerning the Federal Emergency Management Agency (FEMA) with your new boss. Your Discussion Board has raised interest concerning the Federal Emergency Management Agency (FEMA) with your new boss.Your Discussion Board has… Read More
  • SUBDOMAIN 309.3 - QUANTITATIVE ANALYSISSUBDOMAIN 309.3 - QUANTITATIVE ANALYSISCompetency309.3.1: Decision-Making Models - The graduate uses optimizing models and other models as aids for ma… Read More
  • Criminal Justice: You have just graduated from the AIU Online Criminal Justice programCriminal Justice: You have just graduated from the AIU Online Criminal Justice programYou have just graduated from the AIU Online Criminal Justice pro… Read More
  • Identify and analyze what you believe to be the most significant new technology requirementsIdentify and analyze what you believe to be the most significant new technology requirementsWrite a four to five (4-5) page paper in which you:Identif… Read More
  • Disks and Printers: Identify the specific manufacture and model of one (1) magnetic diskDisks and Printers: Identify the specific manufacture and model of one (1) magnetic diskIdentify the specific manufacture and model of one (1) magneti… 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