Scribd Logo
Upload

Welcome to Scribd!

  • 50 views

    Excel Correlation Analysis

    Uploaded by

    Mohd Ezan Mohammadiah

    Copyright:

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

    Excel Correlation Analysis

    Uploaded by

    Mohd Ezan Mohammadiah
    50 views3 pages

    Original Title

    Excel-Correlation-analysis

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Excel Correlation Analysis

    Uploaded by

    Mohd Ezan Mohammadiah

    Copyright:

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

    EXCEL: CORRELATION ANALYSIS

    Description

    One of the best techniques of preliminary data analysis is correlation


    analysis. It allows us to uncover possible relationships between different
    pairs of variables in our dataset. At the same time, we should always bear
    in mind that correlation does not mean causation.

    This Excel model is for educational purposes only. Strictly Confidential


    All content is Copyright material of 365 Financial Analyst ®

    © 2022, 365 Financial Analyst ®


    CORRELATION ANALYSIS

    USA USA USA USA


    in $ Revenue Advertising spend Correlation Revenue Staff costs
    1/31/2019 1705 317 0.55 1705 259
    2/28/2019 2013 318 2013 278
    3/31/2019 1909 324 1909 294
    4/30/2019 2069 351 2069 298
    5/31/2019 2093 349 2093 308
    6/30/2019 2299 307 2299 334
    7/31/2019 1312 0 1312 309
    8/31/2019 2005 336 2005 258
    9/30/2019 2302 431 2302 331
    10/31/2019 1940 142 1940 340
    11/30/2019 2205 217 2205 426
    12/31/2019 2297 430 2297 307
    1/31/2020 1899 295 1899 296
    2/29/2020 2132 355 2132 282
    3/31/2020 2382 356 2382 360
    4/30/2020 2596 360 2596 358
    5/31/2020 2585 358 2585 360
    6/30/2020 2805 363 2805 366
    7/31/2020 1517 0 1517 353
    8/31/2020 2388 342 2388 358
    9/30/2020 2811 347 2811 363
    10/31/2020 2631 344 2631 360
    11/30/2020 2382 349 2382 358
    12/31/2020 2875 570 2875 380
    1/31/2021 2371 388 2371 335
    2/28/2021 2653 346 2653 322
    3/31/2021 3059 356 3059 397
    4/30/2021 3359 364 3359 392
    5/31/2021 3293 358 3293 390
    6/30/2021 3557 362 3557 394
    7/31/2021 2003 0 2003 384
    8/31/2021 3101 339 3101 384
    9/30/2021 3586 344 3586 389
    10/31/2021 3343 337 3343 388
    11/30/2021 3040 415 3040 410
    Staff costs Correlation
    0.69

    You might also like