Ex.
No: 1 You are given the following data items pertaining to prices of shares during
the Month of Jan 2024.
Alpha Ltd. Beta Ltd. Gamma Ltd Lambda Ltd Zeta Ltd
691 799 602 901 833
382 287 907 732 261
840 200 523 848 580
423 861 85 784 107
310 439 602 777 334
716 448 602 194 118
975 400 979 661 171
396 270 479 732 356
973 532 138 814 74
423 952 817 602 768
678 438 118 732 580
486 532 93 720 610
675 687 704 435 580
423 597 171 913 231
558 559 384 440 619
660 656 112 732 926
987 532 554 683 580
487 723 271 946 873
672 343 94 732 528
699 575 584 779 465
687 871 684 841 91
Using Data Analysis Tool pack
Parameters Alpha Ltd. Beta Ltd. Gamma Ltd. Lambda Ltd. Zeta Ltd.
Mean 625.7619048 557.19047619 452.52380952 714.1904762 461.19047619
Standard Error 44.38848546 45.166075504 63.061406923 38.63317222 58.973424969
Median 672 532 523 732 528
Mode 423 532 602 732 580
Standard Deviation 203.4135946 206.97695984 288.98367065 177.039436 270.25018391
Sample Variance 41377.09048 42839.461905 83511.561905 31342.9619 73035.161905
Kurtosis -0.715646526 -0.6109483866 -1.17904586 2.78385214 -1.1270654743
Skewness 0.35885202 0.2182364762 0.1176527142 -1.50961728 0.0651260668
Range 677 752 894 752 852
Minimum 310 200 85 194 74
Maximum 987 952 979 946 926
Sum 13141 11701 9503 14998 9685
Count 21 21 21 21 21
Largest(1) 987 952 979 946 926
Smallest(1) 310 200 85 194 74
Confidence Level(95.0%) 92.59275816 94.214782557 131.54378977 80.58738509 123.01640885
Using Syntax
Parameters FORMULA Alpha Ltd. Beta Ltd. Gamma Ltd
Mean =AVERAGE(B5:B25) 625.761905 557.1905 452.5238095
Standard Error =J12/SQRT(J20) 44.3884855 45.16608 63.06140692
Median =MEDIAN(B5:B25) 672 532 523
Mode =MODE(B5:B25) 423 532 602
Standard Deviation =STDEV.S(B5:B25) 203.413595 206.977 288.9836707
Sample Variance =VAR.S(B5:B25) 41377.0905 42839.46 83511.5619
Kurtosis =KURT(B5:B25) -0.7156465 -0.610948 -1.17904586
Skewness =SKEW(B5:B25) 0.35885202 0.218236 0.117652714
Range =S18-S17 677 752 894
Minimum =MIN(B5:B25) 310 200 85
Maximum =MAX(B5:B25) 987 952 979
Sum =SUM(B5:B25) 13141 11701 9503
Count =COUNT(B5:B25) 21 21 21
Largest(1) =LARGE(B5:B25,1) 987 952 979
Smallest(1) =SMALL(B5:B25,1) 310 200 85
Confidence Level(95.0%) =CONFIDENCE.T(0.05,J12,J20) 92.5927582 94.21478 131.5437898
Lambda Ltd Zeta Ltd
714.19047619 461.1905
38.633172216 58.97342
732 528
732 580
177.03943602 270.2502
31342.961905 73035.16
2.7838521401 -1.127065
-1.509617283 0.065126
752 852
194 74
946 926
14998 9685
21 21
946 926
194 74
80.587385094 123.0164
Ex No.2 Generate a series of data with 100 observations pertaining to marks scored by commerce students in statistics pap
Random Data
Marks secured by students in statistics paper
76
31
30
93
70
57
86
43
55
48
59
63
78
33
58
68
30
43
67
66
52
67
84
51
35
66
53
38
80
73
38
86
49
66
74
59
84
77
80
90
39
78
42
53
81
69
50
36
79
46
36
37
52
74
58
77
62
42
47
68
39
40
60
68
71
94
35
48
85
53
69
66
95
85
78
90
71
94
37
33
53
74
88
54
69
86
91
71
50
88
65
58
82
68
89
43
79
81
66
76
o marks scored by commerce students in statistics paper with 30 as minimum marks and 95 as highest marks. Calculate descriptive statistic
Random Data Using Data Analysis Toolpack
Marks secured by students in statistics paper
Mean
54 Standard Error
62 Median
81 Mode
76 Standard Deviation
47 Sample Variance
89 Kurtosis
78 Skewness
51 Range
84 Minimum
30 Maximum
90 Sum
54 Count
40
85
38 Using Syntax
71
32 Mean
64 Standard Error
82 Median
44 Mode
75 Standard Deviation
74 Sample Variance
40 Kurtosis
45 Skewness
44 Range
61 Minimum
89 Maximum
56 Sum
78 Count
91
89
47
42
63
64
40
59
51
39
50
33
45
34
60
69
57
53
58
73
47
43
87
39
50
66
92
32
48
94
34
56
55
48
61
49
59
46
49
87
49
53
90
46
44
60
89
39
75
36
61
81
41
59
88
93
95
32
43
90
58
81
43
83
46
34
67
54
62
67
66
hest marks. Calculate descriptive statistics using data analysis toolpak and syntax.
Analysis Toolpack
59.98
1.858476621735
57.5
89
18.58476621735
345.3935353535
-1.065278943442
0.350201809378
65
30
95
5998
100
Using Syntax
59.98 =AVERAGE(E6:E105)
1.858476621735 =H26/SQRT(H34)
57.5 =MEDIAN(E6:E105)
89 =MODE(E6:E105)
18.58476621735 =STDEV.S(E6:E105)
345.3935353535 =VAR.S(E6:E105)
-1.065278943442 =KURT(E6:E105)
0.350201809378 =SKEW(E6:E105)
65 =H32-H31
30 =MIN(E6:E105)
95 =MAX(E6:E105)
5998 =SUM(E6:E105)
100 =COUNT(E6:E105)