Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 9 views

    Statistics Correlation

    Uploaded by

    BilalGujjar
    This document contains sales revenue and advertising expense data for multiple companies over several years. It also includes calculations of averages, variances from averages, and correlations between sales revenue and advertising expenses. Specifically, it analyzes the relationships between annual sales (Y) and advertising spending (x) for CocaCola, ICI, Nike, P&G, PepsiCo and several other companies from 2009 to 2013. Correlation coefficients are presented, indicating generally strong positive correlations between advertising and sales for most companies.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Statistics Correlation

    Uploaded by

    BilalGujjar
    9 views4 pages
    This document contains sales revenue and advertising expense data for multiple companies over several years. It also includes calculations of averages, variances from averages, and correlations between sales revenue and advertising expenses. Specifically, it analyzes the relationships between annual sales (Y) and advertising spending (x) for CocaCola, ICI, Nike, P&G, PepsiCo and several other companies from 2009 to 2013. Correlation coefficients are presented, indicating generally strong positive correlations between advertising and sales for most companies.

    Original Description:

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains sales revenue and advertising expense data for multiple companies over several years. It also includes calculations of averages, variances from averages, and correlations between sales revenue and advertising expenses. Specifically, it analyzes the relationships between annual sales (Y) and advertising spending (x) for CocaCola, ICI, Nike, P&G, PepsiCo and several other companies from 2009 to 2013. Correlation coefficients are presented, indicating generally strong positive correlations between advertising and sales for most companies.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    9 views4 pages

    Statistics Correlation

    Uploaded by

    BilalGujjar
    This document contains sales revenue and advertising expense data for multiple companies over several years. It also includes calculations of averages, variances from averages, and correlations between sales revenue and advertising expenses. Specifically, it analyzes the relationships between annual sales (Y) and advertising spending (x) for CocaCola, ICI, Nike, P&G, PepsiCo and several other companies from 2009 to 2013. Correlation coefficients are presented, indicating generally strong positive correlations between advertising and sales for most companies.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    CocaCola Co.

    Year
    2009
    2010
    2011
    2012
    2013

    Amounts in million $
    Sales Revenue (Y)
    Advertisment expense (x)
    30990
    288
    35119
    290
    46542
    349
    48017
    295
    46854
    363

    ICI

    2009
    2010
    2011
    2012
    2013

    Amounts in Rs '000'
    Sales Revenue (Y)
    Advertisment expense (x)
    32399181
    344065
    39532506
    352098
    35516114
    130321
    34681563
    144047
    18315678
    66288

    2009
    2010
    2011
    2012
    2013

    Amounts in million $
    Sales Revenue (Y)
    Advertisment expense (x)
    19176
    2352
    19014
    2356
    20862
    2448
    23331
    2607
    25313
    2745

    Year
    2009
    2010
    2011
    2012
    2013

    Amounts in millions of $
    Sales Revenue (Y)
    Advertisment expense (x)
    76694
    7519
    78938
    8576
    81104
    9200
    83680
    9300
    84167
    9700

    Year

    NIKE
    Year

    P&G

    Pepsi Co.
    Amounts in millions of $

    X-XX
    -29
    -27
    32
    -22
    46

    Y-
    -10514.4
    -6385.4
    5037.6
    6512.6
    5349.6

    (X-XX)

    X-XX
    136701.2
    144734.2
    -77042.8
    -63316.8
    -141075.8

    Y-
    310172.6
    7443497.6
    3427105.6
    2592554.6
    -13773330

    X-XX
    -149.6
    -145.6
    -53.6
    105.4
    243.4

    Y-
    -2363.2
    -2525.2
    -677.2
    1791.8
    3773.8

    (X-XX)
    22380.16
    21199.36
    2872.96
    11109.16
    59243.56

    (Y-)
    5584714.24
    6376635.04
    458599.84
    3210547.24
    14241566.44

    (X-XX)(Y-)
    353534.72
    367669.12
    36297.92
    188855.72
    918542.92

    X-XX
    -1340
    -283
    341
    441
    841

    Y-
    -4222.6
    -1978.6
    187.4
    2763.4
    3250.4

    (X-XX)
    1795600
    80089
    116281
    194481
    707281

    (Y-)
    17830350.76
    3914857.96
    35118.76
    7636379.56
    10565100.16

    (X-XX)(Y-)
    5658284
    559943.8
    63903.4
    1218659.4
    2733586.4

    X-XX
    -18220

    Y-
    -16664.2

    (X-XX)
    331968400

    (Y-)
    277695561.64

    (X-XX)(Y-)
    303621724

    841
    729
    1024
    484
    2116

    (Y-)
    110552607.36
    40773333.16
    25377413.76
    42413958.76
    28618220.16

    (X-XX)(Y-)
    304917.6
    172405.8
    161203.2
    -143277.2
    246081.6

    (X-XX)
    (Y-)
    (X-XX)(Y-)
    18687218081 96207041790.76 42400966627
    20947988650 5405656521206
    7733E+012
    5935593031.8 1745052793551 -2.6403E+011
    4009017162.2 6721339353981 -1.6415E+011
    19902381346 .8970463E+014
    4308E+012

    Corelation
    XX

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    Corelation

    317
    41504.4
    741331
    5194
    247735533.2
    28674E+012
    1134344.9032
    0.6535322704

    Corelation
    207363.8
    XX

    32089008.4
    63463E+012
    (X-XX)(Y-)
    69482198271
    (X-XX)
    3673E+014
    (Y-)
    1.83206E+025
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    8025E+012
    Corelation
    0.6155306095

    Corelation
    XX

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    Corelation

    2501.6
    21539.2
    1864900.4
    116805.2
    29872062.8
    8921E+012
    1867943.3262
    0.9983709751

    Corelation
    XX

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    Corelation

    8859
    80916.6
    10234377
    2893732
    39981807.2
    5697E+014
    10756237.024
    0.9514830305

    Corelation
    XX

    21020

    Year
    2009
    2010
    2011
    2012
    2013

    Sales Revenue (Y)


    Advertisment expense (x)
    43232
    2800
    57838
    29100
    66504
    34600
    65492
    34700
    66415
    3900

    Year
    2009
    2010
    2011
    2012
    2013

    amount in Rs '000'
    Sales Revenue (Y)
    Advertisment expense (x)
    4202934
    40619
    4337027
    35758
    5110651
    26102
    5863187
    97388
    6922021
    79511

    Year
    2009
    2010
    2011
    2012
    2013

    Amounts in $ '000'
    Sales Revenue (Y)
    Advertisment expense (x)
    119103403
    2583629
    134076414
    3282798
    143069204
    2982270
    190565349
    4887099
    216708677
    4165290

    Year
    2009
    2010
    2011
    2012
    2013

    Amounts in millions of $
    Sales Revenue (Y)
    Advertisment expense (x)
    3376511
    436423
    4040887
    405129
    4940251
    426058
    5861096
    468322
    6564152
    489221

    Year
    2009
    2010
    2011
    2012

    amount in crore USD $


    Sales Revenue (Y)
    Advertisment expense (x)
    33422190
    231939
    34666560
    794271
    34857560
    709356
    35373804
    674873

    PSL

    Samsung

    Unilever

    UBL

    8080
    13580
    13680
    -17120

    -2058.2
    6607.8
    5595.8
    6518.8

    -15256.6
    -20117.6
    -29773.6
    41512.4
    23635.4

    Y-
    -1084230
    -950137
    -176513
    576023
    1634857

    X-XX

    X-XX

    65286400
    184416400
    187142400
    293094400

    4236187.24
    43663020.84
    31312977.64
    42494753.44

    -16630256
    89733924
    76550544
    -111601856

    (X-XX)
    (Y-)
    (X-XX)(Y-)
    232763843.56 1175554692900 16541663418
    404717829.76 902760318769 19114476111
    886467256.96
    31156839169 5255427456.8
    1723279353.8 331802496529 23912097185
    558632133.16 2672757410449 38640499138

    Y-
    (X-XX)
    (Y-)
    -996588.2 -41601206 993188040379 7306604E+015
    -297419.2 -26628195 88458180529 .0906079E+014
    -597947.2 -17635405 357540853988 .1100752E+014
    1306881.8 29860740 1.70794E+012 .9166377E+014
    585072.8 56004068 342310181300 1364556E+015

    (X-XX)(Y-)
    4593E+013
    1974E+012
    5450E+013
    0245E+013
    7665E+013

    X-XX
    Y-
    (X-XX)
    (Y-)
    -8607.6 -1580068.4 74090777.76 2496616148679
    -39901.6 -915692.4 1592137682.6 838492571418
    -18972.6
    -16328.4 359959550.76
    266616646.56
    23291.4 904516.6 542489313.96 818150279676
    44190.4 1607572.6 1952791452.2 2584289664271

    (X-XX)(Y-)
    13600596760
    36537591868
    309792201.84
    21067457937
    71039276223

    X-XX
    Y-
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    -390854.4 -1824856.4 152767161999 3330100880621
    253153308
    171477.6 -580486.4 29404567302 336964460585 -99540414705
    86562.6 -389486.4 7493083718.8 151699655785 -33714955449
    52079.6 126757.6 2712284736.2 16067489157.76 6601485105
    80734.6 2668071.6 6518075637.2 7118606062727 5405693397

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    Corelation

    59896.2
    341674080
    1061908000
    399402500.8
    9E+017
    651251649.38
    0.5246421722

    Corelation
    55875.6
    XX

    5287164
    (X-XX)(Y-)
    103464163309
    (X-XX)
    3805860417.2
    (Y-)
    .11403E+012
    (X-XX)(Y-)
    2
    Root(X-XX)(Y-)
    510899357
    Corelation
    0.741620646

    Corelation
    3580217.2
    XX

    160704609.4
    1715E+014
    (X-XX)(Y-)
    48944E+012
    (X-XX)
    885E+015
    (Y-)
    2.36544E+028
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    3800E+014
    Corelation
    0.8564055351

    Corelation
    XX

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    Corelation

    445030.6
    4956579.4
    42554714990
    4521468777.2
    73782E+012
    2
    541746921
    0.8167370701

    Corelation
    XX

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)

    622793.4
    35247046.4
    02004961657
    98895173393
    9534E+013
    2.17859E+024

    2013

    37915118

    Telenor
    Year
    2009
    2010
    2011
    2012
    2013

    Root(X-XX)(Y-)
    Corelation

    703528

    amount in millions of NOK


    Sales Revenue (Y)
    Advertisment expense (x)
    90748
    2081
    94843
    2600
    98516
    2312
    10516
    2011
    104027
    2142

    Allied Bank Limited


    Year
    2009
    2010
    2011
    2012
    2013

    Amount in Rs '000'
    Sales Revenue (Y)
    Advertisment expense (x)
    10116361
    145887
    14212283
    192072
    22545678
    204105
    25132712
    291057
    17680455
    360825

    Year
    2009
    2010
    2011
    2012
    2013

    Amount in million of
    Sales Revenue (Y)
    Advertisment expense (x)
    10381
    1028
    11990
    1288
    13322
    1362
    14883
    1502
    14492
    1457

    Year
    2009
    2010
    2011
    2012
    2013

    Ammount in millions of RS
    Sales Revenue (Y)
    Advertisment expense (x)
    719282
    6822
    877173
    6996
    974917
    8639
    1199928
    9871
    1294503
    10327

    Adidas

    Pakistan State Oil

    X-XX
    -148.2
    370.8
    82.8
    -218.2
    -87.2

    Y-
    11018
    15113
    18786
    -69214
    24297

    X-XX
    -92902.2
    -46717.2
    -34684.2
    52267.8
    122035.8

    Y-
    -7821136.8
    -3725214.8
    4608180.2
    7195214.2
    -257042.8

    X-XX
    -299.4
    -39.4
    34.6
    174.6
    129.6

    Y-
    -2632.6
    -1023.6
    308.4
    1869.4
    1478.4

    X-XX
    -1709
    -1535
    108
    1340
    1796

    Y-
    -293878.6
    -135987.6
    -38243.6
    186767.4
    281342.4

    (X-XX)
    21963.24
    137492.64
    6855.84
    47611.24
    7603.84

    (Y-)
    121396324
    228402769
    352913796
    4790577796
    590344209

    (X-XX)(Y-)
    -1632867.6
    5603900.4
    1555480.8
    15102494.8
    -2118698.4

    (X-XX)
    (Y-)
    (X-XX)(Y-)
    8630818764.8 1170180844314 6600815221
    2182496775.813877225306139 4031604855
    1202993729.621235324755672 -1.5983E+011
    2731922916.8 1771107383882 6078016763
    14892736482 66071001031.84 -31368423732

    (X-XX)
    89640.36
    1552.36
    1197.16
    30485.16
    16796.16

    (Y-)
    6930582.76
    1047756.96
    95110.56
    3494656.36
    2185666.56

    (X-XX)(Y-)
    788200.44
    40329.84
    10670.64
    326397.24
    191600.64

    (X-XX)
    (Y-)
    (X-XX)(Y-)
    2920681 517366595524 502238527.4
    2356225 769432471929
    208740966
    11664 950463156889
    -4130308.8
    1795600 1439827205184
    250268316
    3225616 1675738017009 505290950.4

    7600E+012
    0.5433625407

    Corelation
    XX

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    Corelation

    2229.2
    79730
    18510310
    221526.8
    6083634894
    769E+015
    36710872.646
    0.5042187414

    Corelation
    238789.2
    XX

    17937497.8
    08551E+012
    (X-XX)(Y-)
    29640968669
    (X-XX)
    8120E+014
    (Y-)
    4.39042E+024
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    9533E+012
    Corelation
    0.5180614797

    Corelation
    XX

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    Corelation

    1327.4
    13013.6
    1357198.8
    139671.2
    13753773.2
    2101E+012
    1386003.6102
    0.9792173628

    corelation
    XX

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    corelation

    8531
    1013160.6
    1462408451
    10309786
    .35283E+012
    +019
    7428762041
    0.1968576248

    Nestle Pakistan
    Year
    2009
    2010
    2011
    2012
    2013

    Amount in Rs '000'
    Sales Revenue (Y)
    Advertisment expense (x)
    41155822
    2444557
    51487302
    2418126
    64824364
    2814958
    79087696
    3763608
    86226869
    5529158

    Year
    2009
    2010
    2011
    2012
    2013

    Amount in '000' of MR
    Sales Revenue (Y)
    Advertisment expense (x)
    9085485
    34590
    10376394
    37603
    11212679
    40734
    15086427
    32642
    14696086
    43384

    Shell

    X-XX
    Y-
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    -949524.4 -23400589 901596586195 .4758755E+014
    2194E+013
    -975955.4 -13069109 952488942789 .7080160E+014
    7549E+013
    -579123.4 267953.4 335383912428 71799024571.56 -1.5518E+011
    369526.6 14531285 136549908108 .1115826E+014
    6970E+012
    2135076.6 21670458 4.55855E+012 .6960877E+014
    2681E+013

    X-XX
    -3200.6
    -187.6
    2943.4
    -5148.6
    5593.4

    Y-
    -3005929.2
    -1715020.2
    -878735.2
    2995012.8
    2604671.8

    (X-XX)
    10243840.36
    35193.76
    8663603.56
    26508081.96
    31286123.56

    (Y-)
    (X-XX)(Y-)
    9035610355413 9620776998
    2941294286408 321737789.52
    772175551719 -2586469188
    8970101672164 -15420122902
    6784315185715 14568971246

    Corelation
    3394081.4
    XX

    64556410.6
    4569E+013
    (X-XX)(Y-)
    88457E+012
    (X-XX)
    923E+015
    (Y-)
    9.63308E+027
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    1483E+013
    Corelation
    0.8808804784

    Corelation
    XX

    (X-XX)(Y-)
    (X-XX)
    (Y-)
    (X-XX)(Y-)
    Root(X-XX)(Y-)
    Corelation

    37790.6
    12091414.2
    6504893943.4
    76736843.2
    5035E+013
    21
    46768241189
    0.1390878463

    You might also like