Which Python module and method are used to create a multiple regression model for a given data set? Select one. linregress method from scipy module ols method from statsmodel module ols method from scipy module O linregress method from statsmodel module

We expect a car's highway gas mileage to be related to its city gas mileage (in miles per gallon, mpg). Data for all 1259 vehicles in the government's 2019 Fuel Economy Guide give the regression line highway mpg = 8.720+ (0.914x city mpg) for predicting highway mileage from city mileage. O Macmillan Learning (c) Find the predicted highway mileage, y, for a car that gets 14 mpg in the city. Give your answer to three decimal places. y = mpg Find the predicted highway mileage, y, for a car that gets 21 mpg in the city. Give your answer to three decimal places. y = mpg

RequiredPage 92 The company uses the number of professional hours as the cost driver for office support costs. Use an algebraic equation to describe how total office support costs can be ­estimated. Use a spreadsheet program to perform a regression analysis. Use office support costs as the dependent variable (Y) and the professional hours as the independent variable (X). Determine the total fixed cost per office and variable cost per professional hour. Identify the R2 statistic provided by the Excel program and explain what it means. Mr. Dean plans to open a new branch office in a Dallas suburb. He expects that the monthly professional hours will be 3,000. Estimate the total office support cost for Mr. Dean. What portion of the total cost is fixed and what portion is variable? Explain how multiple regression analysis could be used to improve the accuracy of the cost estimates.   *You will use excel to setup a worksheet with your data and run regression analysis.*

please assist with this non graded assisnment. A tutor provided me with incorrect answers so I am resubmitting my question.