Results 1 to 2 of 2

Pearson FX & Time Series Data

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2019
    Location
    USA
    MS-Off Ver
    365 / 2016 for Desktop or Mobile Devices
    Posts
    9

    Pearson FX & Time Series Data

    Hi,

    Having begun intense efforts to pass one last milestone for a Master's Degree by finishing my thesis, I've become hopelessly stuck on Pearson's R coefficients. Esp. as it relates to times and dates. Below is an example to illustrate the scenario where I must evaluate 3 unique variables to assess how, if and why they correlate. My issue now is figuring out how numerical values that indicate time slots by hourly blocks may imply significance that varies for each day of the week and/or total number of transactions. DIY 'play' exercises show that changing specific values listed below "HOUR" column affects the PEARSON Fx result. But why? Does PEARSON Fx output reflect a positive relation between later hours and greater revenue listed in adjacent cells on each row that are labeled as weekdays? Or, vice-versa? Or, nothing at all? Since .59 does fall midway between 0 and 1, it would seem to have some meaning. Please clarify. Thanks in advance!
    Attached Files Attached Files
    Last edited by CluckeyJD; 12-02-2019 at 10:07 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Chip Pearson- you're web page is down
    By scott in forum Excel General
    Replies: 16
    Last Post: 05-07-2018, 04:40 AM
  2. [SOLVED] Pearson Correlation Coefficient
    By gko_87 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-26-2017, 07:38 AM
  3. Got Pearson coefficient (r) -- also need probability (p). Please help.
    By Carrfamily in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-15-2014, 12:08 PM
  4. P Value from Pearson r
    By Chrisb59 in forum Excel General
    Replies: 4
    Last Post: 06-16-2011, 05:00 AM
  5. Pearson's Formula Error
    By DemonicGman in forum Excel General
    Replies: 1
    Last Post: 04-15-2011, 05:05 PM
  6. [SOLVED] Pearson's Progress Bar
    By Bill Martin in forum Excel General
    Replies: 2
    Last Post: 10-06-2005, 11:05 PM
  7. Thank you Chip Pearson
    By Michael in forum Excel General
    Replies: 3
    Last Post: 02-05-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1