X f Week 2: Identifying Significant Differences - part 1 AB DET FIGHT 1 Week 2 Illentifying Significant Differences - part 1 3 To Ensure full credit for each question, you need to show how you got your results. This involves either showing where the data you used is located 4 or showing the excel formula in each cell Be sure to copy the appropriate data cohmns from the data tab to the right for your use this week 6 As with our examination of comparatio in the lecture, the first question we have about salary between the genders involves equality - are they the same or direct 7 What we do depends upon our findings 1 Use Cell Klo for the Excel test outcome location As with the comparatio lecture example, we want to examine salary Variation within the groups are they equal? What is the data input ranged used for this question Which is needed for this question a one- or two-tail hypothesis statement and test? Answer Why c. Step 1: Ho Ha Step 2: Significance (Alpha) Step 3. Test Statistic and test Why this test? Step 4: Decision rule Step 5: Conduct the test - place test function in cell k10 Step 6. Conclusion and Interpretation What is the p-value Week 1 Week 2 Week 3 Week 4 Data Rea Type here to search o ex O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit. it's safer to stay in Protected View Enable Editing AI - 1 X Week 2: Identifying Significant Differences - part 1 AB BCDEFGHIJKL LMNO 1 Week 2 Hentifying Significant Differences - part 1 3 To Ensure full credit for each question, you need to show how you got your results. This involves either showing where the data you used is located 4 or showing the excel formula in each cell Be sure to copy the appropriate data columns from the data tab to the right for your use this week 6 As with our examination of comparatio in the lecture, the first question we have about salary between the genders involves equality are they the same or different? 7 What we do, depends upon our findings 9 1 Use Cell K10 for the Excel test outcome location As with the comparatio lecture example, we want to examine salary variation within the groups - are they equal? a What is the data input ranged used for this question b Which is needed for this question a one- or two-tal hypothesis statement and test? Answer Why: c. Step 1 Ho Step 2. Significance (Alpha Step 3. Test Statistic and test Why this test Step 4: Decision nule Step 5. Conduct the test place test function in cell k 10 Step 6. Conclusion and Interpretation What is the p-value week 1 Week 2 Week 3 Week 4 Data Type here to search nume insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected View O Enable Editing A18 GHIJK K L M N O 2 Use Cell K-35 for the Excel test outcome location. Once we know about variance quality, we can move on to means: Are male and female average salaries equal? (Regardless of the outcome of the above F-test, assume equal variances for this test.) What is the data input ranged used for this question: b Does this question need a one or two-tail hypothesis statement and test? Why c. Step 1: Step 2: Significance (Alpha) Step 3: Test Statistic and test: Why this test? Step 4: Decision rule Step 5: Conduct the test place test function in cell 35 Step 6: Conclusion and Interpretation What is the p-value: What is your decision REJ or NOT reject the null Why? What is your conclusion about the means in the population for male and female salaries? 54 3 Education is often a factor in pay diferences Data Week 1 Week 2 Week 3 Week AutoSave CD R 2019 11 Canvas BUS 308 NOV Student Worksheet (10) Protected V... Search File Home insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing ALS Step 6: Conclusion and Interpretation What is the p-value Is the value in the distribution tail indicated by the arrow in the Ha claim? What is your decision: RETO NOT reject the mull Why What is your conclusion about the impact of education on average salaries? 4 Considering both the comparatio information from the lectures and your salary information, what conclusions can you reach about equal pay for equal work Why what statistical results support this conclusan X f Week 2: Identifying Significant Differences - part 1 AB DET FIGHT 1 Week 2 Illentifying Significant Differences - part 1 3 To Ensure full credit for each question, you need to show how you got your results. This involves either showing where the data you used is located 4 or showing the excel formula in each cell Be sure to copy the appropriate data cohmns from the data tab to the right for your use this week 6 As with our examination of comparatio in the lecture, the first question we have about salary between the genders involves equality - are they the same or direct 7 What we do depends upon our findings 1 Use Cell Klo for the Excel test outcome location As with the comparatio lecture example, we want to examine salary Variation within the groups are they equal? What is the data input ranged used for this question Which is needed for this question a one- or two-tail hypothesis statement and test? Answer Why c. Step 1: Ho Ha Step 2: Significance (Alpha) Step 3. Test Statistic and test Why this test? Step 4: Decision rule Step 5: Conduct the test - place test function in cell k10 Step 6. Conclusion and Interpretation What is the p-value Week 1 Week 2 Week 3 Week 4 Data Rea Type here to search o ex O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit. it's safer to stay in Protected View Enable Editing AI - 1 X Week 2: Identifying Significant Differences - part 1 AB BCDEFGHIJKL LMNO 1 Week 2 Hentifying Significant Differences - part 1 3 To Ensure full credit for each question, you need to show how you got your results. This involves either showing where the data you used is located 4 or showing the excel formula in each cell Be sure to copy the appropriate data columns from the data tab to the right for your use this week 6 As with our examination of comparatio in the lecture, the first question we have about salary between the genders involves equality are they the same or different? 7 What we do, depends upon our findings 9 1 Use Cell K10 for the Excel test outcome location As with the comparatio lecture example, we want to examine salary variation within the groups - are they equal? a What is the data input ranged used for this question b Which is needed for this question a one- or two-tal hypothesis statement and test? Answer Why: c. Step 1 Ho Step 2. Significance (Alpha Step 3. Test Statistic and test Why this test Step 4: Decision nule Step 5. Conduct the test place test function in cell k 10 Step 6. Conclusion and Interpretation What is the p-value week 1 Week 2 Week 3 Week 4 Data Type here to search nume insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected View O Enable Editing A18 GHIJK K L M N O 2 Use Cell K-35 for the Excel test outcome location. Once we know about variance quality, we can move on to means: Are male and female average salaries equal? (Regardless of the outcome of the above F-test, assume equal variances for this test.) What is the data input ranged used for this question: b Does this question need a one or two-tail hypothesis statement and test? Why c. Step 1: Step 2: Significance (Alpha) Step 3: Test Statistic and test: Why this test? Step 4: Decision rule Step 5: Conduct the test place test function in cell 35 Step 6: Conclusion and Interpretation What is the p-value: What is your decision REJ or NOT reject the null Why? What is your conclusion about the means in the population for male and female salaries? 54 3 Education is often a factor in pay diferences Data Week 1 Week 2 Week 3 Week AutoSave CD R 2019 11 Canvas BUS 308 NOV Student Worksheet (10) Protected V... Search File Home insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing ALS Step 6: Conclusion and Interpretation What is the p-value Is the value in the distribution tail indicated by the arrow in the Ha claim? What is your decision: RETO NOT reject the mull Why What is your conclusion about the impact of education on average salaries? 4 Considering both the comparatio information from the lectures and your salary information, what conclusions can you reach about equal pay for equal work Why what statistical results support this conclusan