+ Reply to Thread
Results 1 to 4 of 4

Thread: calculate missing values

  1. #1
    Points: 8, Level: 1
    Level completed: 15%, Points required for next Level: 42

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    calculate missing values




    Hello,

    I have these data:


    X | Y |X+Y|
    1 | 2 |
    3 | 4 |
    2 | 6 |
    - | - | 12
    - | - | 18
    - | - | 22
    7 | 4 |
    6 | 5 |
    8 | 3 |
    9 | 1 |
    How to calculate the missing values of X and Y if we know their sum?

    Thank you very much.
    Last edited by donan; 03-04-2017 at 05:15 PM.

  2. #2
    Omega Contributor
    Points: 38,334, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    6,998
    Thanks
    398
    Thanked 1,186 Times in 1,147 Posts

    Re: calculate missing values

    Do you have a larger sample size this?
    Stop cowardice, ban guns!

  3. #3
    Points: 8, Level: 1
    Level completed: 15%, Points required for next Level: 42

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: calculate missing values

    Hi,
    The actual data are time series representing monthly new registered guests in a hotel (X=native guests and Y=foreigner guests). Data include 5-year period, but for the third year I have only the total of both variables. So my question is: How can I calculate X and Y on the base of total?

  4. #4
    TS Contributor
    Points: 12,227, Level: 72
    Level completed: 45%, Points required for next Level: 223
    rogojel's Avatar
    Location
    I work in Europe, live in Hungary
    Posts
    1,470
    Thanks
    160
    Thanked 332 Times in 312 Posts

    Re: calculate missing values


    basically,you can't. You could use some kind of inputation on the X and Y series, but given the amount of missing values, I would not trust the values too much.



    regards

+ Reply to Thread

           




Posting Permissions

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






Advertise on Talk Stats