Homework SourseAge analysis Is there a statistically significant difference
Age analysis: Is there a statistically significant difference between age and the dependent variables? Sort each of the dependent data columns into the following age groups: 29, 30-39, 40-49, 50-59, and 60-69. Use Excel’s Anova-Single Factor to determine if there is a statistically significant difference across ages. Use the example below (for engagement) to set up your data for analysis. Discuss your results
| Engagement Dependent Variable | Commitment Dependent Variable | Dependent | |||||||
| E1 | E2 | E3 | E4 | C1 | C2 | C3 | C4 | Overall | Age |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 6 | 30 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 4 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 40 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 9 | 41 |
| 5 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 8 | 45 |
| 4 | 2 | 2 | 3 | 2 | 1 | 2 | 2 | 4 | 36 |
| 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 7 | 34 |
| 3 | 3 | 2 | 2 | 4 | 2 | 2 | 3 | 6 | 24 |
| 3 | 3 | 2 | 3 | 3 | 2 | 3 | 4 | 6 | 27 |
| 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 8 | 55 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 4 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 43 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 8 | 41 |
| 5 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 8 | 45 |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 6 | 30 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 4 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 7 | 37 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 9 | 41 |
| 5 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 8 | 61 |
| 4 | 2 | 2 | 3 | 2 | 1 | 2 | 2 | 4 | 36 |
| 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 7 | 34 |
| 3 | 3 | 2 | 2 | 4 | 2 | 2 | 3 | 8 | 25 |
| 3 | 3 | 2 | 3 | 3 | 2 | 3 | 4 | 6 | 32 |
| 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 8 | 55 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 4 | 29 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 44 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 7 | 41 |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 6 | 31 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 5 | 32 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 7 | 38 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 8 | 43 |
| 5 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 7 | 57 |
| 4 | 2 | 2 | 3 | 2 | 1 | 2 | 2 | 5 | 41 |
| 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 7 | 37 |
| 3 | 3 | 2 | 2 | 4 | 2 | 2 | 3 | 6 | 23 |
| 3 | 3 | 2 | 3 | 3 | 2 | 3 | 4 | 6 | 26 |
| 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 8 | 58 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 43 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 7 | 49 |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 6 | 29 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 30 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 7 | 40 |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 5 | 32 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 5 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 7 | 44 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 8 | 51 |
| 5 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 6 | 45 |
| 4 | 2 | 2 | 3 | 2 | 1 | 2 | 2 | 5 | 36 |
| 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 6 | 34 |
| 3 | 3 | 2 | 2 | 4 | 2 | 2 | 3 | 7 | 27 |
| 3 | 3 | 2 | 3 | 3 | 2 | 3 | 4 | 8 | 24 |
| 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 7 | 55 |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 5 | 31 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 43 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 7 | 41 |
| 5 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 8 | 45 |
| 4 | 2 | 2 | 3 | 2 | 1 | 2 | 2 | 3 | 41 |
| 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 7 | 34 |
| 3 | 3 | 2 | 2 | 4 | 2 | 2 | 3 | 8 | 23 |
| 3 | 3 | 2 | 3 | 3 | 2 | 3 | 4 | 6 | 31 |
| 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 8 | 54 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 42 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 7 | 49 |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 6 | 33 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 4 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 40 |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 6 | 31 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 5 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 46 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 8 | 33 |
| 5 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 7 | 45 |
| 4 | 2 | 2 | 3 | 2 | 1 | 2 | 2 | 5 | 31 |
| 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 6 | 44 |
| 3 | 3 | 2 | 2 | 4 | 2 | 2 | 3 | 7 | 25 |
| 3 | 3 | 2 | 3 | 3 | 2 | 3 | 4 | 6 | 27 |
| 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 8 | 60 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 5 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 48 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 9 | 51 |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 6 | 39 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 5 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 7 | 39 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 8 | 59 |
| 5 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 8 | 45 |
| 4 | 2 | 2 | 3 | 2 | 1 | 2 | 2 | 5 | 37 |
| 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 7 | 44 |
| 3 | 3 | 2 | 2 | 4 | 2 | 2 | 3 | 6 | 28 |
| 3 | 3 | 2 | 3 | 3 | 2 | 3 | 4 | 6 | 26 |
| 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 8 | 59 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 7 | 40 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 8 | 41 |
| 4 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 6 | 30 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 5 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 40 |
| 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 4 | 28 |
| 4 | 4 | 4 | 5 | 4 | 3 | 5 | 4 | 8 | 40 |
| 5 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 8 | 41 |
| 5 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 7 | 45 |
| 4 | 2 | 2 | 3 | 2 | 1 | 2 | 2 | 5 | 36 |
| 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 7 | 34 |
| 3 | 3 | 2 | 2 | 4 | 2 | 2 | 3 | 6 | 24 |
| 3 | 3 | 2 | 3 | 3 | 2 | 3 | 4 | 7 | 27 |
| 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 8 | 56 |
Solution
We will need to make a contingenc table for doing the ANOVA test. For this we first need to sort the data by \'age\' in excel. And then find the mean of all the dependent variables for each created group.
The output is something like this -
The single factor ANOVA results in -
As the P value is very very small, so we can say that there is no significant difference between the groups of age.
| <29 | 30-39 | 40-49 | 50-59 | 60-69 | |
| E1 | 3.037037 | 3.896552 | 4.485714 | 5 | 5 |
| E2 | 2.592593 | 3.413793 | 4.171429 | 4.909091 | 4.5 |
| E3 | 2.037037 | 3.034483 | 4.171429 | 4.909091 | 4.5 |
| E4 | 2.296296 | 3.724138 | 4.628571 | 4.909091 | 4.5 |
| C1 | 2.851852 | 3.068966 | 3.885714 | 4.636364 | 4.5 |
| C2 | 2 | 2.137931 | 2.885714 | 3.636364 | 3.5 |
| C3 | 2.703704 | 3.034483 | 4.228571 | 4.636364 | 4.5 |
| C4 | 2.740741 | 2.862069 | 3.971429 | 4.818182 | 4 |
| Dependent Overall | 5.592593 | 5.862069 | 7.428571 | 7.909091 | 8 |
