Testing for correlation by linear regression

The goal of many studies is to determine if there is a relationship between factors. In other words, does one factor influence the outcome of another factor? If there is a relationship between the factors, then there is a correlation. Through this module’s lectures and readings, you will know that finding a correlation does not necessarily mean that you have found a causal relationship. This would need to be determined by another layer of investigation. Indeed, many times correlation does not always lead to the determination of causation, but it can help to identify if there is not a causal relationship between the variables in the study.

One way to determine correlation is to see if there is a linear relationship between the factors. A linear relationship can be tested by graphing a scatter plot of the data in the study and seeing if a best-fit line can be drawn to represent this data. This method of analysis is called linear regression. The formulas for linear regression are cumbersome, but luckily, most spreadsheets have built-in functions for performing these tedious calculations.

In this assignment, you will use a spreadsheet to examine pairs of variables, using the method of linear regressions, to determine if there is any correlation between the variables. Afterwards, postulate whether this correlation reveals a causal relationship—why or why not?

Directions:

Click here to open the Excel spreadsheet containing the data for this assignment.

Notice that there are several tabs on the spreadsheet, each containing a different set of data from different studies. On each of these sample tabs, you will also find the question that was explored in that study. Select the data set that you find interesting, and perform the analysis below. You are only required to perform this analysis on one set of data. There is a tab labeled Example where you can see how your analysis should look when done.

In the Excel spreadsheet, perform the following operations:

  1. Save the spreadsheet on your computer.
  2. Select the study data you want to use. With your mouse, highlight all of the data on the spreadsheet in columns A and B.
  3. In the tabs at the top of the page, click Insert.
  4. 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 will see a chart on the page.
  5. Now, on the chart, right-click on one of the data points (dots). Just pick a dot somewhere near the middle of the distribution.
  6. Select Add Trendline from the drop-down menu that appears when you right-click on a dot.
  7. A new menu will appear. Select Linear, select Automatic, and click the box next to Display R-squared value on chart.
  8. Click Close.
  9. Now, you should see a line drawn through the dots. It will roughly cut through the middle of the dot distribution.
  10. You will also see the R2 value displayed next to the line.

In a Word document, respond to the following:

  1. What was the sample you selected and the question that was explored in the study?
  2. What was the R2 linear correlation coefficient and the linear regression equation produced in the Excel spreadsheet?
  3. What would be the value of Pearson’s R?
  4. Would Pearson’s R be positive or negative? What does this imply about the relationship between the factors in this study?
  5. What is the implication of any correlation found between the variables in the study you picked?
  6. Does this correlation imply a causal relationship? Explain.
  7. Were there other variables that you think should have been examined? How would have those variables improved the correlation results of this study or helped to pinpoint where the factors were causal?

For this assignment, submit a summary of your responses to the questions above in a 1–2-page Word document. Apply APA standards to citation of sources

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

101papers.com is always working towards customer satisfaction. Our professional academic writers always aim at producing comprehensive papers that possess quality and originality at pocket-friendly prices. Students are assured that all their private information is safe with us.

Money-Back Guarantee

101papers.com provides a system where students can request for money-back in case they cancel the order or in the rare instances of dissatisfaction. The refund policy adheres to the company’s term and conditions on money-back.

Read more

Zero-Plagiarism Guarantee

While providing the best professional essay writing services, we guarantee all our students of plagiarism-free papers. All papers produced by our professional academic writers are checked against all web resources and previously completed papers to avoid plagiarism.

Read more

Free Revision Policy

In our urge to provide the best professional essay writing services, we guarantee students of free revision policy. The free revision policy is a courtesy service where students can request for unlimited for their completed papers. We always aim at achieving 100% customer satisfaction rates. The free revision policy is one among many of our major advantages.

Read more

Privacy Policy

At 101papers.com, every student is entitled to total security. Our professional academic writers are always committed to protecting all private information of our customers. We do not share any personal information with third parties. Additionally, we provide safe systems for all online transactions.

Read more

Fair-Cooperation Guarantee

Working with us is the greatest step towards achieving all your academic goals. We always deliver the best professional essay writing services as promised. We, therefore, expect all students to work cooperatively with us, as we work towards achieving our goal, your satisfaction. This way, all services will be delivered accurately and on time.

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:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency