Question

In: Statistics and Probability

In the spreadsheet "Salary Data" you see sample salaries of employees that were randomly selected from...

In the spreadsheet "Salary Data" you see sample salaries of employees that were randomly selected from two departments of a company. Assuming that the populations are distributed normally, conduct the appropriate test to determine whether the average salaries are different between these two departments (alpha = .05). Develop the hypotheses and report your conclusion.

Department A Department B
51000 48000
54000 54000
53000 46000
54000 48000
47000 55000
46000 52000
54000 51000
52000 46000
50000 51000
48000 48000
48000 53000
50000 47000
51000 51000
48000 45000
52000 52000
55000 46000
54000 54000
48000 47000
52000 52000
54000 47000
50000 47000
49000 49000
49000 53000
50000 49000
55000 46000
53000 53000
45000 47000
51000 54000
55000 53000
53000 53000
50000
52000
54000

Solutions

Expert Solution

NULL HYPOTHESIS H0:

ALTERNATIVE HYPOTHESIS Ha:

alpha=0.05

By using SPSS we have

From Independent sample test we can see that Equal variances are assumed since p value is greater than 0.05.

t= 1.651

P value = 0.104

Since P value is greater than 0.05 therefore NOT SIGNIFICANT.

DECISION: DO NOT REJECT H0.

Conclusion: WE DON'T HAVE SUFFICIENT EVIDENCE TO SHOW THAT THERE IS DIFFERENCE IN SALARIES.


Related Solutions

The Excel file Salary reports the monthly salaries for 93 randomly and independently selected employees of...
The Excel file Salary reports the monthly salaries for 93 randomly and independently selected employees of a bank; there are 32 salaries of male employees and 61 salaries of female employees.   Let um = the mean monthly salary for all male bank employees, and uf = the mean monthly salary for all female bank employees. Your objective is to find some evidence of um > uf, that is, the female employees are discriminated against. Provide descriptive statistical summaries of the...
The Company collected a sample of the salaries of its employees. There are 70 salary data...
The Company collected a sample of the salaries of its employees. There are 70 salary data points summarized in the frequency distribution below: Salary Number of Employees 5,001–10,000 8 10,001–15,000 12 15,001–20,000 20 20,001–25,000 17 25,001–30,000 13 Find the standard deviation. Find the variance.
The following data set is obtained by a randomly selected sample of 93 employees working at...
The following data set is obtained by a randomly selected sample of 93 employees working at a bank. SALARY EDUC EXPER TIME 39000 12 0 1 40200 10 44 7 42900 12 5 30 43800 8 6 7 43800 8 8 6 43800 12 0 7 43800 12 0 10 43800 12 5 6 44400 15 75 2 45000 8 52 3 45000 12 8 19 46200 12 52 3 48000 8 70 20 48000 12 6 23 48000 12...
The following sample observations were randomly selected:
The following sample observations were randomly selected:12345X:213832Y:18132249            a. Not available in Connect.b. Determine the regression equation.(Negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round the final answers to 4 decimal places.)                                           b =  a =Y' =  +  X           c. Determine the value of Y' whenX is 11. (Do not round intermediate calculations. Round the final answer to 4 decimal places.)
A random sample of 100 employees from 5 different companies was randomly selected, and the number...
A random sample of 100 employees from 5 different companies was randomly selected, and the number who take public transportation to work was recorded. The results are listed below. Perform a homogeneity of proportions test to test the claim that the proportion who take public transportation to work is the same in all 5 companies. Use α= 0.01. 1 2 3 4 5 Use Public Trans. 18 25 12 33 22 Don't Use Public Trans. 82 75 88 67 78...
At a local store, 65 female employees were randomly selected and it was found that their...
At a local store, 65 female employees were randomly selected and it was found that their mean monthly income was $625 with a standard deviation of $121.50. Seventy-five male employees were also randomly selected and their mean monthly income was found to be $667 with a standard deviation of $168.70. Test the hypothesis that male employees have a higher monthly income than female employees. Use α = 0.01. Use any method, however, follow the PHANTOMS acronym. P - Parameter Statement...
At a local store, 65 female employees were randomly selected and it was found that their...
At a local store, 65 female employees were randomly selected and it was found that their mean monthly income was $625 with a standard deviation of $121.50. Seventy-five male employees were also randomly selected and their mean monthly income was found to be $667 with a standard deviation of $168.70. Test the hypothesis that male employees have a higher monthly income than female employees. Use α = 0.01. Use any method, however, follow the PHANTOMS acronym. P - Parameter Statement...
Suppose the following table was generated from the sample data of 2020 employees relating annual salary...
Suppose the following table was generated from the sample data of 2020 employees relating annual salary to years of education and gender. According to the results, is there a salary difference between men and women at the 0.010.01 level of significance? If yes, write the difference in salary in the space provided, rounded to two decimal places. Else, select "There is not enough evidence." Coefficients Standard Error t Stat P-Value Intercept −12231.082830−12231.082830 2488.3280932488.328093 −4.915382−4.915382 0.0001310.000131 Education 3836.8588903836.858890 148.193548148.193548 25.89086325.890863 0.0000000.000000...
Suppose the following table was generated from the sample data of 2020 employees relating annual salary...
Suppose the following table was generated from the sample data of 2020 employees relating annual salary to years of education and gender. According to the results, is there a salary difference between men and women at the 0.010.01 level of significance? If yes, write the difference in salary in the space provided, rounded to two decimal places. Else, select "There is not enough evidence." Coefficients Standard Error t Stat P-Value Intercept −6351.081919 2302.895692 −2.757868 0.013444 Education 3487.0714766 133.810154 26.059842 0.000000...
The following data represent the salaries (in thousands of dollars) of a sample of 13 employees...
The following data represent the salaries (in thousands of dollars) of a sample of 13 employees of a firm: 26.5, 23.5, 29.7, 24.8, 21.1, 24.3, 20.4, 22.7, 27.2, 23.7, 24.1, 24.8, and 28.2. Calculate the interquartile range. What does this tell you about the data? Show your work. Describe the shape of distribution of salaries of employees of the firm based on the values of the quartiles. Give a possible reason for the shape of this data set, in terms...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT