ASSIGNMENT NO.3

STATISTICS AND RESEARCH METHODOLOGY

1. The hypothesis to be tested :H0: =1=2=3=4H1: 1234

2. Sector selected : I have selected FMCG sector as this is a competitive and most commonly used products making sector in INDIA.

3. Companies selected : I have selected the 5 countries in FMCG sector which has major contribution in this sector in India. The companies are 1.ITC, 2. HUL, 3. COLGATE, 4.P & G., 5.Emani.

4. Time period for data collection : As I have taken the Net Profits of these 5 companies for consecutive 5 years for the month of March starting from 07 to March, 11. The profit figures are in Crores.

5. Analysis tables:NET PROFIT (RS.in CRORES)

MAR.07MAR.08MAR.09MAR.10MAR.11

ITC2699.973120.13263.5940614987.61

HUL1855.371769.062500.712202.032305.97

COLGATE167.68191.4173.93246.95255.04

P & G89.82131.42178.85179.77150.88

EMANI46.877.82612.57560.84482.44

We have given 5% significance level for Analysis of Variance.

6. Graphs if any :

F calculated=0.152F critical=2.866

7.Conclusion : We have calculated values from ANOVA for F critical and F calculated at 5 % significance level. As the value of F calculated is less than the value of F critical. So, the null hypothesis we have used for analysis of profits of 5 companies is accepted. Through which we came to know Companies from the same sector perform in a similar way.

Sheet4Anova: Single FactorSUMMARYGroupsCountSumAverageVarianceColumn 154859.64971.9281511847.52667Column 255289.81057.961832040.4036Column 356729.651345.932071103.335Column 457250.591450.1182808572.27807Column 558181.941636.3884281370.31247ANOVASource of VariationSSdfMSFP-valueF critBetween Groups1518662.8397844379665.7099460010.15180636470.95998084862.8660814021Within Groups50019735.42324202500986.771162

Total51538398.26302424

Sheet1NET PROFIT (RS.in CRORES)

MAR.07MAR.08MAR.09MAR.10MAR.11ITC2699.973120.13263.5940614987.61HUL1855.371769.062500.712202.032305.97COLGATE167.68191.4173.93246.95255.04P & G89.82131.42178.85179.77150.88EMANI46.877.82612.57560.84482.44

Sheet2

Sheet3