Hi,
I have a question regarding the best way to input a number and then through previous data available, scale corresponding averages to be relevant to the new input.
For example, here is some raw data. Column 3 is the per cent difference between the data in column 1 & 2. Column 5 is the per cent difference between the data in column 1 and 4. Column 6 is the market cap of a company when the stock was valued at the values in column 1.
<tbody>
</tbody>
The below table shows the average of the values in columns 3, 5 and 6.
<tbody>
</tbody>
is there a way to add in a value into row B (14.34) into the 2nd table, and then scale the averages in column 3 & 5 to match this new value?
I have a question regarding the best way to input a number and then through previous data available, scale corresponding averages to be relevant to the new input.
For example, here is some raw data. Column 3 is the per cent difference between the data in column 1 & 2. Column 5 is the per cent difference between the data in column 1 and 4. Column 6 is the market cap of a company when the stock was valued at the values in column 1.
1 | 2 | 3 | 4 | 5 | 6 | |
A | 0.34 | 0.39 | 14.70% | 0.45 | 32.35% | 23.45 |
B | 1.09 | 1.13 | 3.66% | 1.14 | 4.58% | 109.54 |
C | 2.78 | 3.01 | 8.27% | 2.84 | 2.15% | 233.95 |
D | 1.45 | 1.56 | 7.58% | 1.56 | 7.58% | 54.65 |
<tbody>
</tbody>
The below table shows the average of the values in columns 3, 5 and 6.
1 | 2 | 3 | |
A | 8.55% | 11.66% | 105.39 |
B | ? | ? | 14.34 |
<tbody>
</tbody>
is there a way to add in a value into row B (14.34) into the 2nd table, and then scale the averages in column 3 & 5 to match this new value?
Last edited: