BEO1106 Business Statistics Assignment: Statistical Data Analysis

This document presents a solution to a Business Statistics assignment (BEO1106), focusing on the analysis of random numbers using Microsoft Excel. The assignment includes multiple tasks requiring the application of statistical techniques and the generation of Excel outputs. The instructions provided guide the user through the process of obtaining the necessary Excel outputs for completing the tasks, emphasizing the importance of adapting the instructions to suit the specific dataset being used. The document also highlights the need for proper documentation and progressive saving of work. Desklib provides this assignment as a resource for students, offering access to similar past papers and solved assignments to aid in their studies.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
A B C D E F G H I
PN V1 V2 V3 V4 V5 V6 V7 V8
177 3 0 1 1 6 736 664
257 1 1 3 2 6 697 505 447
109 1 2 4 1220 350
233 2 0 2 2 5 475
234 2 1 4 3 5 350 410 359
10 2 0 1 1 2 239.5 221
321 1 0 1 2 5 590 524
260 3 1 3 1 7 645 665 601
185 2 1 3 3 5 330 510 448
180 3 1 1 1 8 810 2050 1924
385 3 1 3 2 8 655 1215 1029
189 4 0 1 1 2 1100 988
168 1 0 3 2 3 379 314
322 1 1 1 2 6 584 470 418
232 2 0 1 2 6 670 610
115 3 1 2 2 5 613 450
269 1 1 1 2 5 687 642 572
213 3 1 1 3 8 719 851 787
51 3 0 1 1 2 336 276
338 3 1 1 3 5 255 880 827
181 3 0 4 1 5 936 803
332 4 1 1 1 6 133 917 725
285 3 0 1 1 3 686 623
46 3 1 1 2 5 590 620 565
326 3 1 3 1 7 695 1125 994
50 4 1 1 1 4 149 820 749
359 1 1 4 1 7 725 645.55 593
116 3 1 1 1 5 845 1800 1681
68 1 0 2 1 5 550
311 4 1 1 3 4 162 752 680
335 1 1 3 2 7 805 461.25 391
327 3 1 3 2 7 700 845 788
66 3 1 2 2 6 864 315
207 3 0 4 2 6 445 393
303 1 1 2 2 6 750 825
91 2 1 4 3 5 360 745 694
125 1 1 1 3 5 581 755 704
127 1 0 1 2 5 319 255
373 2 3 4 810 300 290
297 1 1 1 3 5 385 387.5 332
186 3 1 1 1 5 319 805 736
163 2 3 4 1085 132 105
107 1 1 2 2 8 879 1200
146 4 1 1 3 3 248 615 554
117 3 0 1 1 6 880 827
158 3 3 4 20000 2650 2458
136 3 1 3 2 6 512 552 490
276 2 1 1 2 5 380 363 289

50
51
52
A B C D E F G H I
34 3 1 1 1 8 687 1335 1224
318 3 1 1 3 6 703 501 433