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.

The variables are as follows, Order_lD A running serial number for the orders Profit The profit (in $) associated with an order Sales The amount of Sales (in $) for the order Discount The customer discount (in %) given for that order [e.g. 4.00 = 4%]. Unit Price The unit price of the order in $. Shipping Cost Shipping Cost in $ Ship Mode The mode of shipping [Regular Air, Delivery Truck, Express Air] Order Priority The priority attached to the order [ Low, High] Customer The customer segment [Consumen Corporate, Home Office, Small Segment Business] Product [Furniture, Office Supplies, Technology] Category