One of your clients is a sales manager in charge of sales territories scattered around the US. The sales manager collects data on five variables for each sales territory. They are Sales, Territory Rating, Advertising Expenditures, Number of New Accounts and Market Potential. The sales manager wants you to determine if any of the Independent Variables help to explain the level of annual sales for each of her territories.

Design: Your client wants you to study the importance of each of the Independent variables in understanding why Annual Sales vary among her sales territories.

Using Version 2 of the SSP, complete the following:

1. Complete all preliminary steps for correlation analysis.
2. Note that scatter plots are useful in determining patterns between two variables. Use the scatter plot option to display the data patterns for each IV with the DV (Sales). The name (definition) of each IV is shown right above the data.
3. Next, use the correlation option to build a correlation table for all 5 variables. Include all 5 variables in one correlation table.
4. Discuss your findings and conclusions. ?Are any of the relationships (e.g., X1 with Y, X2 with Y, and so on) statistically significant? How do you know this? Be sure to show your work.

Using Version 3 of the SSP, complete the following:

1. Complete all preliminary steps for regression analysis.
2. Next, use the regression option to run a multi-variate regression model using those IVs that are statistically significant. Run as many multivariate models as necessary.
3. Discuss your findings and conclusions. Which Independent Variables successfully explained a significant amount of variation in the Dependent Variable (Sales)? How strong is the final model?
4. Finally, what will you tell your client?

Transcribed Image Text:

Territory Rating 1.1 4.9 1.2 5.1 1.3 2.9 1.4 3.4 1.5 4.6 2.1 5.2 2.2 4.1 2.3 2.3 3.1 3.9 3.2 2.8 3.1 4.2 4.3 4.2 2.5 wwww 3.3 3.4 4.1 4.2 5 6.1 6.2 6.3 6.4 6.5 7.1 7.2 7.3 8.1 8.2 9.1 9.2 10 11 12 13 14 3) c 3.6 3.4 5.6 3.6 3.1 2.6 3.4 2.7 2.8 3.9 4.1 2.3 3.9 2.8 3.1 2.2 36 Adver Accts $2,583 $3,540 $2,950 $5,243 $7,747 $3,141 $7,141 $2,086 $8,846 $5,673 $2,762 $1,992 $1,972 $1,737 $10,694 $4,619 $7,748 $4,566 $6,023 $4,721 $3,861 $3,572 $2,846 $5,060 $3,552 $7,141 $2,086 $8,846 $5,673 $2,762 $10,694 S4 619 MktPoten 75 $74,065 $58,117 237 132 $21,118 195 $68,521 198 $67,805 185 $37,807 296 $40,935 127 $35,602 288 $46,177 166 $42,053 116 $36,830 142 $33,613 89 $21,413 146 $20,417 308 $36,272 80 $23,093 201 $26,879 185 $39,572 249 $51,866 138 $48,750 55 $23,991 153 $25,695 101 $23,736 188 89 $34,314 $22,810 $40,935 $35,602 $46,177 166 $42,053 116 $36,830 308 $36,272 80 $23.093 296 127 288 Sales $3,670 $3,474 $2,295 $4,676 $6,126 $2,135 $5,032 $3,367 $6,519 $4,876 $2,468 $2,533 $2,408 $2,337 $5,668 $2,729 $3,289 $2,801 $3,264 $3,454 $1,741 $2,036 $1,578 $4,167 $2,800 $5,032 $3,367 $6,519 $4,876 $2,468 $5,668 $2 729 Territory Rating 1.1 4.9 1.2 5.1 1.3 2.9 1.4 3.4 1.5 4.6 2.1 5.2 2.2 4.1 2.3 2.3 3.1 3.9 3.2 2.8 3.1 4.2 4.3 4.2 2.5 wwww 3.3 3.4 4.1 4.2 5 6.1 6.2 6.3 6.4 6.5 7.1 7.2 7.3 8.1 8.2 9.1 9.2 10 11 12 13 14 3) c 3.6 3.4 5.6 3.6 3.1 2.6 3.4 2.7 2.8 3.9 4.1 2.3 3.9 2.8 3.1 2.2 36 Adver Accts $2,583 $3,540 $2,950 $5,243 $7,747 $3,141 $7,141 $2,086 $8,846 $5,673 $2,762 $1,992 $1,972 $1,737 $10,694 $4,619 $7,748 $4,566 $6,023 $4,721 $3,861 $3,572 $2,846 $5,060 $3,552 $7,141 $2,086 $8,846 $5,673 $2,762 $10,694 S4 619 MktPoten 75 $74,065 $58,117 237 132 $21,118 195 $68,521 198 $67,805 185 $37,807 296 $40,935 127 $35,602 288 $46,177 166 $42,053 116 $36,830 142 $33,613 89 $21,413 146 $20,417 308 $36,272 80 $23,093 201 $26,879 185 $39,572 249 $51,866 138 $48,750 55 $23,991 153 $25,695 101 $23,736 188 89 $34,314 $22,810 $40,935 $35,602 $46,177 166 $42,053 116 $36,830 308 $36,272 80 $23.093 296 127 288 Sales $3,670 $3,474 $2,295 $4,676 $6,126 $2,135 $5,032 $3,367 $6,519 $4,876 $2,468 $2,533 $2,408 $2,337 $5,668 $2,729 $3,289 $2,801 $3,264 $3,454 $1,741 $2,036 $1,578 $4,167 $2,800 $5,032 $3,367 $6,519 $4,876 $2,468 $5,668 $2 729