Perform the following activities using a program such as MS Excel. Keep all calc

Question

Perform the following activities using a program such as MS Excel. Keep all calculations within one file. You may use separate worksheets within the same file, though.

Open a worksheet and enter in the following data:

Using this data, report the descriptive statistics for each variable. Report the mean and the standard deviation for each variable.

Determine if there is a relationship between the two variables. Be sure to determine if the relationship is significant.

Using this same data, report the regression equation that could be used to make predictions about the amount of money spent on books when the number of years of education is known.

You are a researcher who is interested in studying the effects of Prozac on children. You equally divide 40 young rats into two groups: one that receives no Prozac and one group that receives one dose of Prozac. You want to determine if there is a significant effect of Prozac on learning and memory. You collect the number of errors on a task for each subject, which is listed below. Higher numbers of errors indicate lower levels of learning and memory. You analyze the data using a software program to determine if groups are significantly different from one another.

Years of
Education Expenditures
on Books 13 5 17 45 9 0 11 18 15 25 12 4 13 10 18 35 16 15 10 0

Explanation / Answer

Variable Mean StDev
Years of Education 13.400 3.026
Expenditure on Books 15.70 15.28
Control Group 3.650 1.694
Prozac Group 10.550 2.328

The regression equation is
Expenditure on Books = - 40.76 + 4.214 Years of Education

Two-sample T for Control Group vs Prozac Group

N Mean StDev SE Mean
Control Group 20 3.65 1.69 0.38
Prozac Group 20 10.55 2.33 0.52

Difference = (Control Group) - (Prozac Group)
Estimate for difference: -6.900
95% CI for difference: (-8.208, -5.592)
T-Test of difference = 0 (vs ): T-Value = -10.72 P-Value = 0.000 DF = 34

So, at 5% level of significance, two groups differ from one another.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.