PLEASE SHOW WORK WITH FORMULAS !!!!!!!!!

NO G H Run a multiple linear regression analysis by following below instructions Code the categoncal vanable. Purchased Code Used as 1 and New as 0, New is the reference level Code the categorical variable Type Type can take 5 values, add (which is 5-1) columns in the dataset Choose Small car as Reference Level Run a linear regression analysis MPG is dependent variable, the coded columns "purchased" and "Type" are independent variables 5 Show the results in new worksheet(s) 5 7 8 Type Purchased Vehicle Age MPG 9 Mid-size SUV Used 15 287 10 Mid-Size SUV New 1 43.4 11 Small Car New 7 24 12 Large SUV Used 14 15 2 13 Small Car New 37 14 Minivan New 20 15 Small car Used 457 16 Small car New 11 42 17 Smallcar Used 13 33 18 Small Car New 7 31 19 Mirwan Used 14 12 20 Small SUV Used 13 20 21 Small cor New 2 28 22 Mid-Size SUV New 025 283 23 Lage SUV New 7 21 24 Smallcar Used 10 35 25 Small Car New 5 304 26 Midsize Now 0.5 402 27 Small car Used 10 30 28 Small SUV New 4 24.9 29 Small SUV Used 14 21 30 Small car Used 12 31 31 Mid-Size SUV Used 12 27 32 33 37 38