Question
Letecia has been noticing some inequity within Avocado Park and wants to study educational outcomes from the five elementary schools in the neighborhood. She collects
Letecia has been noticing some inequity within Avocado Park and wants to study educational outcomes from the five elementary schools in the neighborhood. She collects a sample of 20 random Avocado Park High School graduates from the last 10 years that had attended EACH of the five elementary schools. She records their cumulative GPA with the results shown in the file APGPA.xlsx a. What would be a suitable test for determining if there are any discrepancies in the educational outcomes produced by the five elementary schools? b. Are the conditions for this test met? What assumptions are necessary to proceed? c. Letecia wants to make sure she doesn't miss any small gaps. Would a significance level of 0.01 or 0.10 suit her purposes better? d. Using the significance level you chose, test her claim.
DATA:
Green Feather | Avocado Creek | Morning Ridge | Coyote Run | Blue Crest |
4.6 | 4.316 | 2.937 | 1.582 | 3.66 |
3.736 | 3.727 | 2.565 | 2.645 | 3.581 |
4.783 | 3.014 | 3.137 | 2.505 | 4.72 |
3.215 | 3.846 | 2.254 | 2.103 | 4.586 |
3.462 | 3.026 | 3.419 | 3.514 | 3.677 |
2.79 | 2.429 | 3.848 | 1.691 | 4.871 |
3.266 | 3.496 | 2.532 | 2.872 | 3.429 |
2.86 | 3.138 | 2.056 | 2.2 | 3.626 |
3.88 | 4.113 | 2.569 | 1.642 | 4.829 |
3.415 | 3.026 | 3.256 | 2.405 | 4.806 |
2.537 | 4.092 | 3.993 | 2.224 | 4.276 |
3.55 | 4.425 | 3.559 | 2.155 | 3.384 |
2.533 | 3.939 | 3.281 | 2.68 | 3.113 |
3.199 | 2.661 | 3.369 | 2.076 | 2.367 |
3.254 | 3.315 | 2.659 | 1.395 | 4.07 |
3.913 | 3.328 | 3.046 | 2.152 | 4.455 |
3.305 | 4.687 | 3.478 | 2.95 | 3.427 |
4.926 | 3.921 | 1.849 | 2.554 | 3.939 |
2.828 | 2.37 | 2.545 | 1.833 | 3.743 |
4.507 | 2.449 | 2.268 | 1.99 | 3.5 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started