Data analysis tool: employees with a Bachelor degree and MBA

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