Consider the following data generated by Company A in reviewing its SalesIMarketing operations and various sales represtative in a major market. AdvExp 2243.1 7747.1 402.4 Sales 4675.56 6125.96 2134.94 503166 Seniority 186. 18 16179 8.94 MrktSz 68521.3 57805.1 37806.9 Share 8.27 9.15 5.51 8.54 7.07 12.54 8.85 5.38 5.43 Rating 3.4 4.6 4.5 Econlndex 13.40 17.64 16.22 3367.45 6519.45 4876.37 2468.27 365.04 220.32 127.64 105.69 57.72 50935.3 35602.1 46176.8 3140.6 2086.2 8846.2 5673.1 27618 4.6 2.3 4.9 2.8 3.1 18.80 19.86 17.42 21.41 16.32 14.51 42053.2 36829.7 2533.31 2408. 11 2337.38 4586.95 2729.24 23.58 13.82 13.82 86.99 165.85 116.26 33612.7 21412.8 20416.9 36272.0 23093.3 19918 19715 1737.4 10694.2 8618.6 7747.9 4.2 4.3 4.2 5.5 3.6 3.4 8.48 7.80 10.34 19.35 20.02 15.26 15.87 7.81 5. 15 6.64 5.45 6.31 6.35 7.37 8.39 5.15 26878.6 39572.0 3289.40 2800. 78 3264.20 3453.62 174145 2035. 75 42.28 52.84 165.04 4565.8 6022.7 37211 8610 35715 2845.5 5060.1 3552.0 4.2 3.6 3.1 16 3.4 51866.1 58749.8 16.00 17.44 17.98 10.57 23990.8 25694.9 20.99 2166 21.46 25.78 24.96 13.82 1578.00 4167.44 2799.97 The variables are: 8. 13 58.44 21.14 23736.3 34314.3 22809.5 2.7 2.8 3.9 12.88 9.14 SALES are the total sales credited to a individual sales representative. SENIORITY is the length of time a sales reprsentative has been employed (in months) MRKTSZ is market potential total sales in units for the sales territory ADVEXP are the advertising expenditures in the market. SHARE is the company's market share (weighted for the last 4 years) ECONINDEX is the weighted index of local economic activity RATINGIS the sales representative's overall rating based on eight performance dimensions on an aggregate rating scale of 1-7. A Assume ana equals 0.05 and using "Backward Elimination" develop an equation (forecasting equation) relating the Sales to all relevant variables in the data above. What is that regression (forecasting) equation? What% of the variation in the data does this equation explain? B. What sales level can the company expect for a sales representative given the following data: SENIORITY 87.0 MAKTSZ ADVEXP SHARE RATING ECONINDEX 38858.1 4357.0 7.6 3.7 18.1 C. When the company uses this model to predict prefromance what MAPE should the company expect based on the historical data? 325co42 242 32.