Description:
Assignment 2: 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). 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 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:
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 is 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 22, 2014.

Share Question on Social Media
Submitted by PROFSTAN on April 26th, 2016 10:01
Price $25.00
Rated 11 times.
Answer bought 0 times.
Tutor Rank
Original, compitent and reliable
Contact for Quality Work
I am a highly decorated tutor who settles for nothing but the best .
PROFESSIONAL ACCOUNTING TUTOR&PRACTITIONER
Best dev Alive...