Question
EmpID YearsatCompany Degree 8681149.843 1 Bachelor 13986439.49 4 Bachelor 20056816.3 3 Bachelor 72690935.88 3 Bachelor 72846332.68...
| EmpID | YearsatCompany | Degree |
| 8681149.843 | 1 | Bachelor |
| 13986439.49 | 4 | Bachelor |
| 20056816.3 | 3 | Bachelor |
| 72690935.88 | 3 | Bachelor |
| 72846332.68 | 2 | Bachelor |
| 74588587.36 | 2 | Bachelor |
| 90631837.59 | 2 | Bachelor |
| 111205690.9 | 1 | Bachelor |
| 119156502.3 | 3 | Bachelor |
| 144227921.1 | 1 | Bachelor |
| 150424183.2 | 2 | Bachelor |
| 165255147.7 | 3 | Bachelor |
| 186905590.8 | 3 | Bachelor |
| 200099593.9 | 6 | Bachelor |
| 231905684.7 | 1 | Bachelor |
| 242855466.3 | 2 | Bachelor |
| 249422782.1 | 4 | Bachelor |
| 254705093 | 3 | Bachelor |
| 266686158.5 | 1 | Bachelor |
| 295652488.9 | 2 | Bachelor |
| 302498709.5 | 3 | Bachelor |
| 313871898.2 | 1 | Bachelor |
| 367441047.6 | 7 | Bachelor |
| 378595037.5 | 1 | Bachelor |
| 430273383 | 7 | Bachelor |
| 444542567.2 | 1 | Bachelor |
| 478126897.6 | 3 | Bachelor |
| 514404306.1 | 1 | Bachelor |
| 519249642 | 9 | Bachelor |
| 567534756.7 | 4 | Bachelor |
| 574658351.1 | 3 | Bachelor |
| 574965478.3 | 2 | Bachelor |
| 632150736.3 | 2 | Bachelor |
| 632215121.7 | 1 | Bachelor |
| 639983427 | 4 | Bachelor |
| 644262262.4 | 4 | Bachelor |
| 653555217.1 | 4 | Bachelor |
| 654141485.5 | 2 | Bachelor |
| 708474174.1 | 3 | Bachelor |
| 725829432.2 | 2 | Bachelor |
| 772009115.2 | 1 | Bachelor |
| 787572213.6 | 6 | Bachelor |
| 791826067.2 | 3 | Bachelor |
| 796779981.3 | 8 | Bachelor |
| 824671361.1 | 2 | Bachelor |
| 847831761.3 | 2 | Bachelor |
| 895416732 | 3 | Bachelor |
| 912832616.1 | 2 | Bachelor |
| 918479466.2 | 2 | Bachelor |
| 951393143.8 | 2 | Bachelor |
| 976472313.2 | 3 | Bachelor |
| 17065469.41 | 1 | MBA |
| 78151561.28 | 6 | MBA |
| 87192383.5 | 5 | MBA |
| 92387659.73 | 5 | MBA |
| 149483521.7 | 1 | MBA |
| 183123179.1 | 1 | MBA |
| 203583772.4 | 2 | MBA |
| 206005405.9 | 2 | MBA |
| 301680743.6 | 2 | MBA |
| 322982399.1 | 7 | MBA |
| 325937835 | 12 | MBA |
| 338289909.4 | 7 | MBA |
| 342662230.9 | 5 | MBA |
| 396687866.8 | 11 | MBA |
| 413983433.4 | 7 | MBA |
| 420115938 | 6 | MBA |
| 470273203.8 | 1 | MBA |
| 503301232 | 5 | MBA |
| 505495545.5 | 5 | MBA |
| 538305216.8 | 2 | MBA |
| 558137120.6 | 2 | MBA |
| 560755230.8 | 6 | MBA |
| 561029130.9 | 2 | MBA |
| 566896973.2 | 7 | MBA |
| 598708725.9 | 9 | MBA |
| 607483310.9 | 2 | MBA |
| 735965616.4 | 1 | MBA |
| 793433790.5 | 7 | MBA |
| 796406558 | 2 | MBA |
| 798595871.8 | 5 | MBA |
| 831261012.9 | 7 | MBA |
| 852785298.2 | 10 | MBA |
| 857930293.3 | 6 | MBA |
| 860386222.6 | 5 | MBA |
| 873435022.9 | 7 | MBA |
| 907235431 | 5 | MBA |
| 924348387.4 | 10 | MBA |
| 925345497.3 | 2 | MBA |
| 944209395.7 | 6 | MBA |
| 969202543 | 8 | MBA |
| 992680460.3 | 2 | MBA |
1. What is the mean difference in Years at Company between employees with a Bachelor degree and those with an MBA? (round to 2 decimal points. ex. 1.22)
2. What is the variance in Years at the Company for employees with an MBA? (round to 2 decimal points. ex. 1.22)
3. What is the t-statistic for the difference In Years at the Company for employees with an Bachelor degree vs an MBA? (round to 2 decimal points. ex. 1.22)
4. Is the difference In Years at the Company for employees with an Bachelor degree vs an MBA significant?
A. Yes. The p-value is less than .001
B. Yes. The p-value is less than .05 but more than .01
C. No
D. Yes. The p-value is less than .01 but more than .001
Homework Answers
Answer #1
Excel Output
| t-Test: Two-Sample Assuming Unequal Variances | ||
| Bachelor | MBA | |
| Mean | 2.882353 | 4.97561 |
| Variance | 3.505882 | 9.07439 |
| Observations | 51 | 41 |
| Hypothesized Mean Difference | 0 | |
| df | 64 | |
| t Stat | -3.88662 | |
| P(T<=t) one-tail | 0.000122 | |
| t Critical one-tail | 1.669013 | |
| P(T<=t) two-tail | 0.000244 | |
| t Critical two-tail | 1.99773 |
1) Mean difference = 2.882353- 4.97561= -2.09
=============================================
=============================================
3. t = -3.89
=============================================
4. A. Yes. The p-value is less than .001
Not the answer you're looking for?
Similar Questions
1. In a company, it was observed that the proportion of employees with a Bachelor’s degree...
1. In a company, it was observed that
the proportion of employees with a Bachelor’s degree is 40%. The
board of directors wants to know if the proportion of Bachelor’s
degrees earners on the management/executive teams is greater than
the proportion company-wide. Test at α = .01 level of
significance.
a. Using the
normal approximation for the binomial distribution (without
continuity correction), what is the test statistic for this sample
proportion? (show work)
i. z =
_____
ii. ...
Calculate the acute angle, rounded to the nearest degree, formed by (a) the lineX=3?−1, Y=9−9?, Z=−3−4?...
Calculate the acute angle, rounded to the nearest degree, formed
by
(a) the lineX=3?−1, Y=9−9?, Z=−3−4? and the line X=9, Y=−6−6?,
Z=−8−7? Answer: 30
(b) The line ?⃗ =〈−4,4,7〉+?〈2,−2,6〉 and the line ?⃗
=〈−3,4,−4〉+?〈−2,−8,−4〉 Answer:
(c)The plane −4?−?+8?=22 and the plane 8?+2?+4?=−28 Answer:
d) The line ?⃗ =〈7,−8,−1〉+?〈0,8,−5〉 and the plane 3?+7?+7?=4
Answer:
a is correct would you please do b c and d
calculate the angle formed between the lines
Pair 1 2 3 4 5 6 7 8 9 10 Medication 7 8 9 5...
Pair 1 2 3 4 5 6 7 8 9 10
Medication 7 8 9 5 6 7 7 8 8 7
Placebo 5 5 7 6 8 7 5 9 3 7
(Note: If you’re going to subtract, choose the order medication
- placebo.)
A sample of patients with similar weight and age characteristics
were put in pairs. One patient in the pair was given medication
while the other patient was given a placebo. After a month patients
were...
Find a polynomial of the specified degree that satisfies the given conditions. Degree 4; zeros −3, 0,...
Find a polynomial of the specified degree that satisfies the
given conditions.
Degree 4; zeros −3, 0, 1,
5; coefficient of x3 is
6
How many trees T are there on the set of vertices {1, 2, 3, 4, 5,...
How many trees T are there on the set of vertices
{1, 2, 3, 4, 5, 6, 7} in which the vertices 2 and 3 have degree 3,
vertex
5 has degree 2, and hence all others have degree 1? Do not
just
draw pictures but consider the possible Pr¨ufer codes of these
trees.
The Academic Dean for Extraordinaire University (EU) assessed all new students for their motivation to learn...
The Academic Dean for Extraordinaire University (EU) assessed
all new students for their motivation to learn as measured by the
Rigorous Expectation for Knowledge Aspiration (REKA). He expects
for the EUREKA scores to improve each year. Is there a significant
difference in the EUREKA scores?
YEAR 1
YEAR 2
YEAR 3
YEAR 4
3
4
7
4
4
3
6
2
4
5
6
2
4
4
5
2
3
3
5
5
3
5
8
5
4
3
6...
a) Why is it not possible for a graph to have degree sequence 6, 6, 5,...
a) Why is it not possible for a graph to have degree sequence 6,
6, 5, 5, 4, 4, 4, 4, 3?
b) Why is it not possible for a graph to have degree sequence 8, 8,
7, 6, 5, 4, 3, 2, 1?
A consumer advocate examines whether the longevity of car batteries (measured in years) is affected by...
A consumer advocate examines whether the longevity of car
batteries (measured in years) is affected by the brand name (factor
A) and whether or not the car is kept in a garage (factor
B). Interaction is suspected. The results are shown in the
accompanying table.
Brand Name of Battery
Kept in Garage?
A
B
C
Yes
8, 7, 7
7, 6, 7
8, 9, 10
No
6, 7, 6
5, 6, 4
5, 7, 7
Click here for the Excel...
2. Consider the following data on salaries and experience below. Persons 2,4,6,8,and 9 have MBA degrees....
2. Consider the following data on
salaries and experience below. Persons 2,4,6,8,and 9 have MBA
degrees. All others only have undergraduate degrees. Clearly label
your answers to each equation and show all work..
a. What is the estimated regression
equation?
b. Sketch the graph with estimated
regression that clearly indicates the impact of a MBA degree on
Salary.
c. What is the annual dollar market
value of the MBA degree?
Person Salary Experience
1 $130,468 10
Years
2 62,250 1
3 50,000 2.3
4 140,000 9
5 110,000 8
6 80,050 2.8
7 95,772 7
8 110,000 6...
Assume today is March 16, 2016. Natasha Kingery is 30 years old and has a Bachelor...
Assume today is March 16, 2016. Natasha Kingery is 30 years old
and has a Bachelor of Science degree in computer science. She is
currently employed as a Tier 2 field service representative for a
telephony corporation located in Seattle, Washington, and earns
$38,000 a year that she anticipates will grow at 3% per year.
Natasha hopes to retire at age 65 and has just begun to think about
the future.
Natasha has $75,000 that she recently inherited from her...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 11 minutes ago
asked 21 minutes ago
asked 24 minutes ago
asked 34 minutes ago
asked 44 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago