Fix it math

profileuven12
AmandaWilsonModule3Assignment2GradingCriteria.docx

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