1. ## 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.

2. ## Re: calculate missing values

Do you have a larger sample size this?

3. ## 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. ## 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

 Tweet

#### Posting Permissions

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