Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am completing a multiple linear regression model for a group project. The group picked average salary broken down by year (from 2010 - 2020),

I am completing a multiple linear regression model for a group project. The group picked average salary broken down by year (from 2010 - 2020), sex, and education level. The screenshot shows how the data is currently set up in Excel. Does the data look ok to run a regression in Excel? And do the year need to be broken down in to dummy variables as well?

image text in transcribed
K P A B C D E F G H M N O Q Year Sex Sample Size Education Avg. Salary Gender 1 Edu1 Edu2 Edu3 Edu4 Edu5 Edu6 Edu7 Edu8 Legend 1 is 2010 Male 2,977 Less Than 9th Grade $23,861 1 0 Gender Male 2010 Male 5,451 9th to 12th Nongrad $24,941 Edu 1 Less Than 9th Grade 2010 Male 24,076 High School Grad $36,281 Edu 2 9th to 12th Nongrad OOO HOO 2010 Male 15,022 Some College (No Degree) $38,663 Edu 3 High School Grad 2010 Male 6,956 Associate Degree $46,722 Edu 4 Some College (No Degree) 2010 Male 16,486 Bachelor's Degree $69,764 Edu 5 Associate Degree 2010 Male 5,909 Master's Degree $88,111 Edu 6 Bachelor's Degree 2010 Male 1,533 Professional Degree $147,344 Edu 7 Master's Degree 2010 Male 1,537 Doctorate Degree $118,855 Edu 8 Professional Degree 2010 Female 1,556 Less Than 9th Grade $14,986 Not Coded Doctorate Degree 2010 Female 3,556 9th to 12th Nongrad $14,974 o o o o O O I O o O O O O O O H O O O 0 0 O O O O O O O O K O O O O O O O O KO 0 0 p o o o o P o o o o o 0 0 0 K O o o 0 0 0 0 P O O O O O O O K O O O O O O O O K O O O O P O O O O O H O O O O O O O O H O OO OO C 2010 Female 18,574 High School Grad $24,153 2010 Female 15,177 Some College (No Degree) $25,245 2010 Female 8,449 Associate Degree $33,194 2010 Female 15,885 Bachelor's Degree $45,015 2010 Female 6,780 Master's Degree $59,428 2010 Female 850 Professional Degree $110,322 2010 Female 973 Doctorate Degree $83,926 2011 Male 2,930 Less Than 9th Grade $24,711 2011 Male 5,430 9th to 12th Nongrad $25,395 2011 Male 23,801 High School Grad $38,679 2011 Male 15 168 Coma Collage /Mo Damreal can 310

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie

12th Edition

1260819426, 9781260819427

Students also viewed these Mathematics questions

Question

1. Background knowledge of the subject and

Answered: 1 week ago