NIP: 838823

Name: Garcés Catón, Alejandro

arcés Catón, Alejandro
 Task 1 (5 points)
In this exercise you can find data referring to a number of mobile phone shops. This sheet sh
employees in the shop, Number of customers who have visited the shop, Number of mobil
mobiles sold to companies, and Number of Internet lines sold.
A) (1.6 points) Obtain the frequency distribution of the variable Number of employees as de
graphical representation. What can you highlight from the graph?
B) (0.8 points) Calculate the average amount of the Number of mobiles sold to individuals
behaviour of this variable?
C) (0.8 points) Analyse the shape (skewness and kurtosis) of the variable Number of mobile
D) (0.6 points) Are there high outliers or high extreme outliers for the Number of mobiles so
E) (0.2 points) What is the most frequent number of employees?
F) (1 point) Use a boxplot and a histogram to present graphically the distribution of the Num
Interpret the graphs obtained.

A)

Individual Company Internet

Employees Customers xi
Mobiles Mobiles lines
5 6350 369 480 60 1
6 8535 496 535 76 2
3 4527 263 297 41 3
3 3952 317 694 66 4
3 4114 337 492 58 5
4 8149 424 635 74 6
6 7271 487 964 96 7
4 3412 255 218 36
4 6757 423 633 73
5 4444 388 426 60
4 9959 436 1567 121
B)
6 4824 433 255 56
6 4643 435 441 65
3 9755 423 665 75 Average of number of
4 3703 288 494 53 mobiles sold to individuals
4 9859 379 892 82 Median
3 7745 438 1234 105 Mode
4 6477 312 482 55
6 7646 375 836 79
5 5159 337 422 54
C)
3 4755 408 416 61
5 4452 339 924 80
5 7901 352 625 66 Skewness
4 4476 371 411 57 Kurtosis
2 6499 361 685 70
7 9432 465 591 76 N
5 9172 443 665 77
5 3719 272 252 39
2 8191 360 822 77
D)
2 5976 373 888 81
5 9670 410 1138 97
4 7573 394 642 71 Q3
3 7187 469 681 80 Q1
7 7193 377 1409 108 Ri
4 6899 449 660 77
4 6115 349 1230 96 Max data
2 9696 481 918 94 Nº of high
4 3317 313 872 74 outleaders
2 4075 315 791 71
4 9383 385 1086 92
6 5567 409 541 67
E)
5 5181 309 458 53
2 5399 431 753 80
4 5591 296 760 67 Mode
4 8909 471 1112 102
6 8740 453 700 80
3 6533 411 487 65
E)
5 4135 206 450 43
1 6010 361 589 65
4 3148 257 741 62 This chart isn't available in y
5 5996 361 393 55
3 9866 427 989 92 Editing this shape or saving t
6 6306 561 512 81 permanently break the chart.
4 4938 287 523 54
2 4691 367 1678 120
6 6545 378 746 75
4 6917 456 799 85
5 6836 439 727 80
5 7813 467 539 73
7 3100 279 647 60
7 3238 245 334 41
2 4461 323 920 78
4 8533 323 920 78
6 6409 391 547 66
6 4033 283 433 49 This boxplot represent to us w
5 7950 437 688 78 we cuold see represented th
50% of the data. Also the Q1
6 3163 271 1771 115 we find the minimun numbe
2 5307 375 347 54 with the lines
3 3748 379 686 72
2 5039 377 322 53
4 7512 485 696 83
3 8632 445 1350 112
4 9364 442 547 71
4 8176 425 728 78
3 8621 331 751 70
4 6823 383 723 74
4 8576 383 747 75
3 4320 346 283 48
3 7189 446 524 70
6 6640 288 591 58
4 5799 335 882 77
3 9302 374 1068 90
5 5218 302 326 46
4 5915 326 436 54
4 9104 442 597 74
5 4854 338 552 61
4 7710 426 609 73
3 3133 388 317 54
4 3460 199 688 54
6 7553 340 828 75
4 3948 436 571 72
4 9368 406 866 83
5 6125 296 405 49
4 8150 518 653 84
4 9380 511 885 95
4 7780 394 1173 98
5 5976 374 312 53
3 8023 355 771 74
5 9399 474 925 93
4 6770 357 521 61
4 8285 457 948 93
4 4243 280 762 66
5 4228 257 913 71
5 3550 356 667 68
5 7596 405 960 88
4 3074 231 400 43
5 4942 296 680 63
6 5888 415 380 60
5 9625 419 1084 96
3 7714 357 794 75
5 4634 295 485 53
4 6342 389 488 63
5 7911 384 705 73
5 9572 469 751 84
5 5062 422 662 75
6 7027 481 432 69
3 6242 393 388 58
4 4664 370 363 55
4 8993 430 1125 99
1 6516 299 397 49
6 9339 402 792 79
5 5102 304 415 51
5 7954 348 964 83
4 4242 347 1514 110
5 3277 320 575 60
5 7038 372 827 78
4 6021 243 674 58
5 6039 317 467 55
5 5768 277 1309 93
5 3258 318 597 61
3 3391 270 322 43
5 8958 480 899 92
5 6500 438 584 73
6 9056 414 914 87
7 5905 460 706 81
6 9602 416 907 86
3 5869 332 1096 88
3 5009 298 696 64
4 8879 444 880 88
4 6553 372 1365 105
5 5278 264 327 42
5 6956 319 568 60
5 3456 255 750 63
4 8293 417 613 72
4 7718 461 996 95
2 5708 364 588 65
4 6711 343 948 81
3 6878 316 517 57
6 4556 325 911 78
4 4647 346 434 56
4 9698 439 820 84
2 6814 423 840 84
4 3585 259 612 56
2 7486 326 647 64
3 3752 308 849 73
3 9014 488 811 89
3 3698 341 469 57
4 4888 393 1914 135
3 3633 239 789 63
7 5156 391 422 60
4 7463 526 537 79
3 7980 319 825 73
4 3254 285 721 64
3 8615 455 827 86
5 4827 267 593 56
3 8312 539 555 81
2 4743 372 448 59
2 9768 467 769 85
6 9509 390 1148 96
4 9152 394 1250 101
3 7457 363 531 62
4 8951 397 1746 127
3 5754 304 437 52
4 4505 272 329 43
4 9706 436 1019 94
2 4993 402 444 62
5 7670 407 980 89
3 6896 419 796 81
6 9280 353 772 73
5 9818 425 659 75
2 4424 465 364 64
5 3967 249 300 39
6 3177 350 292 49
2 4329 337 881 77
5 5243 381 517 63
1 5620 310 722 67
5 6399 413 424 62
4 7826 459 783 85
7 9068 399 647 72
7 8563 462 1960 144
3 8735 401 925 86
4 4518 246 449 47
3 9296 533 987 102
5 5292 334 534 60
5 6728 368 977 85
4 9820 380 644 70
6 8382 449 746 82
7 3987 302 533 56
2 8240 425 1147 99
6 3126 248 468 48
4 4406 213 305 36
4 7427 588 818 99
5 6522 330 1544 110
3 5800 364 402 56
4 8963 393 1301 104
2 9454 517 593 81
7 7465 462 461 69
5 7549 415 523 67
5 3977 287 327 45
5 9170 507 958 98
3 8273 407 920 86
3 7739 381 503 63
e shops. This sheet shows information about the Number of
op, Number of mobiles sold to individuals, Number of

er of employees as detailed as possible. Make an appropriate

s sold to individuals. Is this measure representative of the

le Number of mobiles sold to individuals.

Number of mobiles sold to individuals?

stribution of the Number of mobiles sold to individuals.

Obtain the frequency distribution of the variable Number of employees as detailed as possible.
Make an appropriate graphical representation. What can you highlight from the graph?

ni fi Ni Fi Number of employees
0.35
3 1.42% 3 1.42% 0.3
20 9.43% 23 10.85% 0.25
38 17.92% 61 28.77%
0.2
64 30.19% 125 58.96%
0.15
52 24.53% 177 83.49%
0.1
25 11.79% 202 95.28%
0.05
10 4.72% 212 100.00%
0
212 100.00% 1 2 3 4 5 6 7

Calculate the average amount of the Number of mobiles sold to individuals. Is this measure
representative of the behaviour of this variable?

erage of number of As we said in section A), Locate a representative value usually in the centre of
obiles sold to individuals
375.741 Mobiles sold thedistribution. For this reason, we calculate the median, to know where are the half of ou
data. Also we could take into accounnt the mode to know where are agrupated the most
Median 377.5 Mobiles sold frequent dataIn thiscase we could conclude that this average is representative.
Mode 337 Mobiles sold

Analyse the shape (skewness and kurtosis) of the variable Number of mobiles sold to individuals
 Skewness 0.0181 >0 Skewed‐right statistically 0.3365 Both are not stadistically
Kurtosis -0.3428 <0 platykurtic significant 0.6729 significant

212 mobiles

Are there high outliers or high extreme outliers for the Number of mobiles sold to individuals

427.75 mobiles Extreme outlid 751.75 Because in our variable our high number registered is 588, we could say tha
we find 13 hihg outleaders, but we don´t find any extreme outleader.
319.75 mobiles Hihg outliders 481.75
108 mobiles

588
13

What is the most frequent number of employees?

4 Number of employees is tho mos frequent variable of our distribution. We could say is the most repetitive varia

Use a boxplot and a histogram to present graphically the distribution of the Number of mobiles
sold to individuals. Interpret the graphs obtained

This chart isn't available in your version of Excel. This chart isn't available in your version

Editing this shape or saving this workbook into a different file format will Editing this shape or saving this workb
permanently break the chart. permanently break the chart.

his boxplot represent to us where is the middle part of the registered variables. As In this type of graph we could identific
we cuold see represented the medianor Q2 which represent where is situate the simplificate the observtion of the varia
50% of the data. Also the Q1 and Q3 which are the extremes of the blue box. Also say that have a little Skewed‐right, bec
we find the minimun number and maximous number of our variable, represeanted the quartile 2. Also we could say that th
with the lines in the top and the botton of the graph. the di
 iled as possible. MAX 7
he graph? MIN 1

Seeing this graph we could say that is following a

ees piramide shape in which most of the data is
concentrated in the middle of the frequency
distribution. For instance we could asume that is
very symetry. This whold be a negative result very
near to 0 in the MEASURES OF SKEWNESS, because
we could see also that there are more quantity of
thata in the right than in the left. May be could
determine a little Sekwed-left We could say that
average=mode=median.

5 6 7

s. Is this measure

he centre of
w where are the half of our
are agrupated the most
epresentative.

sold to individuals.
Both are not stadistically
significant

old to individuals

ed is 588, we could say that

extreme outleader.

he most repetitive variable

Number of mobiles

available in your version of Excel.

pe or saving this workbook into a different file format will

eak the chart.

graph we could identificate the data registered in intervals of 44 to

observtion of the variable. Seeing the shape of the graph we could
a little Skewed‐right, because there are more data registered along
so we could say that the most frequency variable is in the middle of
the distribution.
838823