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 |
Part (a) Open the "Union Status and Income. xlsx" file that is posted with the assignment. In ord...
question 2 refers to the chart of numbers please show work and
attach files if could
sorry for the small pictures but attach files if needed thank you !
heres pictures zoomed in
Question 3 points) Suppose that someone claims that the mean income of two group of individuals is equal. In order to test that claim, a researcher earns $1,448 more on average than the other group. Is that sufficient evidence to reject the claim that the mean income...
Part (a) Using the THE TABLE BELOW that is posted with the assignment, carry out a “t-test: Two-Sample Assuming Unequal Variances” in Excel (with α = 0.05) that tests whether there is a difference in mean maintenance costs between buses with Diesel engines and those with gasoline engines. using Excel file include the output as part of the answer Part (b) Based on the t-test, what is your decision (“reject” or “do not reject”) regarding the null hypothesis...
Using the “Bus Maintenance.xls” file that is posted with the assignment, carry out a “t-test: Two-Sample Assuming Unequal Variances” in Excel (with α = 0.05) that tests whether there is a difference in mean maintenance costs between buses with Diesel engines and those with gasoline engines.
Open the "Lab Dataset"
(HSCI390.sav) you have been using for lab assignments in SPSS. Your
analysis will focus on the variables "Gender" (Gender) and "Blood
Alcohol Content at last drinking episode" (BAC).
Researchers are interested in examining if the mean Blood
Alcohol Content at last drinking episode differs between men and
women. To examine their research question of interest, they will
use data from the sample of CSUN students contained in the
HSCI390.sav dataset.
Using SPSS for the analysis, you...
The marital status distribution of the U.S. male population, age 15 and older, is as shown below. Marital Status Percent never married 31.3 married 56.1 widowed 2.5 divorced/separated 10.1 Suppose that a random sample of 400 U.S. young adult males, 18 to 24 years old, yielded the following frequency distribution. We are interested in whether this age group of males fits the distribution of the U.S. adult population at the 5% level. Calculate the frequency one would expect when surveying...
This question has 6 parts. Each of the 6 parts (Part A - Part F) has a dropdown list of possible answers. Choose the best answer from the dropdown list for EACH part of the question below. The same psychiatrists are now interested in determining if there is any difference in depression levels of participants before and after a group therapy program. Depression levels of a sample of participants both before and after the program are listed below: Patient #...
ECONOMETRICS CHAPTER 7 assignment. syllabus text book is
Introductory Econometrics Modern approach 6th edition, J
Woolsridge
i) r codes please
ii) manual calculation
qk7-is salary
edul-education level
needed in the next 4 days
Assignment Use the data of your own, answer the following questions: (i) estimate the equation: + β.gender + M z value+ What is the approximate difference in monthly income between urban and ral observations? What about female and male observations? i) Start with the original model, but...
Video Excel Online Freeforrmi Activity: According to à Wabster City was selected and then each person's milk consumption was entered into the Microsoft Excel Online fi Hypothesis Tests for the Population Mean when o Unknown dy annual per capita consumption of milk in the United States is 22.6 allons. Being from the Midwest, you believe milk consumption is higher there and wish to test your hvpothesis. A san e below, Use the data to set up your spreadshee and test...
PROJECT: The national mean annual salary for a school administrator is $90,000 a year (the Cincinnati Enquirer, April 7, 2012). A school official took a sample of 25 school administrators in the state of Ohio to learn about salaries in that state to see if they differed from the national average. The sample data for 25 Ohio administrators is contained in the excel file named Administrator. Use these data for the following questions: Q1.) Formulate hypotheses that can be used...
New corporate strategies take years to develop. Two methods for facilitating the development of new strategies by execute strategy meetings are to be compared. One method is to hold a two-day retreat in a posh hotel; the other is to hold a series of informal luncheon meetings on company premises. Excel file (HW07_Q2.xls) contains the results of two independent random samples of firms following one of these two methods. The data are the number of months for each company that...