As part of a long-term study of individuals 65 years of age or older, sociologis

Question

As part of a long-term study of individuals 65 years of age or older, sociologists and physicians at the Weinstein Medical Center in upstate New York investigated the relationship between geographic location, health status (healthy or one or more comorbidities), and depression. Random samples of 20 healthy individuals were selected from each of three geographic locations: Florida, New York, and North Carolina. Then, every individual was given a standardized test to measure depression (higher test scores indicate higher levels of depression); see file Medical1. Similarly, random samples of 20 individuals with one or more comorbidities (arthritis, hypertension, and /or heart ailment) were taken from the three geographic locations, and they were given the same standardized test to measure depression; see file Medical2.

1. On both data sets compute descriptive statistics using “Descriptive Statistics” in Data Analysis of Excel; see instructions on pages 377 - 378. Assume the 95% confidence level to get the 95% confidence intervals for the six population means. Analyze the most important descriptive statistics. What are your preliminary observations about the depression levels?

2. On both data sets apply Anova: Single Factor in Data Analysis of Excel at a 5% significance level; see instructions on page 594. When you state your hypotheses, define clearly the population means under study in each case. Note: An example of the use “Anova: Single Factor” is shown in: www.excel-easy.com/examples/anova.html

3. If the null hypothesis in the Anova test is rejected, then apply by hand Fisher’s LSD procedure on page 565 in order to identify which population means are different; assume alpha = 0.05, and use MSE found by Anova: Single Factor.

4. Use Microsoft Word to write a managerial report in which you include your answers to all questions, and summarize your findings. Your report should also show all relevant Excel outputs (paste them); do not use Excel outputs as attachments.

Medical 1B Medical 2B Florida New York North Carolina Florida New York North Carolina 3 9 11 15 16 12 7 12 8 14 11 14 7 10 4 19 17 17 3 8 6 19 14 20 8 9 12 22 18 14 8 8 9 23 26 16 8 9 5 18 20 19 5 5 4 16 16 10 5 14 8 15 17 16 2 11 9 19 19 18 6 7 9 14 22 20 2 9 8 11 13 19 6 13 4 14 25 21 6 9 10 17 21 17 9 7 9 18 19 15 7 9 13 17 16 16 5 6 7 15 11 13 4 8 4 12 16 14 7 8 9 13 15 15 3 9 12 19 13 13

Explanation / Answer

1.

2.

Hypothesis tested H0:

u1=u2=u3

There is no significant difference in the mean depression score of healthy people in the three location

under alternative H1

There is significant difference in the mean depression score of healthy people in the three location where:

u1= the mean depression score of healthy people in Florid

u2= the mean depression score of healthy people in New York

u3= the mean depression score of healthy people in North Carolina

Rejection Rule:

Reject the null hypothesis, if the calculated value of F statistic is greater than the F-tabulated

The null hypothesis is rejected, because the sample provides enough evidence to sup score of healthy people in the three locations

The null hypothesis cannot be rejected, because the sample does not provide enough mean depression score of healthy people in the three locations

3.

Medical 1B Column1 Florida Column2 New York Column3 North Carolina Mean 5.55 Mean 9 Mean 8.05 Standard Error 0.478347 Standard Error 0.492042 Standard Error 0.634429 Median 6 Median 9 Median 8.5 Mode 7 Mode 9 Mode 9 Standard Deviation 2.139233 Standard Deviation 2.200478 Standard Deviation 2.837252 Sample Variance 4.576316 Sample Variance 4.842105 Sample Variance 8.05 Kurtosis -1.06219 Kurtosis 0.626432 Kurtosis -0.90493 Skewness -0.27356 Skewness 0.625687 Skewness -0.05619 Range 7 Range 9 Range 9 Minimum 2 Minimum 5 Minimum 4 Maximum 9 Maximum 14 Maximum 13 Sum 111 Sum 180 Sum 161 Count 20 Count 20 Count 20 Confidence Level(95.0%) 1.001192 Confidence Level(95.0%) 1.029856 Confidence Level(95.0%) 1.327875

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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