The manager of a company that relies on traveling salespersons to sell the company’s products wants to examine the relationship between sales and the amount of time a salesperson spends with each established customer who regularly orders the company’s products. the manager collects data on 12 salespersons. saleshours spent with customers4123.25004.64503.96105.371 56.15004.26105.66005.35705.18007.17 256.58507.8what is the dependent and independent variables for this problem? make a scatterplot for predicting sales from hours spentrun regression analysis using excel with the data from the above table. upload the excel file with your submission. write down the regression equation to predict sales. what would be the predicted sales if the salesperson spent 5 hours with the customer?