0% found this document useful (0 votes)
13 views10 pages

Sales Profit Analysis and Metrics

The document contains statistical data on sales and profit, including measures such as mean, median, mode, and standard deviation. It also provides a breakdown of profit counts across different ranges and compares commodity prices and quantities between base and current periods. Additionally, various price indices, including Laspeyres, Paasche, and Fisher's, are calculated to analyze price changes.

Uploaded by

sarveshmov
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
13 views10 pages

Sales Profit Analysis and Metrics

The document contains statistical data on sales and profit, including measures such as mean, median, mode, and standard deviation. It also provides a breakdown of profit counts across different ranges and compares commodity prices and quantities between base and current periods. Additionally, various price indices, including Laspeyres, Paasche, and Fisher's, are calculated to analyze price changes.

Uploaded by

sarveshmov
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

sales profit measure sales profit

730 50 mean 545.0392 56.64706


838 56 median 558.5 57
344 64 mode 152 40
359 72 q3 792.25 79
117 17 p80 841.2 83.8
575 13 skew 0.005271 -0.031519
557 88 kurtosis -1.429861 -1.280354
958 58
801 79
981 83
934 19
317 23
831 69
913 46
909 33
388 74
197 94
152 84
218 22
871 52
227 85
337 50
359 46
389 27
880 99
152 95
560 79
743 92
869 12
125 12
719 40
648 52
888 95
936 38
171 96
770 50
762 52
387 94
529 25
585 60
983 41
551 97
278 50
626 27
753 92
599 91
314 29
875 72
608 21
842 72
105 82
239 23
298 37
194 65
121 76
238 71
236 31
138 69
369 87
781 33
930 74
348 89
651 42
674 77
699 13
290 32
666 94
350 26
747 75
919 11
888 79
168 96
465 66
324 69
232 33
700 82
973 34
796 25
931 46
942 95
341 90
741 49
226 34
222 81
511 41
271 65
684 40
681 98
338 43
242 73
304 40
267 24
525 63
288 40
144 37
608 59
735 93
556 59
798 22
489 13
876 70
880 25
sales Profit

Mean 560.3861 Mean 56.20792


Standard Error 27.21796 Standard Error 2.605832
Median 613 Median 55
Mode 667 Mode 81
Standard Deviation 273.5371 Standard Deviation 26.18829
Sample Variance 74822.54 Sample Variance 685.8263
Kurtosis -1.23668 Kurtosis -1.197233
Skewness -0.20528 Skewness -0.180534
Range 893 Range 86
Minimum 100 Minimum 11
Maximum 993 Maximum 97
Sum 56599 Sum 5677
Count 101 Count 101
Largest(1) 993 Largest(1) 97
Smallest(1) 100 Smallest(1) 11
sales profit
862 23 profit Count of profit
120 79 10-19 14
427 68 20-29 14
294 38 30-39 11
831 25 40-49 12
311 12 50-59 9
756 39 60-69 10
188 82 70-79 11
143 72 80-89 10
286 96 90-99 11
624 59 Total Result 102
814 71
553 17
396 78
Total
682 79 120
757 12
100
734 68
779 34 80
131 76
Count of profit
340 88 60
950 88
40
440 20
302 14 20
533 99
784 71 0
10-19 20-29 30-39 40-49 50-59 60-69 70-79 80-89 90-99 Total
388 35 Result
180 55
116 31
714 10
808 96
333 87
749 92
818 64
832 88
605 53
970 44
961 89
768 42
480 61
686 65
875 94
300 78
151 80
968 67
198 44
323 83
134 80
995 31
563 15
810 16
940 35
689 53
735 88
342 78
699 77
755 65
559 93
882 52
473 39
472 32
568 64
266 96
697 90
660 12
598 88
890 35
868 90
929 95
702 55
952 32
980 78
898 99
782 93
987 63
971 73
299 35
290 81
187 97
482 19
128 47
432 21
506 43
132 39
279 21
886 32
179 42
786 60
669 66
735 84
715 25
799 12
172 45
554 20
773 47
231 78
415 68
822 65
391 51
855 27
902 46
365 11
179 85
Count of profit

0-99 Total
Result
commodity base period current period
price quantity price quantity
A 10 32 14 32
B 12 22 18 20
C 15 12 20 12
D 20 18 24 18
E 26 6 30 8

p0 q0 p1 q1
A 10 32 14 32
B 12 22 18 20
C 15 12 20 12
D 20 18 24 18
E 26 6 30 8

SUM

laspeyre index 132.5


paasche index 131.498470948012
fisher's index 131.998285597244
p0q0 p0q1 p1q0 p1q1
320 320 448 448
264 240 396 360
180 180 240 240
360 360 432 432
156 208 180 240

1280 1308 1696 1720

You might also like