13.2Linear Interpolation

[HillaryLansfield]

I have 2 tables, shown below. Table 1 is (sort of) a reference/look up table, where it shows what eff% is at a specific P (MW). Tables 2 has the values that need to be looked up, it only has P, and I would like to determine, what the eff% should be (based on table 1).

I will note, that in some cases

Table  1:

 

 

Table 2:

 

 

 

Thank you!

[HillaryLansfield]

I see, my mistake!

When using excel, here is the a few examples of input (P (MW)) and output (eff%)

input -> output

13.6 -> 93.3%

14 -> 92.5%

7-> 80.6%

Does that help?

Sorry for the confusion. 

[HillaryLansfield]

I see, my mistake!

When using excel, here is the a few examples of input (P (MW)) and output (eff%)

input -> output

13.6 -> 93.3%

14 -> 92.5%

7-> 80.6%

Does that help?

Sorry for the confusion. 

[alexnajm]

It does, but I don't want to type out the full table manually so here's a screenshot of what I'd try. Main table goes into Linear Regression as mentioned to predict Eff% as the target based on PMW, then feed the model into the Score tool along with the new data. Good luck!

[HillaryLansfield]

Thank you! is there any any you would be able to attach your work flow? I am not sure exactly how to set up those tools (have never worked with them) and seeing your example may help!

[alexnajm]

@HillaryLansfield please try yourself first and come back with issues you run into - make sure you download the Predictive Tools as well: Download and Use Predictive Tools

[HillaryLansfield]

I gave it a try and believe I have it set up correctly ( i think at least). However, when i compare the the output form excel, the results are quite different. See workflow attached. Can you please let me know if you notice anything clearly incorrect?

Thanks!

[alexnajm]

It looks like your dataset is much smaller - make sure you have all data as this will influence the model output

Otherwise looks fine to me!

[HillaryLansfield]

thanks for pointing that out! I realize that I had pasted in the wrong data set.

With the correct data set, the output more closely matches that of excel. Is that any way to tweak the model so that they align better? Or is this unavoidable? 

[alexnajm · Accepted solution]

If you know how the Excel function calculates, then you may be able to find a more equivalent way in Alteryx. Otherwise I would go with this as the easiest Alteryx option

You can play with the underlying R code if you want, but only if you are comfortable in R