Customer ID Gender Product_Category Customer_Segment Payment_Method Region

1 Male Sports & Outdoors Business Cash South

2 Female Clothing Wholesale Cash West
3 Male Clothing Wholesale Credit Card South
4 Female Beauty & Health Business Credit Card East
5 Male Beauty & Health Wholesale PayPal East
6 Female Home & Kitchen Business Cash East
7 Male Sports & Outdoors Business Cash North
8 Female Home & Kitchen Wholesale PayPal East
9 Male Home & Kitchen Wholesale Bank Transfer North
10 Female Clothing Individual Bank Transfer North
11 Male Sports & Outdoors Wholesale Cash East
12 Female Electronics Wholesale Cash West
13 Male Home & Kitchen Individual PayPal North
14 Female Electronics Business Credit Card West
15 Male Electronics Wholesale Cash West
16 Female Electronics Business Credit Card East
17 Male Sports & Outdoors Wholesale Cash North
18 Female Home & Kitchen Business PayPal North
19 Male Beauty & Health Wholesale Bank Transfer South
20 Female Sports & Outdoors Wholesale PayPal North
21 Male Clothing Wholesale Cash North
22 Female Home & Kitchen Wholesale PayPal South
23 Male Electronics Individual PayPal North
24 Female Sports & Outdoors Business Credit Card South
25 Male Home & Kitchen Business PayPal East
26 Female Sports & Outdoors Business Bank Transfer South
27 Male Beauty & Health Individual Bank Transfer West
28 Female Beauty & Health Business Cash North
29 Male Sports & Outdoors Wholesale PayPal South
30 Female Electronics Individual Cash East
31 Male Clothing Individual Cash South
32 Female Electronics Individual Credit Card South
33 Male Home & Kitchen Wholesale PayPal West
34 Female Beauty & Health Individual Bank Transfer East
35 Male Sports & Outdoors Business PayPal East
36 Female Home & Kitchen Business PayPal North
37 Male Electronics Business Credit Card East
38 Female Clothing Business PayPal North
39 Male Clothing Wholesale PayPal North
40 Female Electronics Wholesale Bank Transfer South
41 Male Beauty & Health Wholesale Bank Transfer North
42 Female Sports & Outdoors Business PayPal West
43 Male Home & Kitchen Individual Cash South
44 Female Electronics Individual Credit Card West
45 Male Clothing Individual Bank Transfer East
46 Female Sports & Outdoors Individual Credit Card North
47 Male Clothing Individual PayPal West
48 Female Home & Kitchen Wholesale PayPal South
49 Male Beauty & Health Individual Credit Card East
50 Female Clothing Wholesale Cash East
51 Male Beauty & Health Wholesale Credit Card South
52 Female Electronics Business Bank Transfer North
53 Male Electronics Business Bank Transfer North
54 Female Electronics Individual Bank Transfer South
55 Male Clothing Individual Bank Transfer South
56 Female Home & Kitchen Wholesale Bank Transfer South
57 Male Sports & Outdoors Business Credit Card South
58 Female Home & Kitchen Business Bank Transfer North
59 Male Sports & Outdoors Wholesale Cash South
60 Female Beauty & Health Individual Credit Card East
61 Male Clothing Business Bank Transfer East
62 Female Beauty & Health Business PayPal East
63 Male Beauty & Health Individual PayPal West
64 Female Electronics Wholesale PayPal East
65 Male Home & Kitchen Individual Cash South
66 Female Electronics Individual Credit Card East
67 Male Clothing Wholesale Credit Card West
68 Female Beauty & Health Wholesale Cash North
69 Male Electronics Individual Bank Transfer South
70 Female Electronics Business Cash South
71 Male Beauty & Health Individual PayPal North
72 Female Beauty & Health Business Credit Card North
73 Male Electronics Individual PayPal West
74 Female Home & Kitchen Wholesale PayPal East
75 Male Sports & Outdoors Individual PayPal North
76 Female Sports & Outdoors Business Credit Card North
77 Male Electronics Wholesale Cash North
78 Female Beauty & Health Individual Cash South
79 Male Clothing Individual Credit Card South
80 Female Beauty & Health Individual Cash South
81 Male Sports & Outdoors Wholesale PayPal North
82 Female Home & Kitchen Wholesale Cash North
83 Male Beauty & Health Wholesale PayPal West
84 Female Electronics Wholesale Bank Transfer West
85 Male Home & Kitchen Wholesale Bank Transfer South
 86 Female Sports & Outdoors Individual Bank Transfer West
87 Male Home & Kitchen Business Credit Card East
88 Female Sports & Outdoors Business Cash West
89 Male Beauty & Health Business Credit Card South
90 Female Clothing Wholesale Bank Transfer North
91 Male Electronics Business Bank Transfer East
92 Female Electronics Wholesale Credit Card West
93 Male Clothing Individual Bank Transfer West
94 Female Sports & Outdoors Wholesale Credit Card North
95 Male Sports & Outdoors Wholesale Credit Card East
96 Female Sports & Outdoors Individual PayPal South
97 Male Beauty & Health Wholesale Cash South
98 Female Sports & Outdoors Individual Cash North
99 Male Sports & Outdoors Business Bank Transfer South
100 Female Home & Kitchen Business Cash West
City Sales_Channel Order_Status Sales Quantity Sold Discount Rate Delivery_Days
Philadelphia Online Pending 619.42 36 17% 5
Phoenix Catalog Cancelled 886.13 23 10% 2
Philadelphia In-store Returned 449.13 26 10% 2
San Diego Catalog Cancelled 610.02 23 18% 5
Dallas Online Returned 364.78 22 7% 3
Chicago Online Completed 576.61 32 18% 5
Los Angeles Online Cancelled 449.13 34 23% 5
San Diego Online Cancelled 372.91 33 10% 2
San Diego Online Cancelled 545.77 29 18% 4
Phoenix Catalog Returned 413.91 23 10% 2
New York Catalog Returned 600.05 38 18% 4
Chicago Phone Completed 726.82 34 26% 7
Los Angeles Catalog Completed 491.90 35 18% 2
Dallas Online Cancelled 497.81 34 18% 2
New York Online Cancelled 734.54 39 28% 8
Los Angeles Phone Returned 610.02 43 30% 9
Los Angeles Catalog Pending 614.25 34 23% 5
San Diego Catalog Pending 291.06 20 7% 2
Houston In-store Pending 696.81 30 10% 4
Philadelphia Online Pending 551.58 42 25% 6
Dallas Phone Pending 495.59 26 18% 2
Chicago Online Completed 252.88 32 7% 1
Phoenix Catalog Returned 294.06 42 7% 2
New York Online Pending 521.92 28 18% 4
Chicago In-store Completed 415.68 23 10% 2
San Antonio Catalog Completed 463.17 25 17% 3
Philadelphia Catalog Pending 720.91 37 26% 7
San Jose Phone Cancelled 830.13 34 18% 4
Phoenix Phone Returned 573.45 32 18% 5
Los Angeles Online Cancelled 473.55 25 10% 3
Los Angeles Catalog Completed 545.77 43 18% 4
San Jose Online Cancelled 375.23 33 18% 4
Houston Online Completed 610.02 38 27% 7
Philadelphia Catalog Returned 830.13 23 28% 7
Houston Online Cancelled 307.92 28 10% 3
San Diego Online Completed 557.79 30 10% 4
Phoenix Catalog Completed 449.13 42 17% 3
San Jose Phone Cancelled 734.54 36 28% 6
Chicago Phone Completed 252.88 35 23% 6
Phoenix Catalog Cancelled 708.17 36 26% 7
San Jose Phone Returned 447.28 43 30% 9
San Jose Catalog Returned 890.46 29 35% 11
San Antonio Phone Returned 503.27 27 18% 2
Phoenix Catalog Pending 421.89 24 10% 3
San Diego In-store Completed 291.06 30 28% 6
Chicago Catalog Cancelled 596.96 33 18% 4
San Jose In-store Cancelled 559.98 30 10% 4
Philadelphia Online Completed 696.81 36 26% 7
Chicago Catalog Returned 606.72 33 18% 4
San Diego Phone Cancelled 484.29 23 10% 3
Phoenix Phone Pending 504.65 42 28% 7
San Diego Catalog Pending 496.07 27 18% 2
Dallas In-store Pending 569.04 38 17% 5
Dallas In-store Cancelled 523.01 21 27% 8
New York Phone Pending 438.68 26 17% 3
New York In-store Returned 830.13 43 28% 8
Philadelphia Online Completed 497.81 28 24% 6
Chicago In-store Completed 375.23 29 18% 4
San Antonio In-store Pending 523.01 33 18% 4
New York Catalog Pending 504.65 36 25% 6
Los Angeles Online Completed 319.56 43 10% 3
New York In-store Pending 619.42 35 23% 6
San Antonio Catalog Completed 305.47 21 10% 3
Philadelphia Online Pending 521.92 21 23% 5
Phoenix Catalog Returned 473.38 25 7% 3
Los Angeles Catalog Cancelled 619.42 38 28% 6
San Jose Online Completed 659.36 36 25% 6
Phoenix In-store Completed 648.04 35 23% 6
Philadelphia Catalog Cancelled 608.04 34 18% 4
Phoenix Phone Pending 362.08 22 10% 3
Houston Phone Returned 573.24 32 18% 5
Philadelphia In-store Pending 551.58 29 18% 4
Houston In-store Completed 581.24 32 18% 5
New York Online Completed 551.58 40 10% 3
San Diego Catalog Returned 545.77 29 10% 2
Philadelphia Phone Completed 403.41 23 7% 2
Chicago Catalog Pending 886.13 21 10% 3
Phoenix Online Cancelled 726.82 42 10% 3
New York Online Cancelled 886.13 29 35% 9
Dallas In-store Pending 664.16 36 25% 6
Phoenix In-store Completed 558.42 23 10% 4
Houston Phone Completed 569.04 43 10% 5
San Diego Catalog Pending 252.88 34 23% 5
New York Phone Returned 773.24 41 28% 6
Houston In-store Pending 817.88 35 28% 8
Dallas In-store Completed 603.45 34 18% 4
Phoenix Phone Returned 518.09 35 23% 5
Houston In-store Completed 307.92 34 26% 7
Chicago Phone Completed 375.23 21 10% 2
San Antonio In-store Completed 519.23 27 18% 3
Philadelphia Online Pending 291.06 40 25% 6
Chicago Phone Completed 389.39 32 10% 2
San Diego Catalog Cancelled 454.85 21 17% 3
San Jose In-store Pending 521.92 29 10% 3
Philadelphia Catalog Returned 518.09 38 18% 3
Houston Catalog Returned 167.05 15 7% 1
Dallas In-store Completed 734.54 36 26% 7
Philadelphia In-store Returned 447.28 25 17% 3
San Diego Catalog Returned 504.65 26 18% 3
Houston In-store Cancelled 419.38 36 10% 3
Profit Margin
29%
22%
25%
31%
21%
29%
31%
21%
28%
22%
30%
35%
25%
27%
36%
41%
32%
18%
29%
34%
26%
15%
18%
27%
22%
25%
35%
28%
29%
25%
28%
30%
36%
38%
19%
28%
25%
36%
32%
35%
41%
45%
27%
23%
36%
30%
28%
35%
30%
25%
37%
27%
29%
36%
24%
40%
33%
28%
27%
34%
19%
32%
19%
31%
25%
37%
33%
33%
30%
20%
29%
28%
29%
20%
22%
22%
20%
25%
41%
34%
28%
29%
31%
36%
39%
30%
32%
34%
21%
27%
34%
22%
25%
23%
27%
12%
34%
25%
27%
23%
Sales Quantity Sold Profit Margin Question
619.42 36 29% Is there any significant influence of sales and q
886.13 23 22%
449.13 26 25%
610.02 23 31% Profit Margin vs Sa
364.78 22 21% 50%
576.61 32 29% 45%
449.13 34 31% 40%
372.91 33 21% 35%
545.77 29 28% 30%
413.91 23 22% 25%
600.05 38 30% 20%
726.82 34 35% 15%
491.90 35 25% 10%
497.81 34 27% 5%
734.54 39 36% 0%
100.00 200.00 300.00 400.00 500.00 600.00 7
610.02 43 41%
614.25 34 32%
291.06 20 18% Profit Margin and
696.81 30 29% 50%
551.58 42 34% 45%
495.59 26 26% 40%
252.88 32 15% 35%
294.06 42 18% 30%
521.92 28 27% 25%
415.68 23 22% 20%
463.17 25 25% 15%
720.91 37 35% 10%
830.13 34 28% 5%
573.45 32 29% 0%
10 15 20 25 30
473.55 25 25%
545.77 43 28%
375.23 33 30%
610.02 38 36%
830.13 23 38%
307.92 28 19%
557.79 30 28%
449.13 42 25%
734.54 36 36%
252.88 35 32%
708.17 36 35%
447.28 43 41%
890.46 29 45%
503.27 27 27%
421.89 24 23%
291.06 30 36%
596.96 33 30%
559.98 30 28%
696.81 36 35%
606.72 33 30%
484.29 23 25%
504.65 42 37%
496.07 27 27%
569.04 38 29%
523.01 21 36%
438.68 26 24%
830.13 43 40%
497.81 28 33%
375.23 29 28%
523.01 33 27%
504.65 36 34%
319.56 43 19%
619.42 35 32%
305.47 21 19%
521.92 21 31%
473.38 25 25%
619.42 38 37%
659.36 36 33%
648.04 35 33%
608.04 34 30%
362.08 22 20%
573.24 32 29%
551.58 29 28%
581.24 32 29%
551.58 40 20%
545.77 29 22%
403.41 23 22%
886.13 21 20%
726.82 42 25%
886.13 29 41%
664.16 36 34%
558.42 23 28%
569.04 43 29%
252.88 34 31%
773.24 41 36%
817.88 35 39%
603.45 34 30%
518.09 35 32%
307.92 34 34%
375.23 21 21%
519.23 27 27%
291.06 40 34%
389.39 32 22%
454.85 21 25%
521.92 29 23%
518.09 38 27%
167.05 15 12%
734.54 36 34%
447.28 25 25%
504.65 26 27%
419.38 36 23%
nificant influence of sales and quantity sold on profit margin?

Sig. Level 0.1

Profit Margin vs Sales
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.65
R Square 0.42
Adjusted R Square 0.41
Standard Error 0.05
Observations 100.00

ANOVA
df
300.00 400.00 500.00 600.00 700.00 800.00 900.00 1000.00
Regression 2.00
Residual 97.00
Profit Margin and QS Total 99.00

Coefficients
Intercept 0.09
Sales 0.0188%
Quantity Sold 0.3178%

Profit Margin =
31% =

5 20 25 30 35 40 45
 SS MS F Significance F
0.16 0.08 35.30 0.00
0.22 0.00
0.38

Standard Error t Stat P-value Lower 95% Upper 95% Lower 90.0% Upper 90.0%
0.03 3.36 0.00 0.04 0.14 0.04 0.13
0.00 6.02 0.00 0.00 0.00 0.00 0.00
0.00 4.37 0.00 0.00 0.00 0.00 0.00

Intercept + Sales * 0.0188% + QS

0.09 + 510.00 * 0.0188% + 39.00
* 0.3178%
* 0.3178%