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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
