Exploring Numbers

This assignment content appears to be a long list of numbers with no specific topic or theme.

Table of Contents
Methodology.........................................................................................................................................2
Data.......................................................................................................................................................2
Analysis.................................................................................................................................................2
Regression Analysis..........................................................................................................................2
Correlation Analysis..........................................................................................................................4
Appendix...............................................................................................................................................5

Methodology
The population consists of all the organizations in the world. A method of simple random
sampling is used for the purpose of Data Collection. A total of 200 companies are randomly
selected. Each of these companies are asked regarding the average number of products sold
per month, average communication time between the potential customer and the business
provider per day, the average number of customers reached with the help of social media per
day, the average number of SMS sent, the total cost on mobile and their profit margin on the
product.
Data
A dependent variable is the total number of products sold. This measures the productivity of
an organization. The independent variables are communication time (hours/day), the total
number of customers reached by social media, SMS sent, cost on mobile, and profit margin in
percentage. It is expected that the communication time, customers read is social media and
SMS sent should increase the productivity of the organization. However, the cost of the
mobile is expected to have a negative relationship with the productivity of the organization.
Analysis
Regression Analysis
The regression results are given below.
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.999997
R Square 0.999994
Adjusted R Square 0.999994
Standard Error 0.593598

Observations 200
ANOVA
df SS MS F
Significanc
e F
Regression 5 11883421 2376684 6745081 0
Residual 194 68.35748 0.352358
Total 199 11883489
Coefficient
s
Standard
Error t Stat P-value Lower 95%
Upper
95%
Intercept -0.79337 0.222951 -3.55851 0.000469 -1.23309 -0.35365
communication time (hours/day) 0.00509 0.016976 0.299814 0.76464 -0.02839 0.038571
Customers reached by social
media 0.000997 3.14E-06 318.0028 1.3E-265 0.000991 0.001004
SMS sent 0.001246 0.001575 0.791478 0.429632 -0.00186 0.004352
cost on mobile [phone].259447 0.209382 -0.00022 0.001011
profit margin (%) -0.0284 0.014412 -1.97081 0.050168 -0.05683 2.1E-05
The Null hypothesis, the model is not significant. Versus the alternative hypothesis that the
model is significant. With F=6745080, P<5%, the null hypothesis is rejected at 5% level of
significance. There is sufficient evidence to conclude the significance of the model.
There is 99% variation in the total number of products sold which is explained by
communication time (hours/day), Customers reached by social media, SMS sent, cost on
mobile and profit margin (%). This percentage is a good and fitted model is said to be a good
fit for the data
The regression equation is given by: product sold = -0.79337 + 0.005*communication time
(hours/day) + 0.00099*Customers reached by social media + 0.0012*SMS sent
+ 0.00039*cost on mobile -0.0284*profit margin (%)
With one hour per day increases in the communication time between potential customer and
business, the total number of product sold is increased by 0.005. But this value is not
significant at 5% level of significance with t=0.299, p>5%.

With an increase in one customer reached by social media, the total number of product sold is
increased by 0.0009. This value is significant at 5% level of significance with t=318, p<5%.
With one SMS sent increase, the total number of product sold is increased by 0.0012. This
value is not significant at 5% level of significance with t=0.791, p>5%.
With $1 increases in the cost of mobile, the total number of product sold is increased
by 0.00039. This value is not significant at 5% level of significance with t=1.259, p>5%.
With an increase in 1% profit margin, the total number of product sold is decreased by 0.028
this value is not significant at 5% level of significance with t=-1.97, p>5%.
Correlation Analysis
The table of correlation is given below.
Produ
cts
sold
communica
tion time
(hours/day
)
Custom
ers
reache
d by
social
media
SMS
sent
cost
on
mobil
e
profit
margi
n (%)
Products
sold 1
communica
tion time
(hours/day)
-
0.0516 1
Customers
reached by
social
media
0.9999
97 -0.05156 1
SMS sent
0.9984
76 -0.05636
0.9984
71 1
cost on
mobile
-
0.0158
5 0.532425
-
0.0156
7
-
0.021
53 1
profit
margin (%)
-
0.0491 0.468692
-
0.0488
1
-
0.053
26
0.9049
75 1

There is a strong positive linear relationship between the product sold with customers reached
by social media and the SMS sent. With the increase in the value of the total number of
customers reached by social media, the total number of product sold also increases. Also with
the increase in the number of SMS sent, the total number of product sold increases. In other
words, I can say that there is a positive linear relationship of the productivity of an
organisation with customers reached by social media and the SMS sent.
Appendix
S.
No
Products
sold
communication time
(hours/day)
Customers reached by
social media
SMS
sent
cost on
mobile
profit
margin (%)
1 317 11 317244 653 882 25.64
2 934 4 934048 1903 427 13.54
3 927 4 928599 1919 864 22.28
4 718 12 719540 1509 1601 41.02
5 788 7 788967 1654 671 22.42
6 567 8 567547 1184 636 14.72
7 668 12 668312 1402 1325 34.5
8 471 6 472780 967 572 15.44
9 486 12 486617 1000 929 22.58
10 563 9 564837 1145 1380 35.6
11 198 5 198558 437 479 10.58
12 744 3 744003 1556 233 11.66
13 649 9 649693 1353 773 23.46
14 971 3 972793 2002 891 25.82
15 371 8 371909 817 684 23.68
16 798 8 798573 1609 1198 24.96
17 805 7 805610 1631 523 17.46
18 453 3 453982 950 1111 22.22
19 540 9 541642 1092 700 19
20 150 8 150078 331 1436 34.72
21 435 8 436749 959 818 25.36
22 333 12 333210 756 851 19.02
23 494 8 494482 1056 934 24.68
24 370 5 371054 753 712 21.24
25 566 11 566640 1194 1552 36.04
26 344 4 345149 783 619 17.38
27 507 6 508166 1111 865 19.3
28 926 3 926439 1882 596 18.92
29 974 7 974956 1996 568 13.36

30 891 6 891314 1799 567 15.34
31 330 8 330391 729 803 20.06
32 467 3 468191 1011 470 12.4
33 160 8 161955 371 1351 34.02
34 499 6 500926 1011 1124 28.48
35 501 11 502846 1059 1520 32.4
36 173 11 173160 431 1092 23.84
37 383 12 384735 814 1658 36.16
38 532 4 532701 1122 456 11.12
39 744 4 744646 1531 290 15.8
40 624 9 624667 1339 1383 31.66
41 602 6 602680 1252 1163 24.26
42 973 7 974237 2008 1381 30.62
43 191 5 191438 447 1156 29.12
44 676 8 677353 1445 726 18.52
45 717 9 717547 1503 833 19.66
46 573 5 573381 1162 791 15.82
47 450 9 451920 975 542 16.84
48 740 10 740591 1525 798 18.96
49 244 6 245217 562 682 16.64
50 459 12 460644 945 999 28.98
51 717 6 717838 1450 470 10.4
52 632 5 632608 1287 1157 27.14
53 207 10 207757 466 1161 30.22
54 411 12 412992 840 1387 33.74
55 237 6 237808 569 1163 30.26
56 871 4 872426 1764 915 22.3
57 702 5 702477 1454 447 13.94
58 873 11 873610 1845 774 19.48
59 208 5 208338 471 1191 27.82
60 523 6 523692 1125 1246 29.92
61 219 7 219970 494 483 10.66
62 405 7 406002 840 591 19.82
63 595 12 596727 1246 1340 30.8
64 803 11 803477 1664 1231 26.62
65 502 10 502874 1072 1137 29.74
66 191 7 192492 444 1281 32.62
67 819 8 820464 1713 1298 26.96
68 857 6 858027 1796 935 20.7
69 556 4 556072 1170 1099 21.98
70 203 3 204996 500 735 22.7
71 775 8 776009 1638 1311 31.22
72 217 7 217045 500 559 17.18
73 854 11 855605 1751 1588 35.76
74 572 11 573902 1243 688 18.76
75 741 10 741906 1494 1240 25.8
76 899 9 900012 1842 918 26.36
77 232 3 232762 545 1062 26.24

78 470 12 470585 983 1426 33.52
79 331 7 332229 718 1224 28.48
80 320 7 321687 731 425 17.5
81 796 12 797643 1604 1305 36.1
82 247 3 248717 553 392 15.84
83 748 11 749467 1509 1027 26.54
84 333 6 334535 677 373 11.46
85 720 8 720352 1517 783 16.66
86 339 12 339337 735 1686 33.72
87 908 5 909210 1838 1168 26.36
88 525 5 525912 1147 1094 25.88
89 416 5 416977 870 906 26.12
90 448 7 448910 987 1300 35
91 871 5 872059 1791 885 20.7
92 757 4 757093 1607 472 16.44
93 509 10 509899 1087 1256 26.12
94 898 12 899580 1853 722 16.44
95 180 3 180028 392 587 18.74
96 478 6 479135 1004 545 17.9
97 117 8 118808 309 801 25.02
98 470 8 470448 1025 1429 29.58
99 293 12 293191 651 952 21.04
10
0 229 5 229815 526 491 18.82
10
1 747 11 748180 1523 961 24.22
10
2 153 11 153573 363 1304 35.08
10
3 524 10 524383 1112 1415 29.3
10
4 420 3 421387 885 548 13.96
10
5 627 8 627494 1338 863 22.26
10
6 250 10 251617 578 1206 26.12
10
7 507 7 508961 1113 1009 27.18
10
8 610 3 610320 1252 787 23.74
10
9 399 7 400374 814 700 24
11
0 690 3 691926 1479 784 24.68
11
1 887 5 887421 1838 541 18.82
11
2 230 4 231374 488 876 27.52
11 118 7 119988 325 666 23.32

3
11
4 428 5 429786 955 780 19.6
11
5 719 6 720273 1488 1074 31.48
11
6 320 10 321592 679 999 29.98
11
7 674 3 675477 1383 1125 32.5
11
8 308 12 309919 699 1351 27.02
11
9 305 7 305325 707 745 21.9
12
0 705 5 705768 1501 533 20.66
12
1 421 11 421883 877 1117 31.34
12
2 694 7 695693 1403 614 19.28
12
3 604 10 604329 1238 969 28.38
12
4 706 10 707765 1442 1494 37.88
12
5 380 8 381944 788 1363 34.26
12
6 609 4 610917 1315 478 14.56
12
7 696 4 696399 1482 535 18.7
12
8 147 3 147452 316 947 28.94
12
9 221 8 222768 526 618 20.36
13
0 807 4 808221 1711 838 18.76
13
1 806 5 807664 1661 657 16.14
13
2 842 9 843626 1781 1065 31.3
13
3 640 12 640648 1373 1183 23.66
13
4 970 9 970926 1986 1433 31.66
13
5 420 5 420067 919 622 22.44
13
6 881 3 881648 1807 434 9.68
13
7 592 11 593823 1224 1070 26.4
13 390 6 390342 856 1214 34.28

8
13
9 107 12 108100 256 1400 34
14
0 638 3 639654 1353 894 24.88
14
1 986 11 987111 2022 1304 27.08
14
2 275 4 276375 597 392 16.84
14
3 835 9 836817 1707 1455 35.1
14
4 684 4 685716 1379 1105 28.1
14
5 520 12 521955 1080 1072 30.44
14
6 227 12 227674 477 1268 28.36
14
7 169 4 170588 430 661 15.22
14
8 531 12 532284 1150 974 29.48
14
9 911 8 911113 1880 1379 31.58
15
0 659 4 660390 1415 474 13.48
15
1 804 9 804740 1625 993 25.86
15
2 698 5 699388 1406 355 14.1
15
3 642 4 642539 1361 1065 28.3
15
4 174 6 175293 415 792 20.84
15
5 263 8 263168 609 774 19.48
15
6 626 11 626512 1280 722 14.44
15
7 607 8 607541 1245 608 14.16
15
8 134 8 134298 339 998 22.96
15
9 478 9 478786 966 1181 24.62
16
0 435 4 435737 882 910 19.2
16
1 888 11 888162 1799 1259 28.18
16
2 420 11 420405 865 1269 26.38
16 555 11 556479 1151 1592 34.84

3
16
4 433 5 433608 904 1125 23.5
16
5 104 3 105750 266 424 13.48
16
6 578 4 578989 1240 415 18.3
16
7 429 6 429786 871 905 19.1
16
8 276 11 277686 649 941 24.82
16
9 799 8 800453 1646 696 19.92
17
0 964 6 964702 2010 1137 32.74
17
1 507 12 507334 1099 1279 29.58
17
2 625 10 625469 1294 646 19.92
17
3 129 9 130035 349 1140 24.8
17
4 539 12 540448 1118 1684 40.68
17
5 857 12 857488 1782 742 22.84
17
6 606 6 607983 1229 1302 35.04
17
7 257 10 258920 534 1268 27.36
17
8 725 5 726696 1514 1021 22.42
17
9 128 10 128149 352 1221 32.42
18
0 626 12 626503 1275 824 22.48
18
1 599 7 599256 1239 645 12.9
18
2 447 10 448458 911 1146 26.92
18
3 307 6 307174 657 1048 28.96
18
4 246 9 247003 580 908 18.16
18
5 858 6 858941 1789 806 23.12
18
6 230 12 231979 560 1008 24.16
18
7 355 12 356795 728 945 20.9
18 819 8 820903 1704 709 20.18

8
18
9 931 6 932450 1943 599 13.98
19
0 820 4 821922 1689 1212 25.24
19
1 421 4 421092 923 640 17.8
19
2 831 3 832819 1708 503 14.06
19
3 475 6 475146 1047 629 20.58
19
4 812 4 813921 1700 957 23.14
19
5 604 8 604798 1255 1224 28.48
19
6 122 10 122175 290 1060 28.2
19
7 802 12 803066 1673 1035 24.7
19
8 198 4 199197 470 263 9.26
19
9 931 7 932379 1943 861 24.22
20
0 863 7 863255 1816 1081 28.62