QAF_Assignment_IInd

QAF_Assignment_IInd - Transcript

MBA 14C BLR0907033098

Introduction
Statistical analysis is very important because by this we came to know about the trends of change We can also predict future prospect by interpretation of data There are different hypothesis and tests are available to analyze the figures This report is analysis of spices production in the years of 2002 to 2006 in different states of India For this I used various tools of data analysis such as measure of central tendency dispersion scatter plot and different tests

Scatter Plot
State
Tamil Nadu

Measure
Area Production Area Production

2002
4000 870 10410 2320

2003
4180 930 13840 3870

2004
4120 910 24260 5430

2005
3750 4450 14797 12000

2006
3700 4000 15150 12000

Shift
7 50 359 77 45 53 417 24

Karnataka

Table 1 1 Pepper Production in southern states of India

We can observe that the area of the production in Tamil Nadu is a bit decreased in this time period but production of pepper has increased It became 3 5 times of 2002 in 2006 In Karnataka area of production has increased by 46 and production has increased by 417 It means that in Tamil Nadu farmers are using good seeds and they are using good method for the production of pepper It can also be interpreted that the land of Tamil Nadu is better than the Karnataka for the production of Pepper

Statistical Parameters and Measure of Central Tendency
This is the analysis of production of Pepper in the year of 2002 to 2006
State Mean Harmon ic mean Geomet ric mean Median Standard Deviatio n Variance Quartil e 25 Quartil e 50 Quartil e 75

Quartile

Maximum Value

Andaman Nicobar Andhra Pradesh Arunachal Pradesh Assam Bihar Chhatisgarh Gujarat Himachal Pradesh Jammu

356 388302 1840 8436 2962 641 14682 292 4

2004 NA 371435 1803 8435 2946 632 14366 NA

NA 379756 1821 8436 2954 636 14529 NA NA

469 400920 1790 8420 2880 640 14690 99 0

334 91574 303 86 254 82 2285 477 9

111373 8385719 820 91600 7480 64729 6752 522025 6 227166 80

0 320680 1630 8400 2870 620 14120 90 0

469 400920 1790 8420 2880 640 14690 99 0

640 417820 1950 8500 2981 680 16510 130 0

670

518550 2300 8540 3380 743 16909 1140 20

Kashmir Karnataka Kerala Madhya Pradesh Maharashtra Manipur Meghalaya Mizoram Nagaland Orissa Rajasthan Sikkim Tamil Nadu Tripura Uttar Pradesh Uttaranchal West Bengal 50476 7410 611 8446 240 10328 9072 2204 56964 320 1716 113798 4322 3342 5912 25090 NA 43722 7113 607 8444 222 9971 3293 151 56937 262 1681 97118 4146 2746 5468 46920 7257 609 8445 231 10137 5148 713 56950 286 1699 105268 4230 3006 5702 24938 47390 6940 610 8508 230 9440 2790 3599 56420 210 1740 118450 3750 2140 6068 24500 21668 1731 53 133 67 2372 10051 1956 1415 183 254 48172 1038 1789 1644 3143 4695182 80 299530 0 2830 17767 4550 5624070 1010148 19 382659 8 200223 0 33350 64280 232054 8570 1077870 3198820 270206 3 9877450 33890 6240 585 8430 230 8680 2260 62 55980 200 1700 67250 3750 2140 5240 24480 47390 6940 610 8508 230 9440 2790 3599 56420 210 1740 118450 3750 2140 6068 24500 60030 8240 640 8530 280 10510 14202 3599 57090 370 1920 143360 4820 4400 7390 25050 82470 9980 680 8540 320 14350 24460 3700 59360 620 1920

175390 5910 6000 7390 30070

Analysis The different measures of central tendencies and other data analysis tools have been calculated in above table Production of the Pepper is highest in the 3rd quartile also we can observe that southern states are more productive than other states of India in the production of Pepper

Testing of hypothesis
The testing of hypothesis calculated to arrive at a conclusion and to show the relationship between 2 variables There are 3 methods for calculating hypothesis T Test Z Test Chi square Test In this analysis I have chosen T Test because the sample size is less than 30 Let Ho Production of Pepper between 2 years 2003 and 2004 has increased

H1 Production of Pepper between 2 years 2003 and 2004 has increased Level of significance is 0 05 after testing of statics we calculated tcal 0 490637 ttab 1 6475

tcal ttab
Hence Ho is accepted so the production between two years has increased

Conclusion
Thus report on the production of pepper in different states of India has been using the measures of Central Tendencies and Testing of Hypothesis Analysis of such statics helps us to understand the production in different regions

Appendix
Table 1 2 Data extracted from Spice board Corporation of India
State Andaman Nicobar Andhra Pradesh Arunachal Pradesh Assam Bihar Chhattisgarh Gujarat Himachal Pradesh Jammu Kashmir Karnataka Kerala Madhya Pradesh Maharashtra Manipur Meghalaya Mizoram Nagaland Orissa Area 2002 0 56820 510 12070 2900 680 840 0 20 6600 3140 560 6640 330 1540 290 610 23640 Productio n 2002 0 283540 1950 8320 2870 520 14690 0 20 28600 6940 540 8220 230 8680 2790 3599 55970 Area 2003 0 58440 450 12250 2980 680 950 120 0 8070 2770 660 6810 330 1560 280 650 23780 Productio n 2003 0 320680 1530 8420 2880 620 11180 130 0 47390 5650 680 8530 230 8660 2260 3700 56420 Ar ea 20 04 60 60 36 0 510 117 00 27 90 740 10 20 16 40 0 10 85 0 28 80 66 0 68 30 47 0 167 0 20 0 67 0 23 55 Production 2004 670 417820 1790 8400 2700 640 14120 1140 0 60030 6240 640 8540 320 9440 1650 3599 55980 Area 2005 90 69990 430 11610 3530 770 1400 150 0 6350 3380 670 6760 200 1820 811 18 24020 Product ion 2005 640 518550 1630 8500 3380 680 16510 90 0 33890 8240 610 8430 140 10510 14202 62 57090 Area 2006 80 64500 600 11740 3038 879 1297 187 0 12720 3920 670 6798 400 1910 1740 18 24730 on 2006 469 400920 2300 8540 2981 743 16909 99 0 82470 9980 585 8508 280 14350 24460 62 59360

Producti

0 Rajasthan Sikkim Tamil Nadu Tripura Uttar Pradesh Uttaranchal West Bengal 130 430 17300 1340 1120 470 11730 210 1300 64540 5910 2030 3470 21350 90 510 16180 1470 1130 650 12620 370 1700 67250 4820 2140 7390 24500 90 52 0 216 20 110 0 113 0 65 0 124 00 200 1740 118450 3750 2140 7390 24480 80 580 25970 1110 1000 560 11840 200 1920 143360 3750 4400 5240 25050 140 580 30530 1150 2000 630 13660 620 1920 175390 3380 6000 6068 30070

Production of Pepper State Year Andam an Nicoba r Andhra Prades h Arunac hal Prades h Assam Bihar Chhatis garh Gujarat Himac hal Prades h Jammu Kashm ir Karnat aka Kerala Madhy a Prades h Mahara shtra Manip ur Meghal aya Mizora m Nagala nd Orissa Rajasth an Sikkim Tamil Nadu Tripura Uttar Prades 2002 0 2003 0 2004 670 2005 640 2006 469

283540

320680

417820

518550

400920

1950 8320 2870 520 14690 0

1530 8420 2880 620 11180 130

1790 8400 2700 640 14120 1140

1630 8500 3380 680 16510 90

2300 8540 2981 743 16909 99

20 28600 6940 540 8220 230 8680 2790 3599 55970 210 1300 64540 5910 2030

0 47390 5650 680 8530 230 8660 2260 3700 56420 370 1700 67250 4820 2140

0 60030 6240 640 8540 320 9440 1650 3599 55980 200 1740 118450 3750 2140

0 33890 8240 610 8430 140 10510 14202 62 57090 200 1920 143360 3750 4400

0 82470 9980 585 8508 280 14350 24460 62 59360 620 1920 175390 3380 6000

h Uttaran chal West Bengal

3470 21350

7390 24500

7390 24480

5240 25050

6068 30070

References
STATE SPICE WISE AREA AND PRODUCTION OF SPICES IN INDIA n d Retrieved 10 25 2009 from indianspices com http www indianspices com pdf state prd pdf