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 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 . Now that you’ve completed your analysis and determined the linear regression formula and r , 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 Purchase the answer to view it
