Data is here >>…

Question Answered step-by-step Data is here >>… Data is here >> https://docs.google.com/spreadsheets/d/1JXT1LV27E_FpImVQrO-aDGU2HPAMtTR6pgzcKaAI0Fo/edit#gid=263510856 ** IMPORTANT: ONLY USE MS-EXCEL TO GENERATE REGRESSION MODEL AND DO NOT USE MINITAB TO ANSWER QUESTIONS BELOW ** PLEASE USE ONLY EXCEL FUNCTIONS Establish a regression model with Profit ($) as the dependent variable. As independent variables use all the other variables in file. Image transcription textThe variables are as follows, Order_lD A running serial number for the orders Profit The profit (in $) associatedwith an order Sales The amount of Sales (in $) for the order Discount The customer discount (in %) given forthat order [e.g. 4.00 = 4%]. Unit Price The unit price of the order in $. Shipping Cost Shipping Cos… Show more… Show more  Please estimate a regression model with Profit as the dependent variable and all other variables as independent variables. (a) Report the R-square of the estimated model(b) All else being equal, which “Ship Mode” has the maximum positive impact on profits? Briefly explain your answer.(c) Your Boss claims that for every additional dollar increase in the order [Sales], the profit goes up by 35 cents. Does your data support this claim? (d) The company believes that unit price increase per order of a dollar can be absorbed (i.e. it will not have any detrimental impact on profits) if it is accompanied by a Sales increase per order of 5 dollars. Use your data and regression to test this belief. Please briefly show your working and relevant calculations.  Math Statistics and Probability MGMT 593 Share QuestionEmailCopy link Comments (0)