60 75 Mean 62.

36
39 66 Median 62.5
65 51 Mode 50
87 41 Std. Dev. 15.79041
56 54 Variance 249.3371 46 26
44 81 Skewness 0.030436 17 6
59 83 Kurtosis -1.190133 97 8
85 61 C.V. 25.32138 95 85
66 40 Q3 75 24 27
66 71 P60 68.4 16 75
55 48 D8 76.2 38 44
82 72 Largest Value 89 89 73 12
79 87 Smalest Value 36 46 93
79 51 Range 53 53 11 71
78 58 55 94
78 76 57 10
61 86 58 22
62 77 14 16
80 67 51 93
83 44 37 38
70 68 61 100
51 76 35 21
61 53 36 8
49 74 15 44
52 62 50 71
44 47 46 30
39 63 34 91
66 88 31 70
36 50 25 14
76 36 85 59
39 50 23 23
59 73 24 76
76 86 26 32
56 63 21 24
51 50 97 20
70 70 37 97
76 89 64 43
40 37 14 57
45 84 86 62
79 41 81 17
40 54 36 14
53 42 58 50
86 52 76 40
85 58 42 89
44 81 29 2
90 44 26 9
54 69 57 70
75 75 79 67
90 37 4 35
82 57 67 43
34 88
67 11
60 68
24 70
69 6
93 52
61 31
46 26
17 65
29 20
82 61
38 51
98 43
52 29
16 42
46 76
88 13
95 82
30 27
46 66
1 94
94 95
81 82
35 78
5 68
97 26
13 8
60 11
82 48
12 82
16 13
37 59
62 35
2 51
42 46
86 45
88 73
96 75
80 18
93 44
15 64
92 86
10 75
3 71
97 76
44 50
 69 98
2 97
13 38
49 55
77 99
47 52
19 24
30 78
93 22
93 52
56 99
73 11
61 70
18 87
25 93
28 1
31 93
58 18
58 90
95 80
2 79
83 72
23 4
52 11
93 27
95 17
98 16
23 41
100 7
9 12
59 23
10 30
69 60
89 93
4 47
49 51
55 48
7 66
15 69
16 40
1 5
42 30
88 2
86 64
37 80
91 36
70 56
8 23
 94 54
6 22
20 21
100 67
44 60
85 70
72 76
54 52
4 30
73 94
36 17
54 18
18 13
75 7
57 71
68 94
67 53
76 80
66 4
60 34
58 81
76 43
22 18
45 71
35 35
27 76
46 1
61 32
6 81
1 16
21 66
55 71
65 16
92 17
46 2
75 8
28 94
74 35
57 90
35 11
20 8
47 1
33 58
40 66
57 16
22 27
8 36
8 14
 4 58
96 83
84 8
34 34
16 64
83 84
16 3
 29 99
47.30769 47.30769 62 23
46 46 62 29
8 46 24 100
29.48821 5 64 1
-1.289735 53 96
0.103854 51 83
869.5543 63 8 100
1.663417 38 97
58.4 86 17
76 40 10 1
72 30
8 12
16 2
96 37
17 54
59 47
87 8
58 56
83 93
82 68
70 13
66 26
33 78
19 7
74 78
41 81
65 100
27 87
73 81
52 29
74 16
70 54
6 12
59 89
74 39
3 48
46 55
42 69
24 89
99 46
86 2
98 3
51 58
 88 11
20 60
40 62
53 87
51 42
99 20
85 46
91 27
17 95
43 79
35 26
20 7
61 10
57 27
83 39
4 85
64 89
100 48
41 49
74 83
40 31
51 66
86 37
57 50
71 32
72 82
42 36
11 82
20 55
24 59
46 14
12 93
52 72
12 61
100 56
13 26
57 56
9 18
64 22
7 71
30 75
51 81
39 90
59 70
38 57
75 50
29 92
40 51
 91 75
9 56
71 29
54 65
86 99
3 54
12 35
12 45
6 89
7 24
80 81
87 55
28 28
47 59
50 2
64 21
10 79
39 99
34 86
28 36
43 17
10 51
97 94
10 56
46 41
23 56
64 26
27 30
58 62
60 7
12 55
63 44
11 79
26 58
95 56
62 74
46 20
1 75
56 5
57 22
16 89
89 42
64 22
72 60
46 35
100 22
25 100
83 21
 35 21
43 13
95 51
82 16
93 78
38 11
25 59
28 4
100 24
31 5
5 83
94 19
84 52
92 46
27 10
91 97
7 42
70 75
5 7
51 32
16 69
43 99
92 82
37 77
74 75
80 40
33 7
17 9
84 85
79 1
32 23
100 25
70 40
17 39
37 62
3 2
93 26
76 76
30 78
71 41
87 80
83 74
60 100
80 33
63 1
50 90
56 79
36 35
46 91
 Variable X X + 10 X - 10 X / 10 X * 10
75 85 65 7.5 750
66 76 56 6.6 660
51 61 41 5.1 510
41 51 31 4.1 410
54 64 44 5.4 540
81 91 71 8.1 810
83 93 73 8.3 830
61 71 51 6.1 610
40 50 30 4 400
71 81 61 7.1 710
48 58 38 4.8 480
72 82 62 7.2 720
87 97 77 8.7 870
51 61 41 5.1 510
58 68 48 5.8 580
76 86 66 7.6 760
86 96 76 8.6 860
77 87 67 7.7 770
67 77 57 6.7 670
44 54 34 4.4 440

Mean 64.45 74.45 54.45 6.445 644.5

Median 66.5 76.5 56.5 6.65 665
Mode 51 61 41 5.1 510
Std. Dev. 15.3261902 15.32619 15.32619 1.532619 153.2619
Variance 234.892105 234.8921 234.8921 2.348921 23489.21
 Fixed Values Lower Limit Upper Limit C.I. Frequency
137 139 120 140 120-140 22
144 150 140 160 140-160 26
185 134 160 180 160-180 28
120 190 180 200 180-200 24
173 198
169 152
167 198 Mean 161.37
122 146 Reqd. Mean 180
153 170 Difference 18.63
127 163
125 168 New Mean 180
138 162
141 172
175 140
191 154
126 151
123 164
161 160
183 186
142 182
151 165
147 122
165 143
173 132
198 148
158 168
150 148
171 192
130 130
180 189
179 197
196 142
199 130
194 154
165 157
186 171
188 129
169 180
189 176
174 131
173 198
183 132
129 140
130 139
128 166
163 180
180 124
173 170
136 157
195 150
186 191
133 178
176 175
198 185
168 185
133 181
192 163
130 188
175 137
146 176
190 197
194 139
174 183
158 156
123 161
162 149
139 196
199 189
125 122
151 196
180 133
191 124
182 195
184 148
175 152
131 148
127 177
179 153
200 175
147 165
138 162
199 167
190 148
138 121
122 188
127 195
179 151
139 181
191 127
127 156
123 150
128 157
143 164
172 156
197 169
180 167
199 121
177 137
188 200
121 164

100
Adj. Seriers
157.63
168.63
152.63
208.63
216.63
170.63
216.63
164.63
188.63
181.63
186.63
180.63
190.63
158.63
172.63
169.63
182.63
178.63
204.63
200.63
183.63
140.63
161.63
150.63
166.63
186.63
166.63
210.63
148.63
207.63
215.63
160.63
148.63
172.63
175.63
189.63
147.63
198.63
194.63
149.63
216.63
150.63
158.63
157.63
184.63
198.63
142.63
188.63
175.63
168.63
209.63
196.63
193.63
203.63
203.63
199.63
181.63
206.63
155.63
194.63
215.63
157.63
201.63
174.63
179.63
167.63
214.63
207.63
140.63
214.63
151.63
142.63
213.63
166.63
170.63
166.63
195.63
171.63
193.63
183.63
180.63
185.63
166.63
139.63
206.63
213.63
169.63
199.63
145.63
174.63
168.63
175.63
182.63
174.63
187.63
185.63
139.63
155.63
218.63
182.63
 X X - Mean (X - Mean)^2 (X - Mean)^3 (X - Mean)^4
2 -20.5 420.25 -8615.125 176610.0625
3 -19.5 380.25 -7414.875 144590.0625
5 -17.5 306.25 -5359.375 93789.0625
7 -15.5 240.25 -3723.875 57720.0625
8 -14.5 210.25 -3048.625 44205.0625
10 -12.5 156.25 -1953.125 24414.0625
11 -11.5 132.25 -1520.875 17490.0625
23 0.5 0.25 0.125 0.0625
67 44.5 1980.25 88121.125 3921390.0625
89 66.5 4422.25 294079.625 19556295.063
Count 10
Mean 22.5
Sum 0 8248.5 350565 24036503.625
µ1 0
µ2 824.85
µ3 35056.5
µ4 2403650
Marks Marks (Fixed)
93 51 Marks (Fixed) Count of Marks (Fixed)
62 91 0-9 17
8 32 10-19 20
96 75 20-29 16
66 63 30-39 25
93 86 40-49 15
51 68 50-59 24
53 42 60-69 25
200 250
50 29 70-79 20
250180
27 58 80-89 18 160 200
28 46 90-100 20 200140
60 61 Total Result 200 120 150
150
19 64 100
82 29 10080 100
38 32 60
5040 50
51 98
20
56 91 0
0 0
21 95 9 9 9 9 9 9
0-0-9 0-10-190-200--9290-03-01-9390-400-2-4990-500-3-
72 54 1 1 2 2 3 13 4 24 5 35
0 38
43 82
75 97
22 49
32 78
99 3
41 81
53 76
73 90
24 64
74 58
98 69
34 18
36 55
53 52
72 67
34 68
31 43
98 97
29 66
43 60
94 80
80 38
47 84
12 21
11 50
90 27
92 50
 66 100
37 70
82 1
3 55
41 7
16 12
24 71
39 19
21 80
39 39
67 47
26 27
22 19
1 73
83 76
30 45
18 30
91 60
85 28
10 5
1 65
98 40
31 76
10 100
83 87
46 16
20 59
7 21
77 37
89 74
20 14
100 59
64 99
71 69
51 72
96 14
14 13
76 49
89 1
38 70
53 75
29 32
88 36
56 27
11 2
90 12
45 53
82 38
85 57
10 20
91 23
67 81
62 30
22 16
49 84
23 64
33 6
75 1
15 72
94 68
51 62
10 29
2 57
26 41
71 17
74 38
12 50
64 91
1 93
48 61
53 19
38 37
83 87
4 84
55 58
19 61
4 31
85 95
4 31
17 58
39 10
74 36
32 4
84 8
27 28
47 10
49 88
68 41
44 37
93 86
37 82
46 1
86 98
37 18
88 13
24 73
 65 23
2 21
13 32
25 95
38 70
30 34
57 84
44 31
87 52
95 98
37 90
61 61
78 52
48 60
33 58
86 43
61 17
83 40
17 4
26 77
32 29
22 62
44 94
20 31
0 41
43 0
7 45
60 69
94 76
47 47
98 34
28 100
30 59
48 67
91 35
29 17
42 13
96 4
46 28
19 75
100 65
68 64
56 8
38 18
41 79
26 55
33 80
30 85
 95 5
11 56
22 58
35 83
79 37
48 76
3 39
97 95
100 9

200
 84
Marks (Fixed) Count of Marks (Fixed)
0-9 17
10-19 20
20-29 16
30-39 25
Total Total 40-49 15
250
Total 50-59 24
60-69 25
200 70-79 20
80-89 18
150 90-100 20
Count of Marks
Count (Fixed)
of Marks (Fixed) Total Result 200
Count of Marks (Fixed)
100

50

0
9 9 9 9 9 9 9 9 9 0 lt
0-0-9 0-10-190-200--9290-03-01-9390-400-2-4990-500-3-5990-600--46909-7 00--57099-8 0-68-910 -01-07e09su 0s-u8l9t -100 sult
1 1 2 2 3 13 4 24 5 35 6 46 7 57 8 6890 907l R R8e 90 e Marks (Fixed)
ta tal a lR
t
To To To 0-9
10-19
20-29
30-39
40-49
50-59
60-69
70-79
80-89
90-100
Total Result
 34
59
80
52
89
72
32
16
51 49 Column M
70 24 1
89 40 2
58 13 3
99 74 4
81 16 5
40 84 6
56 96 7
58 45 8
91 22 9
74 52 10
5 65 11
55 4 12
67 47 13
75 26 14
50 32 15
46 59 16
53 53 17
31 72 18
94 89 19
93 25 20
75 7 21
3 38 22
99 77 24
40 84 25
14 46 26
60 71 27
76 59 28
40 89 29
21 17 31
53 90 32
59 69 33
94 50 34
94 77 35
78 12 36
76 93 37
70 2 38
46 56 40
8 33 41
67 44 42
18 36 43
32 8 44
80 18 45
53 39 47
75 79 48
9 89 49
23 98 50
40 17 51
23 74 53
56 34 54
20 62 56
48 55 57
52 82 58
25 6 59
14 64 60
56 54 61
37 16 62
37 48 63
64 18 64
4 52 65
52 23 67
62 12 68
52 2 70
52 3 71
81 48 73
34 90 74
37 49 75
7 73 76
31 99 77
11 86 78
28 42 79
57 19 80
59 8 81
10 59 82
70 19 83
86 45 84
39 62 85
9 16 86
73 98 87
80 77 88
26 28 89
91 62 90
86 90 91
92 72 92
19 3 93
80 84 95
1 7 96
47 77 98
48 64 99
73 36 100
50 76 Total Result
74 81
71 10
42 57
65 70
70 74
99 27
75 94
11 84
60 24
67 90
28 59
56 24
92 15
65 42
54 65
79 1
47 34
32 27
75 9
23 98
80 85
69 42
36 63
48 99
46 9
31 55
30 70
16 43
89 82
99 56
57 79
87 48
90 89
63 15
40 50
56 12
85 29
40 96
91 24
52 8
6 90
8 89
62 98
77 69
38 99
68 28
14 69
67 13
43 84
43 70
1 77
91 92
67 66
18 56
60 53
34 91
94 3
77 89
21 19
28 62
94 69
45 94
98 74
48 57
17 44
61 19
34 6
84 68
38 16
36 94
24 20
59 9
3 22
87 99
58 88
63 18
97 26
14 4
41 51
22 39
30 83
35 49
21 87
95 29
66 90
86 17
54 75
80 17
62 90
9 90
38 22
4 73
35 100
21 24
77 34
52 60
10 16
90 2
57 24
49 13
25 62
5 88
1 59
93 41
91 86
42 46
41 23
88 71
9 33
29 80
86 36
63 94
22 39
61 73
66 98
50 39
91 66
2 31
75 26
99 98
50 5
65 89
29 58
87 52
57 99
17 5
64 47
99 85
37
82
18
63
79
6
30
71
nt of Marks (Fixed) 48

Count of Marks (Fixed)

17
20
16
25
15
24
25
20
18
20
200
Data
Count of 32_ Sum - Column M
5 5
3 6
1 3
2 8
1 5
1 6
2 14
6 48
2 18
4 40
4 44
2 24
4 52
5 70
3 45
2 32
2 34
4 72
4 76
1 20
2 42
1 22
3 72
2 50
4 104
2 54
2 56
5 145
1 31
2 64
2 66
3 102
1 35
2 72
1 37
1 38
4 160
3 123
4 168
3 129
1 44
1 45
2 94
2 96
3 147
1 50
2 102
2 106
4 216
1 56
3 171
2 116
4 236
2 120
1 61
1 62
2 126
4 256
3 195
4 268
5 340
 1 70
2 142
2 146
1 74
3 225
5 380
2 154
3 234
1 79
3 240
4 324
5 410
2 166
2 168
1 85
5 430
2 174
2 176
3 267
1 90
3 273
1 92
3 279
4 380
2 192
4 392
2 198
1 100
226 11039
 X (Advertisement) Y (Sales) x y x^2 y^2 xy
288 597 54.5 105.375 2970.25 11103.89 5742.938
218 594 -15.5 102.375 240.25 10480.64 -1586.813
225 533 -8.5 41.375 72.25 1711.891 -351.6875
228 441 -5.5 -50.625 30.25 2562.891 278.4375
200 409 -33.5 -82.625 1122.25 6826.891 2767.938
211 412 -22.5 -79.625 506.25 6340.141 1791.563
227 449 -6.5 -42.625 42.25 1816.891 277.0625
271 498 37.5 6.375 1406.25 40.64063 239.0625

Mean 233.5 491.625

Sum 1868 3933 0 0 6390 40883.88 9158.5

Correlation 0.566628
Covariance 1144.813

Excel Functions
Correlation 0.566628
Covariance 1144.813
 54.5 105.375
-15.5
-8.5
-5.5
-33.5
-22.5
-6.5
37.5

261247961 16163.17
Salesmen Intelligence Score Sales (Weekly) R1 R2 D^2
A 55 56 6 4 4
B 60 60 5 3 4
C 50 42 7 6 1
D 65 45 4 5 1
E 80 90 1 1 0
F 70 30 3 8 25
G 75 70 2 2 0
H 40 40 8 7 1
I 20 15 9 9 0

Sum 36
N 9
N(N^2 - 1) 720
Rank Correlation 0.7
 Share Price (x) Dividend (Y)
14 31
19 26
24 48
21 37
26 50
22 45
15 33
20 41
19 39

Correlation 0.81667385984
Coefficient of Determination 0.66695619335
Slope (Y on X) 1.69166666667
Intercept (Y on X) 5.05555555556
Equation (Y on X) Y = 5.05 + 1.69 X

Slope (X on Y) 0.39425981873
Intercept (X on Y) 4.66767371601
Equation (X on Y) X = 4.67 + 0.394 Y
Year (X) Annual Sales (Y) Trend
2011 135 -0.813187 Err:509
2012 150 95.91209
2013 167 192.6374
2014 176 289.3626 a+bx
2015 120 386.0879
2016 560 482.8132
2017 600 579.5385
2018 760 676.2637
2019 899 772.989
2020 800 869.7143
2021 900 966.4396
2022 1000 1063.165
2023 1267 1159.89

Intercept -194515.3406593 -194515.340659 -194515

Slope 96.725274725275 96.72527472527 96.72527

Year Trend Line Forecast Trend Function

2040 2804.2197802198 2804.22 2804.21978022
 Chart Title
0.761

0.76

0.759

0.758

0.757

0.756

0.755

0.754

0.753

0.752

0.751
1 2 3
Commodity P0 Q0 P1 Q1 P1Q0 P0Q0 P1Q1 P0Q1
A 10 32 14 32 448 320 448 320
B 12 22 18 20 396 264 360 240
C 15 12 20 12 240 180 240 180
D 20 18 24 18 432 360 432 360
E 26 6 30 8 180 156 240 208
Sum 1696 1280 1720 1308

Laspeyre's 1.325 0.760465 1000 1.325 1.325

Paasche's 1.314985 0.754717 1101 1.314985 1.314985
Fisher (P10) 1.319983 0.757586 1 1.319983 1.319983
Dorbish 1.319992 1.319992 1.319992
Marshall 131.9938 131.9938 ((
P0Q1 P1Q1
140 448
216 360
300 240
480 432
780 240
#NAME?