The Auto Survey data set. The data set contains survey information gathered from a few customers. MPG is the dependent variable. Type, Purchased, Vehicle Age and Mileage are independent variables. Tt is required to construct multiple linear regression model and correlation matrix for this dataset to answer questions.

For the Auto Survey data set, what is the minimum number of dummy variable/variables required to analyze the Gender variable? Select one: O a. 2 O b. Insufficient data to answer this question O c. 1 O d. 3Auto Survey Gender Type Purchased Vehicle Age Mileage MPG Male Mid-size Used 15 127233 28.7 Female Mid-size New 23970 43.4 Male Small New 7 77392 24 Female Large SUV Used 14 185397 15.2 Female Small New 2 26001 37 Female Minivan New 9 180643 20 Male Small Used 6 72083 45.7 Male Small New 11 165353 42 Male Small Used 13 205288 33 Female Small New 7 142897 31 Male Minivan Used 14 182584 12 Male Small SUV Used 13 140479 20 Female Small New 2 22114 28 Female Mid-size New 0.25 3454 28.3 Female Large SUV New 7 130905 21 Female Small Used 10 105628 35 Female Small New 5 48678 30.4 Male Mid-size New 0.5 6849 40.2 Female Small Used 10 137941 30 Female Small SUV New 4 29823 24.9 Male Small SUV Used 14 85763 21 Female Small Used 12 134172 31 Male Mid-size Used 12 86387 27For the Auto Survey data set, a multiple regression model created with Independent variables Vehicle Age and Mileage against dependent variable MPG is a statistically significant model with respect to F and significance F. (Threshold for F = 4 and Sig F = 0.05) Select one: O True O False For the Auto Survey data set, create a multiple regression model created with Independent variables "Vehicle Age", "Mileage" and categorical variable "Purchased" against dependent variable MPG. What is the predicted (rounded up) MPG when Vehicle Age = 2 , Mileage=3000 and the car is new? (Convert "Purchased" to dummy variable) Select one: O a 34 O b. 31 (RS O d. 28 For the Auto Survey data set, a multiple regression model created with Independent variables "Vehicle Age", "Mileage" and categorical variable "Type" against dependent variable MPG is a statistically significant model with respect to F and significance F. (Convert "Type" to dummy variables) (Threshold for F = 4 and Sig F = 0.05) Select one: O True O False For the Auto Survey data set, a multiple regression model created with Independent variables "Vehicle Age", "Mileage" and categorical variable "Purchased" against dependent variable MPG is a statistically significant model with respect to F and significance F. (Convert "Purchased" to dummy variable) (Threshold for F = 4 and Sig F = 0.05) Select one: O True O False