+ ONE G H Run a multiple linear regression analysis by following below instructions Code the categorical vanable "Purchased Code Used as 1 and New as 0, New is the reference level 2 Code the categorical variable Type Type can take 5 values add 4 (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 worksheets) 5 7 8 Type Purchased Vehicle Age MPG 9 Mid-size SUV Used 15 28 7 10 Mid-Size SUV New 1 43.4 11 Small car New 7 24 12 Large SUV Used 14 152 13 Small car New 2 37 14 Minivan New 9 20 15 Small car Used 6 45.7 16 Small car New 42 17 Smallcar Used 13 33 18 Small Car New 7 31 19 Mirvan Used 14 12 20 Small SUV Used 13 20 21 Small car New 2 28 22 Mid-Size SUV New 025 283 23wge SUV New 7 21 24 Small car Used 10 35 25 Small New 5 304 26 Midze New 0.5 402 27 Smacar Used 10 30 28 Small SUV New 4 24.9 29 Small SUV Used 14 21 30 Small car Used 12 31 31 Midsize SUV Used 12 27 32 33 37 38