Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started