Choose a topic you wish to study with readily available numerical data (normally distributed continuous scale or ratio data) and at least 1 grouping variable (usually a nominal variable with at least 3 categories). Pick out at least 3 independent variables (better to pick more than three in case you have to delete one), 1 dependent variable, and one grouping variable. Make sure your data set for each calculation has at least 50 usable observations after treatments for missing data, outliers, and multicollinearity have been applied.
Create a regression model to analyze the hypothesized causal relationships between independent and dependent variables. Your model must have at least 3 numerical (scale or ratio) independent variables and the dependent must be continuous for this section (logistic regression may be used in part 4, but not here). Categorical independent variables may be included as dummy variables but will not count as one of the three required continuous independent variables. Correctly state your null and alternative hypotheses. Choose the correct statistical technique to analyze the data, conduct the analysis, then present and explain your results.
Use a nominal variable to group data into at least 3 categories, then determine if the dependent variable differs across categories. Correctly state your null and alternative hypotheses. Choose the correct statistical technique to analyze the data, conduct the analysis, then present and explain your results.
Topic: Household income in relation to levels of education
Categorical Analysis
Does household income contribute to different levels of education?
Grouping Variable- low income families, medium income families, high income families
Independent Variable- Median household income
Dependent variable- level of education (High School Graduate, Bachelor Degree or higher, Advanced Degree)
Regression Analysis
What is the linear relationship between students median household income and their highest level of education?
Dependent Variable-Level of education
Multiple independent Variables- Medium Household income (Low 50K or less, Middle 51K-106K, Upper Middle 107K-374K, High 374K-Up)
Dummy Variables- NA
Moderators-NA
Create ANOVA and Regression Analysis
2019 Median Household Income US HS Population High School Degree or Above (rate) US Population of Bachelor program or Above StiBachelor's Degree or Abo US Population of Advanced Degree Programs Advanced Degree (rate) State Alabama 26.35% 337,382 10.04% 51,734 75,463 2,926,985 452,968 87.11% 93.58% Alaska 885,357 146,157 1,492,158 30.19% 56,574 561,120 11.69% 11.35% 62,055 4,331,542 87.60% 30.18% Arizona Arkansas California 48,952 1,781,463 87.48% 475,367 23.34% 168,182 8.26% 80,440 22,636,359 84.03% 9,428,484 35.00% 3,538,760 13.14% Colorado 77,127 3,672,723 92.40% 1,695,602 42.66% 637,777 16.04% Connecticut 78,833 2,264,581 90.71% 994,548 39.84% 445,382 17.84% Delaware 70,176 620,789 90.32% 228,199 33.20% 93,912 13.66% Florida 59,227 13,689,867 88.41% 4,753,637 30.70% 1,770,994 11.44% Georgia 61,980 6,224,197 87.91% 2,301,568 32.51% 891,173 12.59% Hawaii 83,102 920,690 92.38% 335,209 33.63% 115,230 11.56% Idaho 60,999 1,071,091 91.47% 336,655 28.75% 116,466 9.95% Illinois 69,187 7,812,057 89.85% 3,108,972 35.76% 1,222,732 14.06% Indiana 57,603 4,033,932 89.60% 1,212,826 26.94% 435,055 9.66% lowa 61,691 1,966,523 92.63% 622,253 29.31% 202,054 9.52% Kansas 62,087 1,760,324 91.78% 652,489 34.02% 237,638 12.39% Kentucky 52,295 2,657,789 87.19% 765,923 25.13% 312,883 10.26% Louisiana 51,073 2,699,357 85.96% 784,275 24.98% 280,328 8.93% Maine 58,924 923,838 93.21% 328,999 33.19% 123,277 12.44% Maryland 86,738 3,781,706 90.39% 1,710,230 40.88% 798,449 19.08% Massachusetts 85,843 4,429,635 91.32% 2,181,743 44.98% 984,535 20.30% Michigan 59,584 6,298,340 91.35% 2,070,795 30.03% 818,110 11.87% Minnesota 74,593 3,601,522 93.61% 1,433,226 37.25% 490,396 12.75% Mississippi 45,972 1,688,747 85.30% 441,751 22.31% 171,039 8.64% Missouri 57,409 3,814,347 90.68% 1,271,281 30.22% 495,473 11.78% Montana 57,153 699,268 94.25% 249,148 33.58% 77,839 10.49% Nebraska 63,229 1,170,498 92.04% 422,587 33.23% 145,428 11.44% Nevada 63,276 1,855,551 86.85% 548,919 25.69% 193,082 9.04% New Hampshire 77,933 914,078 93.30% 368,237 37.58% 143,601 14.66% New Jersey 85,751 5,591,610 90.32% 2,551,765 41.22% 995,984 16.09% New Mexico 51,945 1,224,660 85.88% 394,598 27.67% 173,317 12.15% New York 72,108 11,970,504 87.60% 5,166,218 37.81% 2,267,778 16.60% North Carolina 57,341 6,368,153 88.61% 2,321,185 32.30% 849,765 11.82% 64,577 471,356 93.45% 153,397 30.41% 44,870 8.90% North Dakota Ohio 58,462 7,308,958 90.80% 2,356,585 29.28% 891,640 11.08% Oklahoma 54,449 2,315,978 88.42% 686,509 26.21% 238,621 9.11% 13.53% 12.80% 13.95% 11.17% 9.11% Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming 67,058 63,463 89,093 56,227 59,533 56,071 64,034 75,780 63,001 76,456 463,977 48,850 64,168 56,003 2,729,719 8,216,204 666,745 3,147,526 541,735 4,131,145 15,890,162 1,778,532 414,700 5,288,045 91.85% 1,116,281 3,724,423 368,597 91.35% 91.01% 89.26% 88.33% 92.13% 88.01% 84.65% 93.04% 93.07% 90.04% 301,429 87.14% 92.76% 94.55% 1,032,316 2,917,402 260,275 1,054,559 174,784 1,348,224 5,776,533 664,661 172,272 2,325,070 59.67% 269,706 1,258,379 113,557 34.55% 32.31% 34.84% 29.60% 29.72% 28.72% 30.77% 34.77% 38.66% 39.59% 171,604 21.05% 31.34% 29.13% 404,405 1,155,775 104,188 398,063 53,553 503,124 2,025,736 216,552 71,257 1,012,270 33.97% 108,020 428,501 40,374 10.72% 10.79% 11.33% 15.99% 17.24% 8.43% 10.67% 10.36% 2019 Median Household Income US HS Population High School Degree or Above (rate) US Population of Bachelor program or Above StiBachelor's Degree or Abo US Population of Advanced Degree Programs Advanced Degree (rate) State Alabama 26.35% 337,382 10.04% 51,734 75,463 2,926,985 452,968 87.11% 93.58% Alaska 885,357 146,157 1,492,158 30.19% 56,574 561,120 11.69% 11.35% 62,055 4,331,542 87.60% 30.18% Arizona Arkansas California 48,952 1,781,463 87.48% 475,367 23.34% 168,182 8.26% 80,440 22,636,359 84.03% 9,428,484 35.00% 3,538,760 13.14% Colorado 77,127 3,672,723 92.40% 1,695,602 42.66% 637,777 16.04% Connecticut 78,833 2,264,581 90.71% 994,548 39.84% 445,382 17.84% Delaware 70,176 620,789 90.32% 228,199 33.20% 93,912 13.66% Florida 59,227 13,689,867 88.41% 4,753,637 30.70% 1,770,994 11.44% Georgia 61,980 6,224,197 87.91% 2,301,568 32.51% 891,173 12.59% Hawaii 83,102 920,690 92.38% 335,209 33.63% 115,230 11.56% Idaho 60,999 1,071,091 91.47% 336,655 28.75% 116,466 9.95% Illinois 69,187 7,812,057 89.85% 3,108,972 35.76% 1,222,732 14.06% Indiana 57,603 4,033,932 89.60% 1,212,826 26.94% 435,055 9.66% lowa 61,691 1,966,523 92.63% 622,253 29.31% 202,054 9.52% Kansas 62,087 1,760,324 91.78% 652,489 34.02% 237,638 12.39% Kentucky 52,295 2,657,789 87.19% 765,923 25.13% 312,883 10.26% Louisiana 51,073 2,699,357 85.96% 784,275 24.98% 280,328 8.93% Maine 58,924 923,838 93.21% 328,999 33.19% 123,277 12.44% Maryland 86,738 3,781,706 90.39% 1,710,230 40.88% 798,449 19.08% Massachusetts 85,843 4,429,635 91.32% 2,181,743 44.98% 984,535 20.30% Michigan 59,584 6,298,340 91.35% 2,070,795 30.03% 818,110 11.87% Minnesota 74,593 3,601,522 93.61% 1,433,226 37.25% 490,396 12.75% Mississippi 45,972 1,688,747 85.30% 441,751 22.31% 171,039 8.64% Missouri 57,409 3,814,347 90.68% 1,271,281 30.22% 495,473 11.78% Montana 57,153 699,268 94.25% 249,148 33.58% 77,839 10.49% Nebraska 63,229 1,170,498 92.04% 422,587 33.23% 145,428 11.44% Nevada 63,276 1,855,551 86.85% 548,919 25.69% 193,082 9.04% New Hampshire 77,933 914,078 93.30% 368,237 37.58% 143,601 14.66% New Jersey 85,751 5,591,610 90.32% 2,551,765 41.22% 995,984 16.09% New Mexico 51,945 1,224,660 85.88% 394,598 27.67% 173,317 12.15% New York 72,108 11,970,504 87.60% 5,166,218 37.81% 2,267,778 16.60% North Carolina 57,341 6,368,153 88.61% 2,321,185 32.30% 849,765 11.82% 64,577 471,356 93.45% 153,397 30.41% 44,870 8.90% North Dakota Ohio 58,462 7,308,958 90.80% 2,356,585 29.28% 891,640 11.08% Oklahoma 54,449 2,315,978 88.42% 686,509 26.21% 238,621 9.11% 13.53% 12.80% 13.95% 11.17% 9.11% Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming 67,058 63,463 89,093 56,227 59,533 56,071 64,034 75,780 63,001 76,456 463,977 48,850 64,168 56,003 2,729,719 8,216,204 666,745 3,147,526 541,735 4,131,145 15,890,162 1,778,532 414,700 5,288,045 91.85% 1,116,281 3,724,423 368,597 91.35% 91.01% 89.26% 88.33% 92.13% 88.01% 84.65% 93.04% 93.07% 90.04% 301,429 87.14% 92.76% 94.55% 1,032,316 2,917,402 260,275 1,054,559 174,784 1,348,224 5,776,533 664,661 172,272 2,325,070 59.67% 269,706 1,258,379 113,557 34.55% 32.31% 34.84% 29.60% 29.72% 28.72% 30.77% 34.77% 38.66% 39.59% 171,604 21.05% 31.34% 29.13% 404,405 1,155,775 104,188 398,063 53,553 503,124 2,025,736 216,552 71,257 1,012,270 33.97% 108,020 428,501 40,374 10.72% 10.79% 11.33% 15.99% 17.24% 8.43% 10.67% 10.36%
