Problem

An elementary school teacher believes that the amount of time parents spend reading to or with their children is an accurate predictor of overall school performance.To test this hypothesis, the teacher conducted a study using the 25 students in his class.At the end of the school year, each child's letter grades for the entire year were used to calculate an overall grade-point average.During the parent teacher conference for each student, parents were given a questionnaire on which they were asked to indicate the average amount of time per week (in hours) that they spend reading to with their children.

Using SPSS:

1.Is parent reading time correlated with the GPA? Please interpret

2.Show and interpret the scatterplot.

3.What is the linear relationship?

4.Does it appear that the amount of time a parent spends reading to their child is an accurate predictor of overall school performance at the alpha = 0.05 level?

Using Excel:

1.Is parent reading time-correlated with the GPA? Please interpret

2.Show and interpret the scatterplot.

3.What is the linear relationship?

4.Does it appear that the amount of time a parent spends reading to their child is an accurate predictor of overall school performance at the alpha = 0.05 level?

5. How much variance is explained?

Data is attached below

Word File Edit View Insert Format Tools Table Window Help Q 8 Sat Jun 12 5:33 PM AutoSave O OFF A BY. C60 ... ClowColleenExtraCredit5 Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments Comments Calibri (Bo... * 11 A A" Aa AD T AaBbCcDdEe AaBbCcDdEe AaBbCCDc AaBbCcDdEE Paste BIUvabX x ADVA Normal No Spacing Heading 1 Heading 2 Styles Dictate Sensitivity Sensitivity pane Child Reading Time (X) GPA (Y) 1 2.12 5 3.00 3 15 4.00 4 1 2.00 5 3 2.56 6 1.73 7 7 3.91 8 12 3.7 9 2 2.12 10 6 3.55 11 10 3.85 12 3.12 13 3.68 14 O V N UT OO 2.22 15 3.50 16 1.68 17 14 4.00 18 7 3.86 19 19 4.00 20 1.84 21 15 3.50 22 7 3.70 23 4 3.33 24 10 3.88 25 3 2.98 Page 2 of 4 313 words English (United States) Focus E + 147% + 113% JUN 12 O W X