I DO NOT NEED SPECIFIC ANSWERS, I JUST NEED TO KNOW WHAT I HAVE TO DO TO GET THE ANSWER. PLEASE AND THANK YOU.

2. a. Education needs to be coded into dummy variables (1 and 0's).Each individual should fit into one of the following groups: no degree, GED/diploma, bachelor's degree, Masters or doctorate, all others.Let me know which is your reference group - you do not include the reference group as an independent variable in the model!

b. Run a regression to predict the annual out of pocket expenditures for an individual using the following equation.

Out of pocket expenditures=Constant+education+has private insurance+expected total payments+total family income

c. Which variables are significant?

N H J K L M O P Q R A B C D E F G WORKEV FTOTVAL HEALTH ACCESSEL USUALPL TYPPLSICK HIPRIVAT HICHAMP HIMACHI HIMCA 1 YEAR MEPSID RACEA HISPETH EDUC EDUCYR STUDENT HIDEG 1 10 601 17 6 51 0 182202 2016 1E+09 100 2016 1E+09 100 10 301 12 6 30 0 182202 6 96 182202 G UA W N 2016 1E+09 100 10 109 8 6 182202 2016 100 10 6 96 1E+09 107 O 2016 1E+09 200 10 301 12 6 30 2016 1E+09 200 10 203 11 10 53 27994 2016 1E+09 200 10 604 14 2016 1.0018+09 200 10 604 14 53 215586 215586 10 2016 1.001E+09 200 10 603 17 52 96 0 215586 11 2016 1.0018+09 200 10 104 10 301 12 30 12 2016 1.0016+09 100 13 2016 1.0016+09 100 10 401 13 30 51765 45958 14 2016 1.0018+09 100 10 203 11 10 2016 1.0016+09 100 10 203 11 10 45958 15 45958 16 2016 1.0018+09 100 10 201 9 10 17 2016 1.001E+09 100 10 105 4 96 45958 18 2016 1.0016+09 100 10 104 3 96 45958 2 96 45958 ! ! I N N B N N P P P P B B B B N N N N N N N N P B B B B B N N B B B P HOW O N N O O O W W P K O B B N O O O O O B W O S O $ W B B W O O K P 19 2016 1.0016+09 100 10 103 96 45958 20 2016 1.0016+09 100 10 109 12 20 45958 21 2016 1.0016+09 100 10 302 16 40 91950 22 2016 1.0018+09 100 10 500 16 40 91950 23 2016 1.0018+09 100 10 500 10 96 96 91950 24 2016 1.0016+09 100 51 316442 25 2016 1.001E+09 100 10 601 17 26 2016 1.0016+09 100 10 603 17 52 316442 2016 1.001E+09 100 10 601 17 51 47715 27 301 45800 28 2016 1.002E+09 100 20 12 30 10 45800 29 2016 1.0026+09 100 20 201 9 10 96 96 45800 30 2016 1.002E+09 100 31 2016 1.0028+09 100 10 109 8 96 45800 10 32 2016 1.002E+09 100 20 104 3 33280 33 2016 1.002E+09 200 10 401 15 30 33838 9 96 33838 34 2016 1.0026+09 200 10 201 100 10 500 16 40 55921 35 2016 1.002E+09 100 10 17 55921 2016 1.002E+09 601 51 36 10 302 10 20 8400 37 2016 1.0026+09 100