Question

In: Statistics and Probability

Download data.unemployment.xlsx. Unemployment figures recorded for recent college graduates. Do unemployment figures differ by college/undergraduate major...

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.04632

Solutions

Expert Solution

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

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Suppose 38% of recent college graduates plan on pursuing a graduate degree. Twenty recent college graduates...
Suppose 38% of recent college graduates plan on pursuing a graduate degree. Twenty recent college graduates are randomly selected. a. What is the probability that no more than four of the college graduates plan to pursue a graduate degree? (Do not round intermediate calculations. Round your final answers to 4 decimal places.) b. What is the probability that exactly five of the college graduates plan to pursue a graduate degree? (Do not round intermediate calculations. Round your final answers to...
According to the recent unemployment data, how do the unemployment and participation rates differ for workers...
According to the recent unemployment data, how do the unemployment and participation rates differ for workers age 16-19 and workers over age 20? What, based upon your experience or observations, do you consider to be the primary reason for this difference?
A recent report claims that non-college graduates get married at an earlier age than college graduates....
A recent report claims that non-college graduates get married at an earlier age than college graduates. To support the claim, random samples of size 100 were selected from each group, and the mean age at the time of marriage was recorded. The mean and standard deviation of the non-college graduates were 22.5 years and 1.4 years respectively, while the mean and standard deviation of college graduates were 23 years and 1.8 years respectively. Test the hypothesis (the claim being made)...
A recent study of debt among college graduates reported that the average debt accumulated by graduates...
A recent study of debt among college graduates reported that the average debt accumulated by graduates of private colleges was ​$37,400​, with a sample standard deviation of ​$2,068​, while the average debt accumulated by graduates of public colleges was ​$11,800​, with a sample standard deviation of ​$2,101. The sample sizes were 70 and 180​, respectively. Complete parts a and b below. A. what is the test statistic? Use a significance level of 0.10 B. what is the p value
A recent study of debt among college graduates reported that the average debt accumulated by graduates...
A recent study of debt among college graduates reported that the average debt accumulated by graduates of private colleges was ​$38,100 with a sample standard deviation of $2,042 while the average debt accumulated by graduates of public colleges was ​$11,800 with a sample standard deviation of $2,110 The sample sizes were 60and 190​, respectively. Complete parts a and b below. a. Examine the sample standard deviations. What do these suggest is the relationship between the two population standard​ deviations? Support...
Suppose 44% of recent college graduates plan on pursuing a graduate degree. Twenty six recent college...
Suppose 44% of recent college graduates plan on pursuing a graduate degree. Twenty six recent college graduates are randomly selected. a. What is the probability that no more than seven of the college graduates plan to pursue a graduate degree? (Do not round intermediate calculations. Round your final answers to 4 decimal places.) b. What is the probability that exactly thirteen of the college graduates plan to pursue a graduate degree? (Do not round intermediate calculations. Round your final answers...
Since there is high unemployment in the US and so many college graduates cannot get jobs,...
Since there is high unemployment in the US and so many college graduates cannot get jobs, it is only fair to consider instituting a broad mandatory retirement age again in most workplaces. Agree or disagree? Explain your answer in full details
Young Professional magazine was developed for a target audience of recent college graduates who are in...
Young Professional magazine was developed for a target audience of recent college graduates who are in their first 10 years in a business/professional career. In its two years of publication, the magazine has been fairly successful. Now the publisher is interested in expanding the magazine’s advertising base. Potential advertisers continually ask about the demographics and interests of subscribers to Young Professional. To collect this information, the magazine commissioned a survey to develop a profile of its subscribers. The survey results...
Unemployment among high school graduates is quite high due to a recession. City Community College is...
Unemployment among high school graduates is quite high due to a recession. City Community College is considering a new program to help young people get the training they need to be more employable. The college has collaborated with the municipal hospital to build a nurse’s aide program, a 1-year program that would lead to immediate employment. Initial financial analysis indicates that the total fixed cost of the program will be $200,000, which includes the cost of a 1-year rental of...
Unemployment among high school graduates is quite high due to a recession. City Community College is...
Unemployment among high school graduates is quite high due to a recession. City Community College is considering a new program to help young people get the training they need to be more employable. The college has collaborated with the municipal hospital to build a nurse's aide program, a 1 - year program that would lead to immediate employment. Initial financial analysis indicates that the total fixed cot of the program will be $200,000, which includes the cost of a 1-year...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT