Download data.unemployment.xlsx. Unemployment figures recorded for recent colleg
ID: 2908247 • Letter: D
Question
Download data.unemployment.xlsx. Unemployment figures recorded for recent college graduates. Do unemployment figures differ by college/undergraduate major category? How so? Perform a full One-way ANOVA Analysis!
Major_Category Unemployment_Rate Agriculture & Natural Resources 0.096931 Agriculture & Natural Resources 0.050031 Agriculture & Natural Resources 0.019642 Agriculture & Natural Resources 0.07725 Agriculture & Natural Resources 0.066619 Agriculture & Natural Resources 0.096726 Agriculture & Natural Resources 0 Agriculture & Natural Resources 0.045455 Agriculture & Natural Resources 0.050862 Agriculture & Natural Resources 0.059767 Arts 0.060023 Arts 0.089375 Arts 0 Arts 0.02948 Arts 0.096798 Arts 0.072725 Arts 0.051467 Arts 0.105772 Arts 0.07596 Arts 0.084186 Arts 0.067128 Arts 0.102197 Arts 0.089552 Arts 0.055677 Arts 0.077541 Business 0.095652 Business 0.05824 Business 0.047859 Business 0.060686 Business 0.096448 Business 0.069749 Business 0.072861 Business 0.096175 Business 0.071983 Business 0.072218 Business 0.061215 Business 0.05957 Business 0.061169 Computers & Mathematics 0.063173 Computers & Mathematics 0.047277 Computers & Mathematics 0.09346 Computers & Mathematics 0.060741 Computers & Mathematics 0.086274 Computers & Mathematics 0.090823 Computers & Mathematics 0 Computers & Mathematics 0.113983 Computers & Mathematics 0.099723 Computers & Mathematics 0.15185 Computers & Mathematics 0.119511 Education 0.107579 Education 0.041508 Education 0.05736 Education 0.054083 Education 0.016203 Education 0 Education 0.050306 Education 0.059212 Education 0.052229 Education 0.038638 Education 0.046586 Education 0.047264 Education 0.074667 Education 0.036546 Education 0.040105 Education 0.104946 Engineering 0.018380527+B67:B95 Engineering 0.117241 Engineering 0.024096 Engineering 0.050125 Engineering 0.061098 Engineering 0.177226 Engineering 0.057342 Engineering 0.059174 Engineering 0.065409 Engineering 0.065162 Engineering 0.092084 Engineering 0.023043 Engineering 0.006334 Engineering 0.087143 Engineering 0.042876 Engineering 0.059824 Engineering 0.061931 Engineering 0.087557 Engineering 0.027789 Engineering 0.07061 Engineering 0.074393 Engineering 0.093589 Engineering 0.05503 Engineering 0.075038 Engineering 0.028308 Engineering 0.033652 Engineering 0.113332 Engineering 0.052539 Engineering 0.056357 Health 0.044863 Health 0.036983 Health 0.042507 Health 0.055521 Health 0.081411 Health 0.068701 Health 0.089626 Health 0.112144 Health 0.06978 Health 0.059821 Health 0.082102 Health 0.047584 Humanities & Liberal Arts 0.099092 Humanities & Liberal Arts 0.096799 Humanities & Liberal Arts 0.07308 Humanities & Liberal Arts 0.047179 Humanities & Liberal Arts 0.101175 Humanities & Liberal Arts 0.113459 Humanities & Liberal Arts 0.063429 Humanities & Liberal Arts 0.097244 Humanities & Liberal Arts 0.095667 Humanities & Liberal Arts 0.075566 Humanities & Liberal Arts 0.083634 Humanities & Liberal Arts 0.084951 Humanities & Liberal Arts 0.104436 Humanities & Liberal Arts 0.092306 Humanities & Liberal Arts 0.096052 Humanities & Liberal Arts 0.087724 Humanities & Liberal Arts 0.078268 Humanities & Liberal Arts 0.103455 Humanities & Liberal Arts 0.060298 Humanities & Liberal Arts 0.068584 Humanities & Liberal Arts 0.062628 Humanities & Liberal Arts 0.102792 Humanities & Liberal Arts 0.107116 Humanities & Liberal Arts 0.081742 Psychology & Social Work 0.108787 Psychology & Social Work 0.02965 Psychology & Social Work 0.083811 Psychology & Social Work 0.068828 Psychology & Social Work 0.051908 Psychology & Social Work 0.037819 Psychology & Social Work 0.065112 Psychology & Social Work 0.149048 Psychology & Social Work 0.053621 Science 0.021167 Science 0.07154 Science 0.048224 Science 0.085532 Science 0.056995 Science 0.075236 Science 0.084361 Science 0.034118 Science 0.035354 Science 0.053972 Science 0.066776 Science 0.080531 Science 0 Science 0.075449 Science 0.024374 Science 0.078585 Science 0.055807 Science 0.069163 Science 0.048482 Science 0.022229 Science 0.058545 Science 0.070725 Science 0.054475 Science 0.04632Explanation / Answer
One-way ANOVA: Unemployment_Rate versus Major_Category
Method
Null hypothesis All means are equal
Alternative hypothesis At least one mean is different
Significance level ? = 0.05
Rows unused 1
Equal variances were assumed for the analysis.
Factor Information
Factor Levels Values
Major_Category 10 Agriculture & Natural Resources, Arts, Business, Computers &
Mathematics, Education, Engineering, Health, Humanities & Liberal
Arts, Psychology & Social Work, Science
Analysis of Variance
Source DF Adj SS Adj MS F-Value P-Value
Major_Category 9 0.02152 0.002391 3.07 0.002
Error 152 0.11828 0.000778
Total 161 0.13980
Model Summary
S R-sq R-sq(adj) R-sq(pred)
0.0278949 15.40% 10.39% 3.00%
Means
Major_Category N Mean StDev 95% CI
Agriculture & Natural Resources 10 0.05633 0.03081 (0.03890, 0.07376)
Arts 15 0.07053 0.02839 (0.05630, 0.08476)
Business 13 0.07106 0.01588 (0.05578, 0.08635)
Computers & Mathematics 11 0.0843 0.0407 ( 0.0676, 0.1009)
Education 16 0.05170 0.02732 (0.03792, 0.06548)
Engineering 28 0.06494 0.03454 (0.05452, 0.07535)
Health 12 0.06592 0.02243 (0.05001, 0.08183)
Humanities & Liberal Arts 24 0.08653 0.01731 (0.07528, 0.09778)
Psychology & Social Work 9 0.0721 0.0374 ( 0.0537, 0.0904)
Science 24 0.05491 0.02272 (0.04367, 0.06616)
Pooled StDev = 0.0278949
p-value = 0.002 <0.05
hence there is signifificant evidence that unemployment figures differ by college/undergraduate major category
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.