Scribd Logo
Upload

Welcome to Scribd!

  • 31 views

    Statistics

    Uploaded by

    shiraj_sg
    This document shows sales turnover and compensation data for ITC from 1994-95 to 2006-07. There is a strong positive correlation between sales and compensation, with an R-square value of 0.990, indicating sales can explain 99% of the variation in compensation. As sales increased each year, compensation also increased at a rate of about 26 units for every 1 unit increase in sales.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Statistics

    Uploaded by

    shiraj_sg
    31 views16 pages
    This document shows sales turnover and compensation data for ITC from 1994-95 to 2006-07. There is a strong positive correlation between sales and compensation, with an R-square value of 0.990, indicating sales can explain 99% of the variation in compensation. As sales increased each year, compensation also increased at a rate of about 26 units for every 1 unit increase in sales.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document shows sales turnover and compensation data for ITC from 1994-95 to 2006-07. There is a strong positive correlation between sales and compensation, with an R-square value of 0.990, indicating sales can explain 99% of the variation in compensation. As sales increased each year, compensation also increased at a rate of about 26 units for every 1 unit increase in sales.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    31 views16 pages

    Statistics

    Uploaded by

    shiraj_sg
    This document shows sales turnover and compensation data for ITC from 1994-95 to 2006-07. There is a strong positive correlation between sales and compensation, with an R-square value of 0.990, indicating sales can explain 99% of the variation in compensation. As sales increased each year, compensation also increased at a rate of about 26 units for every 1 unit increase in sales.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 16

    Year Rainfall Q1

    1995 110 130 + (135-130)/4


    1996 120
    1997 130
    1998 135 Q3
    1999 140 160 + (170-160) *3/4
    2000 150
    2001 160
    2002 170
    2003 180
    2004 190

    Q1 131.25
    Q2 145
    Q3 167.5

    Q1=n+1/4

    2.75
    2nd term + .75(3rd term - 2nd term)
    Q3=3 *(n+1)/4

    8.25
    8th term + .25(9th term - 8th term)
    Column1

    Mean 148.5
    Standard Error 8.30160627027485
    Median 145
    Mode #N/A
    Standard Deviation 26.2519840520039
    Sample Variance 689.166666666667
    Kurtosis -1.03330901307007
    Skewness 0.18861935907316
    Range 80
    Minimum 110
    Maximum 190
    Sum 1485
    Count 10
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10

    Q1 3.25
    Q2 5.5
    Q3 7.75
    162.6
    164.1
    174.4
    176.9
    184.6
    186.5
    189.8
    190
    207.1
    207.7
    226.5
    226.7
    227.7
    230.7
    234.1
    237.2
    238.9
    243.1
    248.2
    253.5
    255.5
    261.1
    268.4
    268.8
    274.6
    281.7
    283.8
    290.1
    291.7
    299.9
    303.9
    318.8
    340.1
    394.5
    403.5
    412.7

    Q1 207.55
    Q2 245.65
    Q3 285.375
    Q.
    Month Adv Sales
    Jan 10 110
    Feb 11 120
    Mar 12 115
    Apr 13 128
    May 11 137
    Jun 10 145
    Jul 9 150
    Aug 10 130
    Sep 11 120
    Oct 14 115
    Adv Sales
    Adv 1
    Sales -0.518849 1
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.5188491878
    R Square 0.2692044797
    Adjusted R Square 0.1778550397
    Standard Error 12.232349847
    Observations 10

    ANOVA
    df SS MS F
    Regression 1 440.956937799043 440.9569 2.946975
    Residual 8 1197.04306220096 149.6304
    Total 9 1638

    Coefficients Standard Error t Stat P-value


    Intercept 177.98564593 29.9510661213404 5.942548 0.000345
    Adv -4.593301435 2.67569588296946 -1.716675 0.124371
    Significance F
    0.124371054542358

    Lower 95% Upper 95% Lower 95.0% Upper 95.0%


    108.91836360343 247.0529282626 108.91836360343 247.052928262599
    -10.763467206083 1.57686433527 -10.763467206083 1.57686433526963
    Q. ITC has come a long way in becoming an FMCG company from the tobacco industry. Today ITC has a strong

    Year Sales Comp


    1994-95 45603.6 1287.2
    95-96 51351.6 1500.2
    96-97 58687.6 1733.1
    97-98 68509.3 2061.3
    98-99 75992.4 2030.6
    99-00 79719.4 2567.7
    00-01 86997.5 2744.3
    2001-2002 98491.6 3184.6
    2002-2003 110284.1 3533.7
    2003-2004 118197.7 4226
    2004-2005 133611.3 4812.6
    2005-2006 162366.5 5616.7
    2006-2007 190050.6 6504.7
    ustry. Today ITC has a strong presence in many industries other than tobacco - paper boards, paper & packaging, hotels, & other FMCG
    g, hotels, & other FMCG products. The following table shows the sales turnover & compensation to employees by ITC from 1994-95 to 2
    y ITC from 1994-95 to 2006-07.
    Sales Comp
    Sales 1
    Comp 0.995112 1
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.995112482994723
    R Square 0.990248853811924
    Adjusted R Square 0.989362385976645
    Standard Error 4487.54176591092
    Observations 13

    ANOVA
    df SS MS F
    Regression 1 22495641039.59 22495641039.59 1117.0725145
    Residual 11 221518342.1087 20138031.1008
    Total 12 22717159381.7

    Coefficients Standard Error t Stat P-value


    Intercept 13844.3351543866 2820.84377174 4.90787022418 0.000465753
    Comp 26.3113828291707 0.78723245535 33.42263476354 2.055855E-12

    y=mx+c
    y=sales
    m=coefficient of compensation
    c=coefficient of intercept
    Significance F
    2.0558546423859E-12

    Lower 95% Upper 95% Lower 95.0% Upper 95.0%


    7635.69987384946 20052.9704349237 7635.699873849 20052.9704349237
    24.5786958774026 28.0440697809388 24.5786958774 28.0440697809388

    You might also like