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.

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.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.5: Correlation And Causation

Problem 2AGP

See similar textbooks

Related questions

Topic Video

Question

100%

A
B
E
F
G
H
J
K
M
P
Q
R
U
4
5.
Consider the following data generated by Company A in reviewing its Sales/Marketing operations and various sales represtative in a major market.
AdvExp
Sales
Seniority
MrktSz
Share
Rating
3.4
6
Econlndex
4675.56
186. 18
68521.3
2243.1
8.27
13.40
8
6125.96
161.79
57805.1
7747.1
9.15
4.6
17.64
9
2134.94
8.94
37806.9
402.4
5.51
4.5
16.22
10
5031.66
365.04
50935.3
3140.6
8.54
4.6
18.80
11
3367.45
220.32
35602.1
2086.2
7.07
2.3
19.86
12
6519.45
127.64
46176.8
8846.2
12.54
4.9
17.42
5673.1
2761.8
13
4876.37
105.69
42053.2
8.85
2.8
21.41
14
2468.27
57.72
36829.7
5.38
3.1
16.32
15
2533.31
23.58
33612.7
1991.8
5.43
4.2
14.51
16
2408.11
13.82
21412.8
1971.5
8.48
4.3
19.35
2337,38
20.02
15.26
17
13.82
20416.9
1737.4
7.80
4.2
10.34
36272.0
23093.3
18
4586.95
86.99
10694.2
5.5
2729.24
3289.40
19
165.85
8618.6
5.15
3.6
15.87
20
116.26
26878.6
7747.9
6.64
3.4
7.81
21
2800.78
42.28
39572.0
4565.8
5.45
4.2
16.00
22
3264.20
52.84
51866.1
6022.7
6.31
3.6
17.44
23
3453.62
165.04
58749.8
3721.1
6.35
3.1
17.98
24
1741.45
10.57
23990.8
861.0
7.37
1.6
20.99
25
2035.75
13.82
25694.9
3571.5
8.39
3.4
21.66
26
1578.00
8.13
23736.3
2845.5
5.15
2.7
21.46
27
4167.44
58.44
34314.3
5060.1
12.88
2.8
25.78
28
2799.97
21.14
22809.5
3552.0
9.14
3.9
24.96
29
The variables are:
SALES are the total sales oredited 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
RATING is the sales representative's overall rating based on eight performance dimensions on an aggregate rating scale of 1-7.
30
31
32
33
34
35
36
37
A. Assume an a 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 oan the oompany expect for a sales representative given the following data:
38
39
40
41
SENIORITY
87.0
42
MRKTSZ
38858.1
43
ADVEXP
4357.0
44
SHARE
7.6
45
RATING
3.7
46
ECONINDEX
18.1
47
C. When the company uses this model to predict prefromance what MAPE should the company expect based on the historical data?
48
Short Answer
Part II Instructions
Problem 1
Problem 2
Problem 3
Enter
囲
67

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Hypothesis Tests and Confidence Intervals for Means$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill