The Assignment 8 Data File contains sales data for three salesmen (Tina, Mark, Leo) and three methods (Internet, Face-to-Face, Telephone). Construct a multivariate graph and determine how you would increase sales.
| Salesperson & Method |
Sales (Units) |
| T Int |
65 |
| T Int |
75 |
| T Int |
76 |
| M Int |
66 |
| M Int |
65 |
| M Int |
76 |
| L Int |
68 |
| L Int |
69 |
| L Int |
64 |
| T FF |
88 |
| T FF |
85 |
| T FF |
93 |
| M FF |
91 |
| M FF |
94 |
| M FF |
89 |
| L FF |
87 |
| L FF |
84 |
| L FF |
90 |
| T Tel |
45 |
| T Tel |
47 |
| T Tel |
49 |
| M Tel |
49 |
| M Tel |
46 |
| M Tel |
40 |
| L Tel |
39 |
| L Tel |
48 |
| L Tel |
43 |
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| T = Tina |
|
| M = Mark |
|
| L = Leo |
|
| |
|
| |
|
| INT - = Internet |
|
| FF = Face to Face |
|
| TEL = Tel |
|
| |
|
| |
|
| There are three sales point for each combination |
|
Attachment:- Assignment 8.xlsx