math

Thebrainywriters.com stands as the unrivaled pinnacle of homework help services. With a team of expert writers, comprehensive subject coverage, a commitment to academic integrity, punctual delivery, 24/7 support, confidentiality, affordability, and a track record of triumphant testimonials, it has established itself as the go-to platform for students seeking excellence in their academic endeavors. As the educational landscape continues to evolve, Thebrainywriters.com remains an indispensable ally for students worldwide, guiding them towards academic success and a brighter future.

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 Trendlinefrom 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 R2linear 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. Name your Word document as follows: LastnameFirstInitial_M3_A2.doc. Submit it to the M3: Assignment 2 Dropbox by Wednesday, March 11, 2015.

Grading Criteria and Rubric

Assignment 2 Grading Criteria
Maximum Points
Identified the selected sample and question that was explored in the study.
12
Identified the R2 linear correlation coefficient and the linear regression equation produced in the Excel spreadsheet.
12
Determined the value of Pearson’s R.
12
Determined if Pearson’s R is positive or negative, and what it implied about the relationship between the factors in the study.
12
Determined the implication of a correlation between the variables in the study. Explained whether the correlation was an implied causal relationship.
12
Determined if other variables should have been examined. Explained how those variables would have improved the correlation results of the study or helped to pinpoint where the factors were causal.
20
Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources; displayed accurate spelling, grammar, and punctuation.
20
Total:
100

 

Academic integrity is non-negotiable, and Thebrainywriters.com takes this principle to heart. Recognizing the significance of originality, the website guarantees that every assignment and paper is crafted from scratch. A strict anti-plagiarism policy and state-of-the-art plagiarism detection tools ensure that students receive unique and authentic content, giving them the confidence to submit their work without any concern. Time is of the essence in the academic realm, and Thebrainywriters.com understands the importance of meeting deadlines. Their unwavering commitment to punctuality ensures that students receive their completed assignments well before the submission date. This punctuality not only alleviates the stress of last-minute rushes but also allows students ample time for review and revision, promoting a deeper understanding of the subject matter. Recognizing that academic emergencies can arise at any hour, Thebrainywriters.com offers round-the-clock customer support. Students can rest assured that their queries and concerns will receive swift and attentive responses, regardless of the time zone they reside in. This dedication to customer care builds trust and fosters a supportive relationship between the website and its users.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.