Details of this Paper

MAT Assignment 2: Linear Regression




Question;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, clickInsert.;In;the Insert ribbon, in the Charts section, clickScatter. Be sure to;select the option where it will just plot dots, it will be calledScatter;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. SelectLinear, selectAutomatic, and;click the boxes next toDisplay Equation on chart andDisplay;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


Paper#61983 | Written in 18-Jul-2015

Price : $27