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 agoRelated 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
ADVERTISEMENT
Latest Questions
- "Ethical Considerations" Please respond to the following: Reflect upon the responsibilities placed on auditors by the...
- A Japanese company has a bond outstanding that sells for 93 percent of its ¥100,000 par...
- What is the difference among the principles of modularization, abstraction, encapsulation, and separation of interface and...
- An investment project costs $20,100 and has annual cash flows of $4,400 for six years. ...
- PUT IN JAVA PROGRAMMING The StockB class: Design a class named StockB that contains the following...
- Draw a DFA for the following ( ∑ = {0,1}): Set of all strings with.
- In the article from Forbes notes that the goal of a leader is not to clone...
ADVERTISEMENT