Your Question:A psychologist believed that as children get older, they engage in more “inactive activities” such as playing computer games, watching TV and surfing the internet. She collected data from 10 children. She recorded the age of each child and the amount of activity (in hours) the child engaged in per week. The data is below:AgeActivity74.393.2101131.5121.2150.893124151.5141.9Using excel, obtain a scatterplot of the data. Discuss the relationship between age and activity based on the scatterplot. Using excel, obtain the simple linear regression linear regression line predicting activity from age. Interpret the intercept and slope of the regression line. By hand, predict the amount of activity for age = 14. By hand, calculate the residual for age = 14.Using excel, test the null hypothesis that the slope coefficient is zero using the p-value approach. Write one sentence interpreting the meaning of this result. Make sure to report the test statistic and p-value.Using excel, obtain and report the 95% CI for the slope coefficient. Explain how we can use it to make a decision about the null hypothesis from part (2). Using excel, test the null hypothesis that the population coefficient of determination is zero using the p-value approach, and write one sentence interpreting your result. Make sure to report the test statistic and p-value. How do the test statistics in (2) and (3) mathematically relate to each other?

Here dependent variable (y) is the amount of activity the child engaged in per week.The independent…

Answered: Using excel, obtain a scatterplot of…

Calculus For The Life Sciences

2nd Edition

ISBN:9780321964038

Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.

Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.

Chapter7: Integration

Section7.CR: Chapter 7 Review

Problem 88CR

See similar textbooks

Related questions

Question

Your Question:

A psychologist believed that as children get older, they engage in more “inactive activities” such as playing computer games, watching TV and surfing the internet. She collected data from 10 children. She recorded the age of each child and the amount of activity (in hours) the child engaged in per week. The data is below:

Age	Activity
7	4.3
9	3.2
10	1
13	1.5
12	1.2
15	0.8
9	3
12	4
15	1.5
14	1.9

1. Using excel, obtain a scatterplot of the data. Discuss the relationship between age and activity based on the scatterplot. Using excel, obtain the simple linear regression linear regression line predicting activity from age. Interpret the intercept and slope of the regression line. By hand, predict the amount of activity for age = 14. By hand, calculate the residual for age = 14.
2. Using excel, test the null hypothesis that the slope coefficient is zero using the p-value approach. Write one sentence interpreting the meaning of this result. Make sure to report the test statistic and p-value.
3. Using excel, obtain and report the 95% CI for the slope coefficient. Explain how we can use it to make a decision about the null hypothesis from part (2). Using excel, test the null hypothesis that the population coefficient of determination is zero using the p-value approach, and write one sentence interpreting your result. Make sure to report the test statistic and p-value. How do the test statistics in (2) and (3) mathematically relate to each other?

Expert Solution