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 1A

12

Medical 2

Florida New York North Carolina        3 9 11 7 12 8 7 10 4 3 8 6 8 9 12 8 8 9 8 9 5 5 5 4 5 14 8 2 11 9 6 7 9 2 9 8 6 13 4 6 9 10 9 7 9 7 9 13 5 6 7 4 8 4 7 8 9 3 9

12

Explanation / Answer

(1) On both data sets descriptive statistics are

   Medical 1

     

Medical 2

The preliminary observations about the depression levels are

Anova: Single Factor Data from Medical 1

           

Anova: Single Factor Data from Medical 2

       

(2):

On both data sets apply Anova: Single Factor

Medical 1:

Medical 2:

Hypothesis tested H 0 :µ 1 = µ 2 = µ 3

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

H a : µ 1 µ 2 µ 3

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

Florida Newyork North Carolina Mean 5.55 Mean 9 Mean 8.05 Standard Error 0.478346934 Standard Error 0.492041932 Standard Error 0.634428877 Median 6 Median 9 Median 8.5 Mode 7 Mode 9 Mode 9 Standard Deviation 2.139232523 Standard Deviation 2.200478417 Standard Deviation 2.837252192 Sample Variance 4.576315789 Sample Variance 4.842105263 Sample Variance 8.05 Kurtosis -1.062192818 Kurtosis 0.626431669 Kurtosis -0.904925496 Skewness -0.27355709 Skewness 0.625687389 Skewness -0.056188269 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.001191637 Confidence Level(95.0%) 1.029855598 Confidence Level(95.0%) 1.327874898

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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