Fix it math
M3A2 Name: ___Amanda Wilson ____________________
|
Module 3 Assignment 2 Grading Criteria |
Possible Points |
Points Earned |
|
Identified the selected sample and question that was explored in the study. |
12 |
12 |
|
Identified the R2 linear correlation coefficient and the linear regression equation produced in the Excel spreadsheet. |
12 |
Chart Not Present Please make a scatter plot chart in the Excel Spreadsheet provided |
|
Determined the value of Pearson’s R. |
12 |
12 |
|
Determined if Pearson’s R is positive or negative , and what it implied about the relationship between the factors in the study. |
12 |
10 (Use according to the formula, but what about the scatterplot? 10
|
|
Determined the implication of a correlation between the variables in the study. Explained whether the correlation was an implied causal relationship. |
12 |
6 Is this relationship as clear as 86%, try the scatter plot view, and reduce your legends to reasonable weights |
|
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 |
0 Missing |
|
Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources; displayed accurate spelling, gramma r, and punctuation. |
20 |
10 Evaluated two/three studies, needs to be revisited for one. |
|
Total: |
100 |
50 *try again please* with 1 study |
In Excel (spreadsheet provided) A linear relationship can be tested by graphing a scatter plot of the data. Notice (ONE STUDY ONLY!) 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. Assignment Summary: 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? So try using a ScatterPlot, then do a simple Pearson’s in Excel, do this by clicking Formulas Statistical Pearson
In array one: Highlight A column, with out title In array two: Highlight B Column, without title