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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
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...