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).
Click here to open the Excel spreadsheet containing the data for this assignment.
This spreadsheet contains the data from a study that attempted to see if there is a correlation between the hours that a student studies 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:
To see an example spreadsheet containing a completed analysis click here.
Now that you’ve completed your analysis and determined the linear regression formula and r^{2}, it now time to report on the results of your study and examine your findings.
In a Microsoft Word document, respond to the following:
For this assignment, you will submit a spreadsheet and a report. The spreadsheet will be the Microsoft Excel file containing your scatterplot and analysis. Name your Microsoft Excel file as follows: LastnameFirstInitial_M3_A2.xls.
The report will be a Microsoft Word document in which you will address all of the questions in this assignment in the form of a narrative. Name your Microsoft Word document as follows: LastnameFirstInitial_M3_A2.docx.
Submit both files to the M3: Assignment 2 Dropbox by Tuesday, April 30, 2013.
Assignment 2 Grading Criteria 
Maximum Points

Complete scatterplot and attach as an Excel file (the fraction of variation in one variable should be accounted for by variation of the other). 
56

Report the r^{2} correlation coefficient and linear regression equation with slope and intercept included and stated whether the value of r is positive or negative. 
96

Explain the implication of any linear relation, including its three components (scatterplot, r^{2} value and linear equation) found between hours spent studying, and the exam score earned. 
48

Total: 
200

Subject  Mathematics 
Due By (Pacific Time)  05/06/2013 02:04 pm 
Tutor  Rating 

pallavi Chat Now! 
out of 1971 reviews More.. 
amosmm Chat Now! 
out of 766 reviews More.. 
PhyzKyd Chat Now! 
out of 1164 reviews More.. 
rajdeep77 Chat Now! 
out of 721 reviews More.. 
sctys Chat Now! 
out of 1600 reviews More.. 
sharadgreen Chat Now! 
out of 770 reviews More.. 
topnotcher Chat Now! 
out of 766 reviews More.. 
XXXIAO Chat Now! 
out of 680 reviews More.. 