I have the following data:
| Income | Percentile |
| 1 | 0.002486 |
| 2 | 0.003284 |
| 3 | 0.004051 |
| 4 | 0.004174 |
| 5 | 0.006552 |
| 6 | 0.009528 |
| 7 | 0.014147 |
| 8 | 0.017845 |
| 9 | 0.022156 |
| 10 | 0.027112 |
| 11 | 0.035168 |
| 12 | 0.050051 |
| 13 | 0.068986 |
| 14 | 0.088641 |
| 15 | 0.108235 |
| 16 | 0.128765 |
| 17 | 0.151796 |
| 18 | 0.174628 |
| 19 | 0.204993 |
...... which continues up to the 100th percentile
The percentile numbers are not regular so I want to create an extra row (in the right numerical location) to find the income number for the 50th percentile on Excel I would use the following formula, how would I translate this into alteryx?
I then want to create a new column which has a few separate irregular formulas in it some of which rely on numbers from column B - I presume this would be through using the multi-row formula?
1. For the last row in the column I want to calculate them using the calculated 50th percentile number multiplied by other numbers I already have
2. For the 50th percentile row in the new column I want to be able to input a number I already have
3. For the first row and all the interim cells I want to calculate them in relation to either bottom and mid or mid and top point and also in proportion to the figures in column A
I have attached an excel with the formulas I'd use in Excel to do it
Thanks for the help
