Question

In: Statistics and Probability

Suppose the following table was generated from sample data of 20 20 employees relating hourly wage...

Suppose the following table was generated from sample data of 20 20 employees relating hourly wage to years of experience and whether or not they have a college degree. Using statistical software, create an indicator (dummy) variable for the variable "Degree" and find the regression equation. Is there enough evidence to support the claim that on average employees with a college degree have higher hourly wages than those without a college degree at the 0.05 0.05 level of significance? If yes, write the coefficient of the dummy variable in the space provided, rounded to two decimal places. Else, select "There is not enough evidence." Copy Data Hourly wages of employees Wage Experience Degree 15.06 15.06 12 12 No 21.00 21.00 16 16 Yes 22.05 22.05 17 17 Yes 17.19 17.19 20 20 No 15.51 15.51 14 14 No 18.65 18.65 23 23 No 28.44 28.44 28 28 Yes 1.95 1.95 1 1 Yes 13.58 13.58 9 9 Yes 13.60 13.60 8 8 No 13.43 13.43 9 9 No 32.16 32.16 28 28 Yes 19.55 19.55 27 27 No 17.04 17.04 19 19 No 22.39 22.39 17 17 Yes 16.85 16.85 19 19 No 15.66 15.66 10 10 Yes 18.30 18.30 13 13 Yes 16.00 16.00 16 16 No 22.21 22.21 17 17 Yes

Solutions

Expert Solution

There is enough evidence to support the claim that on average employees with a college degree have higher hourly wages than those without a college degree at the 0.05 level of significance

following regression analysis information has been generated using ms-excel. here wage is used as dependent or response variable and experience and degree as independent variable or predictor .

here degree is transformed into coded variable Yes=1, No=0

since the p-value=0.0026 of the independent variable Degree is less than typical significance level alpha=0.05, (and also it is positive 4.3137 ) so there is significant difference between the level of degree (yes or no ) and conclude that there is enough evidence to support the claim that on average employees with a college degree have higher hourly wages than those without a college degree at the 0.05 level of significance

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.908152055
R Square 0.824740155
Adjusted R Square 0.80412135
Standard Error 2.723334927
Observations 20
ANOVA
df SS MS F Significance F
Regression 2 593.3155769 296.6578 39.99942 3.7265E-07
Residual 17 126.0814031 7.416553
Total 19 719.39698
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 3.721360978 1.714909235 2.170005 0.044467 0.103218792 7.339503165
experience 0.752493355 0.088801777 8.473855 1.65E-07 0.565137984 0.939848725
degree 4.31374269 1.221823387 3.530578 0.002568 1.735920699 6.891564682

Related Solutions

Suppose the following table was generated from sample data of 20 employees relating hourly wage to...
Suppose the following table was generated from sample data of 20 employees relating hourly wage to years of experience and whether or not they have a college degree. Using statistical software, create an indicator (dummy) variable for the variable "Degree" and find the regression equation. Is there enough evidence to support the claim that on average employees with a college degree have higher hourly wages than those without a college degree at the 0.05 level of significance? If yes, write...
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 file Assign1_Data contains data on the hourly wages (Hourly Wage) of all employees of a...
The file Assign1_Data contains data on the hourly wages (Hourly Wage) of all employees of a grocery chain in the Ottawa region. (a) Treating this set of data as the population, use Minitab to calculate the population mean and the population standard deviation for the Hourly Wage variable. (b) Examine a boxplot and histogram of the population data. Explain if the means of all possible random samples of size 40 from this population would form a normal distribution. (c) Using...
The following table was generated from the sample data of 10 junior high students regarding the...
The following table was generated from the sample data of 10 junior high students regarding the average number of hours they are unsupervised per night, the average number of hours they play video games per night, and their final grades in their math class. The dependent variable is the final grade, the first independent variable (x1) is the number of hours unsupervised each night, and the second independent variable (x2) is the number of hours of video games each night....
The following table was generated from the sample data of 10 college students regarding the number...
The following table was generated from the sample data of 10 college students regarding the number of parking tickets the student receives in a semester, the student's age, and the student's GPA. The dependent variable is the student's GPA, the first independent variable (x1) is the number of parking tickets, and the second independent variable (x2) is the student's age. Intercept   2.120785   2.284291   0.928421   0.395800 Number of Parking Tickets   -0.337479   0.066991   -5.037686   0.003975 Student's Age   0.127003   0.116260   1.092403   0.324473 Step...
Access the hourly wage data on the below Excel Data File (Hourly Wage). An economist wants...
Access the hourly wage data on the below Excel Data File (Hourly Wage). An economist wants to test if the average hourly wage is less than $28. Assume that the population standard deviation is $8. b-1. Find the value of the test statistic. (Negative value should be indicated by a minus sign. Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) Hourly Wage Education Experience Age Gender 39.00 11 2 40 1 21.02...
The monthly and hourly wage schedule for the employees of Quirk, Inc., follows. No employees are...
The monthly and hourly wage schedule for the employees of Quirk, Inc., follows. No employees are due overtime pay. Round your answer to nearest cent. Compute the following for the last monthly pay of the year: a. The total wages of each part-time employee for December 2018. b. The OASDI and HI taxable wages for each employee. c. The FICA taxes withheld from each employee's wages for December. d. Totals of columns. (Totals should include both full-time and part-time employees.)...
Suppose the following data were collected from a sample of 1515 CEOs relating annual salary to...
Suppose the following data were collected from a sample of 1515 CEOs relating annual salary to years of experience and the economic sector their company belongs to. Use statistical software to find the following regression equation: SALARYi=b0+b1EXPERIENCEi+b2SERVICEi+b3INDUSTRIALi+eiSALARYi=b0+b1EXPERIENCEi+b2SERVICEi+b3INDUSTRIALi+ei. Is there enough evidence to support the claim that on average, CEOs in the service sector have lower salaries than CEOs in the financial sector at the 0.050.05 level of significance? If yes, write the regression equation in the spaces provided with answers...
Suppose the following data were collected from a sample of 15 CEOs relating annual salary to...
Suppose the following data were collected from a sample of 15 CEOs relating annual salary to years of experience and the economic sector their company belongs to. Use statistical software to find the following regression equation: SALARYi=b0+b1EXPERIENCEi+b2SERVICEi+b3INDUSTRIALi+ei Is there enough evidence to support the claim that on average, CEOs in the service sector have lower salaries than CEOs in the financial sector at the 0.01 level of significance? If yes, write the regression equation in the spaces provided with answers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT