Data analysis tool: employees with a Bachelor degree and MBA

Anonymous
timer Asked: Feb 20th, 2019
account_balance_wallet $20

Question Description

Please use the PreWorkDummyData.xlsx to answer the following questions.

Question 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)

Question 2- 25 pts

What is the variance in Years at the Company for employees with an MBA? (round to 2 decimal points. ex. 1.22)

Question 3- 25 pts

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)

Question 4- 25 pts

Is the difference In Years at the Company for employees with an Bachelor degree vs an MBA significant?

Yes. The p-value is less than .01 but more than .001

No

Yes. The p-value is less than .001

Yes. The p-value is less than .05 but more than .01

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) Question 2- 25 pts What is the variance in Years at the Company for employees with an MBA? (round to 2 decimal points. ex. 1.22) Question 3- 25 pts 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) Question 4- 25 pts Is the difference In Years at the Company for employees with an Bachelor degree vs an MBA significant? Yes. The p-value is less than .01 but more than .001 No Yes. The p-value is less than .001 Yes. The p-value is less than .05 but more than .01
EmpID YearsatCompany Degree 8681149.84 1 Bachelor 13986439.5 4 Bachelor 20056816.3 3 Bachelor 72690935.9 3 Bachelor 72846332.7 2 Bachelor 74588587.4 2 Bachelor 90631837.6 2 Bachelor 111205691 1 Bachelor 119156502 3 Bachelor 144227921 1 Bachelor 150424183 2 Bachelor 165255148 3 Bachelor 186905591 3 Bachelor 200099594 6 Bachelor 231905685 1 Bachelor 242855466 2 Bachelor 249422782 4 Bachelor 254705093 3 Bachelor 266686158 1 Bachelor 295652489 2 Bachelor 302498709 3 Bachelor 313871898 1 Bachelor 367441048 7 Bachelor 378595037 1 Bachelor 430273383 7 Bachelor 444542567 1 Bachelor 478126898 3 Bachelor 514404306 1 Bachelor 519249642 9 Bachelor 567534757 4 Bachelor 574658351 3 Bachelor 574965478 2 Bachelor 632150736 2 Bachelor 632215122 1 Bachelor 639983427 4 Bachelor 644262262 4 Bachelor 653555217 4 Bachelor 654141485 2 Bachelor 708474174 3 Bachelor 725829432 2 Bachelor 772009115 1 Bachelor 787572214 6 Bachelor 791826067 796779981 824671361 847831761 895416732 912832616 918479466 951393144 976472313 17065469.4 78151561.3 87192383.5 92387659.7 149483522 183123179 203583772 206005406 301680744 322982399 325937835 338289909 342662231 396687867 413983433 420115938 470273204 503301232 505495546 538305217 558137121 560755231 561029131 566896973 598708726 607483311 735965616 793433791 796406558 798595872 831261013 852785298 857930293 860386223 3 8 2 2 3 2 2 2 3 1 6 5 5 1 1 2 2 2 7 12 7 5 11 7 6 1 5 5 2 2 6 2 7 9 2 1 7 2 5 7 10 6 5 Bachelor Bachelor Bachelor Bachelor Bachelor Bachelor Bachelor Bachelor Bachelor MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA MBA 873435023 907235431 924348387 925345497 944209396 969202543 992680460 7 5 10 2 6 8 2 MBA MBA MBA MBA MBA MBA MBA

Tutor Answer

Missfomen
School: New York University

Attached.

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

flag Report DMCA
Review

Anonymous
Good stuff. Would use again.

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors