Answered step by step
Verified Expert Solution
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?
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 310Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started