Hey guys,
I am looking for a formula with which I can forecast Data based on a data table:
e.g. Putting in Expenses of $3,000,000 should give me an infrastructure factor of about 0.96.
The Problem: I tried to do it with the "forecast" formula but the values are just wrong and not in line with the data table. I attached a screenshot:
What I am trying to do:
A formula like the "forecast" formula but which forecasts exactly like in the graph, so when I put in 200,000, it should give me 0.5 (instead of 0.82 which I get with "=Forecast")
The gaps where the data is missing should then be linearly approximiated exactly as in the graph. Which excel formula do I need? And how?
Please help me. It is a time sensitive matter.
Thank you in advance!
I am looking for a formula with which I can forecast Data based on a data table:
e.g. Putting in Expenses of $3,000,000 should give me an infrastructure factor of about 0.96.
The Problem: I tried to do it with the "forecast" formula but the values are just wrong and not in line with the data table. I attached a screenshot:
What I am trying to do:
A formula like the "forecast" formula but which forecasts exactly like in the graph, so when I put in 200,000, it should give me 0.5 (instead of 0.82 which I get with "=Forecast")
The gaps where the data is missing should then be linearly approximiated exactly as in the graph. Which excel formula do I need? And how?
Please help me. It is a time sensitive matter.
Thank you in advance!