Question

part (a) Open the "Union Status and Income. xlsx" file that is posted with the assignment....

part (a)

Open the "Union Status and Income. xlsx" file that is posted with the assignment. In order to test whether there is a difference in the variance of income between Union members and non-Union members, use Excel to carry out an "F-Test: Two-Sample for variances" with Alpha =0.05

part (b)

Still using the "Union Status and Income .xlsx" file, carry out a t-test in excel (with Alpha=0.05) that tests whether there is a difference in mean income between Union members and non-union members.

Note that the decision of which of the t-tests in excel is appropriate depends on your result from part (a)

Part (c)

Based on the t-test, what is your decision( "reject" or "do not reject") regarding the null hypothesis that the two population means are equal to each other? Indicate on which part of the Excel output you base your decision.

part (d)

Explain what your answer to part (c) means at a level that can be understood by a high school senior.

Annual Salary of Union Members
44604
33199.5
28959
19977
19743
75256.5
38505
74961
34540.5
28128
50191.5
49179
68964
40230
50938.5
75256.5
38505
74961
Annual Salary of Non-Union Members
125401.5
75352.5
32991
44085
26541
40192.5
29971.5
21714
29178
42252
37749
27181.5
48141
25000.5
47536.5
54267
22851
25225.5
33727.5
45462
17553
16779
18427.5
28926
17176.5
86434.5
125164.5
69969
47553
19968
66814.5
22519.5
50083.5
90939
36763.5
31278
45199.5
47698.5
25194
31189.5
44110.5
43786.5
23935.5
51726
52777.5
39921
62670
83665.5
22740
100107
50026.5
50247
44713.5
22789.5
112747.5
125353.5
48352.5
31278
20680.5
52119
26535
79143
90228
20221.5
14818.5
25183.5
46956
56656.5
75280.5
59832
28840.5
42660
50116.5
32574
56496
44965.5
17670
16495.5
26439
47536.5
54267
22851
25225.5
33727.5
45462
17553
16779
18427.5
28926
17176.5
86434.5
125164.5
69969
47553
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1


0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question 1 Part (a) Chicken Delight claims that at least 90 percent of its orders are...
Question 1 Part (a) Chicken Delight claims that at least 90 percent of its orders are delivered within 5 minutes of the time the order was placed. A sample of 50 orders revealed that 42 of them were delivered within 5 minutes. Using a level of significance of 0.05, carry out a hypothesis test for Chicken Delight’s claim. Part (b) What percentage of orders was delivered within 5 minutes in Part (a)? Part (c) What is the decision regarding H0...
To test the effectiveness of a studying program, participants are randomly assigned to either the control...
To test the effectiveness of a studying program, participants are randomly assigned to either the control group or the treatment group (N=10 for each). At the end of the trials, the average test score increase in the control group is 3.5 points (s=0.7) and the treatment group increased 1.9 (s=1.1). Test the null hypothesis that there is no difference in test score improvement between the treatment and control groups (alpha = 0.05). For independent sample t-tests: mean values for each...
A college placement office wants to determine whether male and female economics graduates receive, on average,...
A college placement office wants to determine whether male and female economics graduates receive, on average, different salary offers for their first position after graduation. The placement officer randomly selected eight pairs of business graduates in such a sway that the qualifications, interests, and backgrounds of the members of any pair were as similar as possible. The data file Salary Pair contains the highest salary offer received by each sample member at the end of the recruiting round. Assume that...
Please show all work: Assignment: You will be answering problems #1 - #4. For each problem,...
Please show all work: Assignment: You will be answering problems #1 - #4. For each problem, you will need to complete parts A through F. Please make sure you answer each part completely and you offer justification where necessary. Do all work "by hand" (not using StatCrunch) as good practice for your next exam! A) Write the claim mathematically and state the null and alternative hypotheses. B) Determine whether the hypothesis test is left-tailed, right-tailed, or two tailed and whether...
MATH220 Lab04 Due Date: See ACE Excel File: Lab2204-182.xlsx 1 Question 1: (by hand) A retail...
MATH220 Lab04 Due Date: See ACE Excel File: Lab2204-182.xlsx 1 Question 1: (by hand) A retail establishment accepts either the American Express card or the VISA credit card. A total of 30% of its customers carry an American Express card, 70% carry a VISA card, and 20% carry both. a) Find the probability that a randomly selected customer carries at least one of the two credit cards. i) Draw a Venn diagram and shade the region corresponding to at least...
Please show all work: Assignment: You will be answering problems #1 - #4. For each problem,...
Please show all work: Assignment: You will be answering problems #1 - #4. For each problem, you will need to complete parts A through F. Please make sure you answer each part completely and you offer justification where necessary.   Do all work "by hand" (not using StatCrunch) as good practice for your next exam! A) Write the claim mathematically and state the null and alternative hypotheses. B) Determine whether the hypothesis test is left-tailed, right-tailed, or two tailed and whether...
Recently there has been a marketing push promoting the new wave of electronic cigarettes in the...
Recently there has been a marketing push promoting the new wave of electronic cigarettes in the media. Suppose a new study claims that they have determined that e-cigarette smokers still have a much higher risk for esophageal cancer than non-smokers. Assume the following table of summary statistics describes the SRSs of those in the e-cigarette group versus non-smokers. Study Group Average # of cases of esophageal cancer Standard deviation Sample Size E-cigarette Smokers 21.4 1.8 749 Non-Smokers 2.7 0.8 898...
Enter the hypothetical data below in SPSS to use for the assignment. The SPSS commands: 'file',...
Enter the hypothetical data below in SPSS to use for the assignment. The SPSS commands: 'file', 'new', 'data' will create a spreadsheet in which to enter the data below (manually). Case      Group                   Test 1              1                              6 2              1                              7 3              1                              5              4              1                              4 5              1                              1 6              2                              3 7              2                              5 8              2                              2 9              2                              5 10           2                                1 The groups are coded as follows: 1=experimental group, 2 control group. The participants in the experimental...
The CEO of a company would like to determine whether advertising increases sales. So the null...
The CEO of a company would like to determine whether advertising increases sales. So the null hypothesis tested is H0: μd ≤ 0. The CEO hires you to conduct the analysis for the period 2018 to 2019. Using a Matched sample design yields the following result: t-Test: Paired Two Sample for Means 2019 2018 Mean 191.8 172.05 Variance 2030.574359 2878.664103 Observations 40 40 Pearson Correlation 0.821186783 Hypothesized Mean Difference 0 df 39 t Stat 4.077479845 P(T<=t) one-tail 0.000108536 t Critical...
The research hypothesis: The number of hours of TV watching tends to vary by gender (sex)...
The research hypothesis: The number of hours of TV watching tends to vary by gender (sex) ( the greater the number represents more hours). Alpha = .01 The date I used is GSS2010 1. Write out the null hypothesis and indicate whether this is a one-tailed or two-tailed test; 2. get the t critical value; 3. Make your decision whether we should reject the null hypothesis based on the test results (i.e. t(obtained), and p value). 4 Write out your...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT