Question: Please answer the questions in excel and show the formulas used and the step by steps. Thank you, I rate :) 2-Year Salary 4-Year Salary

Please answer the questions in excel and show the formulas used and the step by steps. Thank you, I rate :)

2-Year Salary 4-Year Salary
64,000 81,600
65,000 76,300
72,000 61,000
68,000 60,200
79,000 59,000
82,000 68,600
70,000 51,900
64,000 67,600
81,000 78,900
77,000
59,000
88,000

Are the datasets used for the two groups dependent or independent?

Using the data from the previous problem, calculate a confidence interval for the difference of means. Report the interval and provide an explanation of whether it indicates a significant difference in earning power between the two groups.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!