In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

model parameters using sum square difference minimization

Josh_Metro
7 - Meteor

I'm new to Alteryx, and I'm trying to replicate something that takes me only a few seconds to do in Excel. 

 

I'm try to fit a dataset to a model. In Excel, I do it this way.

 

This is the model (coefficients in bold): C = (Co-D) * e^(-k*t)

 

I set the starting values from the parameters

D1
k1

 

These are are my observations and my calculated C.

 

CotC - observedC -calculated
031.52
0.531.251.213
231.160.271
530.790.013
1030.459E-05
3030.022E-13
6030.062E-26

 

I then calculate the sum square difference between the observed and calculated C values using the SUMXMY2 formula in Excel

 

SSD
1.85167928

 

Then I use the Solver to minimize the SSD by changing D and k. That literally takes seconds to do, and I get the best fit parameters for my dataset. How can this be done in Alteryx. I uploaded an example.

10 REPLIES 10
Josh_Metro
7 - Meteor

Hi Rajdaiya. I'm happy to share. I've attached a sample workflow.

Labels
Top Solution Authors