Question: Hello, I need assistance with completing a descriptive analysis using the following data. Need a chart to make it show how competitors distance influences monthly
Hello, I need assistance with completing a descriptive analysis using the following data. Need a chart to make it show how competitors distance influences monthly profit.
| Store | Store Size | Competitors within 2 Miles | Competitors within 5 Miles | Competitors within 15 Miles | Monthly Profit |
| 1 | L | 2 | 2 | 9 | $21,456 |
| 2 | S | 1 | 4 | 10 | $7,015 |
| 3 | VL | 4 | 7 | 19 | $14,640 |
| 4 | M | 0 | 1 | 9 | $20,493 |
| 5 | L | 3 | 3 | 11 | $16,138 |
| 6 | VL | 4 | 8 | 15 | $25,676 |
| 7 | VL | 5 | 9 | 15 | $712 |
| 8 | VL | 3 | 6 | 13 | $28,045 |
| 9 | VL | 3 | 7 | 16 | $33,255 |
| 10 | VL | 5 | 9 | 19 | $22,866 |
| 11 | VL | 4 | 5 | 16 | $19,235 |
| 12 | VL | 3 | 5 | 16 | $19,485 |
| 13 | VL | 5 | 6 | 19 | $9,018 |
| 14 | M | 2 | 6 | 9 | $6,154 |
| 15 | VL | 5 | 6 | 15 | $12,757 |
| 16 | L | 2 | 6 | 8 | $22,800 |
| 17 | L | 3 | 4 | 14 | $6,076 |
| 18 | VL | 4 | 8 | 16 | $15,341 |
| 19 | L | 3 | 4 | 12 | $14,520 |
| 20 | L | 3 | 4 | 7 | $11,642 |
| 21 | VL | 5 | 6 | 13 | $19,230 |
| 22 | M | 1 | 4 | 5 | $17,119 |
| 23 | L | 2 | 4 | 6 | $17,567 |
| 24 | VL | 4 | 8 | 19 | $7,738 |
| 25 | VL | 3 | 4 | 10 | $19,693 |
| 26 | M | 0 | 1 | 8 | $19,871 |
| 27 | M | 2 | 5 | 14 | $18,305 |
| 28 | L | 2 | 3 | 12 | $23,463 |
| 29 | L | 4 | 4 | 11 | $12,623 |
| 30 | VL | 3 | 3 | 6 | $21,995 |
| 31 | VL | 5 | 8 | 20 | $4,565 |
| 32 | L | 3 | 5 | 11 | $6,366 |
| 33 | VL | 5 | 8 | 13 | $18,805 |
| 34 | VL | 4 | 4 | 15 | $21,421 |
| 35 | L | 3 | 7 | 10 | $8,715 |
| 36 | M | 4 | 8 | 13 | $695 |
| 37 | VL | 3 | 3 | 14 | $12,551 |
| 38 | VL | 5 | 8 | 19 | $22,908 |
| 39 | M | 1 | 1 | 8 | $15,676 |
| 40 | M | 4 | 4 | 16 | -$5,860 |
| 41 | VL | 3 | 5 | 11 | $18,576 |
| 42 | VL | 3 | 3 | 11 | $26,380 |
| 43 | S | 3 | 3 | 11 | -$6,371 |
| 44 | M | 1 | 3 | 5 | $8,326 |
| 45 | M | 2 | 6 | 15 | $10,820 |
| 46 | L | 4 | 7 | 14 | $5,381 |
| 47 | L | 2 | 5 | 12 | $19,551 |
| 48 | VL | 4 | 7 | 19 | $17,970 |
| 49 | M | 4 | 6 | 14 | $1,536 |
| 50 | S | 1 | 4 | 9 | $8,644 |
| 51 | M | 2 | 3 | 5 | $12,086 |
| 52 | L | 3 | 4 | 10 | $6,190 |
| 53 | VL | 5 | 6 | 11 | $10,203 |
| 54 | L | 3 | 5 | 9 | $9,650 |
| 55 | VL | 4 | 7 | 15 | $22,477 |
| 56 | VL | 5 | 5 | 18 | $6,023 |
| 57 | M | 4 | 7 | 14 | $2,741 |
| 58 | VL | 3 | 7 | 16 | $18,198 |
| 59 | M | 4 | 6 | 18 | $1,031 |
| 60 | L | 2 | 2 | 9 | $19,267 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
