Question: Week 4 Homework When submitting your assignment, you should only submit this document. Do not submit the Excel workbook in Blackboard. Please utilize the Week
Week 4 Homework When submitting your assignment, you should only submit this document. Do not submit the Excel workbook in Blackboard. Please utilize the Week 4 Excel file created specifically for this assignment. After answering questions #1 and #2 listed below on the null and alternative hypotheses, perform the below calculations using the Week 4 Excel file. It has two columns with Income - Variable 1 and Income - Variable 2 listed. These are the two variables to be compared in the two-sample t-test assuming equal variances as listed in the instructions below. Note that Week 3 content covered the null and alternative hypotheses. 1. What is the null hypothesis for the above comparison? 2. What is the alternative hypothesis for the above comparison? INSTRUCTIONS FOR EXCEL CALCULATION: Using Excel, perform a two-sample (independent) t-test ratio, assuming homogeneity of variance. Using Week 4 Excel file, select Income-Variable 1 for the first Input Variable 1 Range. Select Income-Variable 2 for the second Input Variable 2 Range. In Excel's output window, expand column A so that all words in the first column can be easily read. Copy the output below: 3. Is there a significant difference between the two sample means? If you answer, "yes," what is your reasoning? If you answer, "no," what is your reasoning? 4. Please state the conclusion for whether a significant difference exists using the null and alternative hypotheses. Of course, your statements should agree with whether you believe a significant difference exists between the sample means as you answered in question #3. Your answer should reflect the "the statistical decision associated with the hypothesis test using the null and alternative hypotheses" in chapter 6
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
