Question: A data analyst wants to use regression analysis to see if an employee's salary is related to her/his education level. Employees are categorized into 3

A data analyst wants to use regression analysis to see if an employee's salary is related to her/his education level. Employees are categorized into 3 education levels, 1, 2 and 3. A higher code reflects more education. The analyst codes Ed_2 and Ed_3 for education levels 2 and 3 and obtains the following regression results.

SUMMARY OUTPUT Regression Statistics Multiple R 0.452495 R Square 0.204752 Adjusted R Square 0. 196993 Standard Error 10.08671 Observations 208 ANOVA SS MS F Significance F Regression 2 5370.043 2685.022 26.39055 6.33192E-11 Residual 205 20857.06 101.7418 Total 207 26227.11 Coefficientstandard Er t Stat P-value Lower 95% Upper 95% Intercept 36 23119 0.871359 41.58009 7.3E-102 34.51321981 37.94916825 Ed 2 5.206306 3.671102 1.418186 0.157655 -2.031648074 12.44426001 Ed 3 11.00032 1.516842 7.252122 8.25E-12 8.009711869 13.99093037

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

A data analyst wants to use regression analysis to see if an employees salary is related to her/his education level. Employees are categorized into 3 education levels, 1, 2 and 3. A higher code...

A data analyst wants to use regression analysis to see if an employee's salary is related to her/his education level. Employees are categorized into 3 education levels, 1, 2 and 3. A higher code...

a data analyst wants to use regresion analysis to see if an emplyoees salary is related to her / his education level. employees are categorized into 3 education levels, 1 , 2 and 3 . a higher code...

READ THE FOLLOWING ARTICLE AND ANSWER THE FOLLOWING QUESTIONS BELOW: Describe the article in one or two paragraphs and include: 1. Purpose of the paper 2. Brief description of methodology - sample...

Predicting Cost from Mileage 80000 y = -0.1725x + 24765 70000 r2 = .0204 60000 50000 Cost of Car 40000 30000 20000 10000 O O 10000 20000 30000 40000 50000 60000 MileageRegina owns a small car...

Discussion Board 4 Production Economics and Decisions...

The following is a summary of some of the major phases, or steps, of the data analytics life cycle: Business understanding This phase is also known as the discovery phase. During this phase, an...

Discussion Board Week 2 1. "Estimating Demand and Its Elasticities" and Statistical Estimation of the Demand Curve During the Weekly Scenarios Herb Jones, a graduate student and part-time data...

10 Sunrise Hotels (A) Case Background and Site Description You have been hired by the general manager (GM) of a budget hotel in Colorado. The hotel is part of a large economy lodging chain in North...

Radisson Company requires additional cash for its business. Radisson has decided to use its accounts receivable to raise the additional cash and has asked you to determine the income statement...

The annualized Indian rupee (INR) interest rate is 10% for six months, while the annualized USD interest rate is 3% for six months. Khaledi Co., a U.S. firm, entered into a currency swap with a swap...

Bicycles parts are manufactured in the Molding Department and tranderred to the Assembly Department where they are partially assembled. Ather assembly, the bicycle is sent to the Packing Department....

Prepare Natura Co.s journal entries to record the following transactions involving its short-term investments in held-to-maturity debt securities, all of which occurred during the current year. a. On...