1. Describe the meaning of the six correlations provided.2. Select two data sets from your school or...

Question

1. Describe the meaning of the six correlations provided.

2. Select two data sets from your school or classroom and find the Pearson Product correlation coefficient. Make a scatter diagram and explain your results in light of direction and strength as well as overall meaning. (Directions for finding Pearson in Excel: Grab two data sets [click and drag]. These must be matched sets. Select Insert function>Statistical>Pearson)

Sheet1 r =r = Student NamesMath Final Grade Last YearDSTP Math Scale Score Last YearYears in New District Math CurriculumAverage Hours per Night: StudyingAverage Hours per Night: TV, Phone, Video GamesHighest Grade in School Completed by Parent0.90-0.88 Amanda8751013216 Andrew7949941.5210 Ashley6846020411 Brandon9854513220 Brittany8652033313 Carlos96520850.512r =r = Daniel80480413.5120.53-0.48 Elizabeth9648164112 Emily9450624.50.518 Jacob6447140512 Jessica7748060.53.512 Juan6646420.5411 Li8949764214 Megan9548434.50.516 Michael7753141414 Nicholas8749722412 Samantha7349112410 Sandra7049300.5512 Taisha8346942212r =r = Tyler8045261.52.5140.25-0.21 Assignment below… 1. Describe the meaning of the six correlations provided. 2. Select two data sets from your school or classroom and find the Pearson Product correlation coefficient. Make a scatter diagram and explain your results in light of direction and strength as well as overall meaning. (Directions for finding Pearson in Excel: Grab two data sets [click and drag]. These must be matched sets. Select Insert function>Statistical>Pearson) Math Grade : Average Hours Studying 31.50335144.500.50.544.51220.521.58779689886968096946477668995778773708380Average Hours per Night Studying Math Grade Last Year Math Grade : DSTP Scale Score 5104994605455205204804815064714804644974845314974914934694528779689886968096946477668995778773708380DSTP Scale Scores Last Year Math Grade Last Year Math Grade : Years in New Curriculum 142138462462634210468779689886968096946477668995778773708380Years in New District Curriculum Math Grade Last Year Hours Studying : TV, Phone & Video Games 224230.53.510.553.5420.5444522.531.50335144.500.50.544.51220.521.5Hours per Night: TV, Phone, Video Games Avg. Hours Studying Highest Parent Grade : TV, Phone & Video 224230.53.510.553.5420.5444522.51610112013121212181212111416141210121214Hours per Night: TV, Phone, Video Games Highest Parent Grade Highest Parent Grade : Years in Curriculum 142138462462634210461610112013121212181212111416141210121214Years in New District Curriculum Highest Parent Grade Sheet2 Sheet3 Sheet4

social-studies-post-writing-scores-o1nru2is.xlsx week-four-data-set-1-45dznjqp.xlsx

Rajeswari · Accepted Answer

Sheet1
	Social studies	Science
	100	95
	100	88
	50	45
	100	91
	100	92
	66	57
	32	28
	100	89
	75	70
	100	95
	100	95
	100	91
	55	59
	100	99
	76	72
	91	92
	100	98
	64	60
	83	81
	72	70
	92	88
	66	65
	100	95
	100	96
	50	48
	92	90
	92	90
	83	85
	100	95
	83	83
	100	98
	83	85							Scatter plot
	84	81
	100	98								Social vs science scores
	96	94
	92	91													Pearson correlation		0.94
	100	98
	100	99													Positive correlation		0.9443363713
	83	91
	93	100
	92	100
	72	85
	75	89
	100	100
	83	89													slope	0.9307104295
	75	78													intercept	5.0923593918
										y=0.93x+5.09
Science	100	100	50	100	100	66	32	100	75	100	100	100	55	100	76	91	100	64	83	72	92	66	100	100	50	92	92	83	100	83	100	83	84	100	96	92	100	100	83	93	92	72	75	100	83	75	95	88	45	91	92	57	28	89	70	95	95	91	59	99	72	92	98	60	81	70	88	65	95	96	48	90	90	85	95	83	98	85	81	98	94	91	98	99	91	100	100	85	89	100	89	78

Sheet1 r = r = Student NamesMath Final Grade Last YearDSTP Math Scale Score Last YearYears in New District Math CurriculumAverage Hours per Night: StudyingAverage Hours per Night: XXXXXXXXXXTV,...

Answer To: Sheet1 r = r = Student NamesMath Final Grade Last YearDSTP Math Scale Score Last YearYears in New...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment