Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

How to see the Mathematical formula

Solved!
Hugo_Wsld
Level 2
How to see the Mathematical formula

Hello everyone,

Pease, could you let me know how to have the Mathematical formula from the graph below

Point.PNG

Many thanks, in advance 

Regards,

Hugo

0 Kudos
2 Solutions
AlexandreL
Dataiker
Dataiker

Hi,

There's no formula linked to this chart, only the data from your sample is displayed. However, if you want to estimate a linear regression between your two variables you can create a machine learning model (from your dataset click on the delai_planif column title > create prediction model > choose your algorithms). There you can choose delai_appro as the only feature in the "Feature handling" section, and  Ordinary Least Squares in the "Algorithms" section. Once the model is trained, you can access it's coefficients to have the mathematical formula, and you can also make predictions using this model.

Looking at your chart, the equation should not be far from y=x, as the gray line displayed corresponds to this equation

View solution in original post

AlexandreL
Dataiker
Dataiker

Yes, the mathematical formula isn't explicitly displayed but as it's a linear regression it will be approximately delai_planif = 0.9838 * delai_appro + 23.0114

If you want to apply it to some new data, you can use a scoring recipe using this model and a dataset with a delai_appro column

View solution in original post

3 Replies
AlexandreL
Dataiker
Dataiker

Hi,

There's no formula linked to this chart, only the data from your sample is displayed. However, if you want to estimate a linear regression between your two variables you can create a machine learning model (from your dataset click on the delai_planif column title > create prediction model > choose your algorithms). There you can choose delai_appro as the only feature in the "Feature handling" section, and  Ordinary Least Squares in the "Algorithms" section. Once the model is trained, you can access it's coefficients to have the mathematical formula, and you can also make predictions using this model.

Looking at your chart, the equation should not be far from y=x, as the gray line displayed corresponds to this equation

View solution in original post

Hugo_Wsld
Level 2
Author

Thanks for your very quick response, you are active at Dataiku 🙂 

Where can i see the Mathematical formula ? Could it be on this tab ?

formula.PNG

Regards,

Hugo

0 Kudos
AlexandreL
Dataiker
Dataiker

Yes, the mathematical formula isn't explicitly displayed but as it's a linear regression it will be approximately delai_planif = 0.9838 * delai_appro + 23.0114

If you want to apply it to some new data, you can use a scoring recipe using this model and a dataset with a delai_appro column

View solution in original post

A banner prompting to get Dataiku DSS