Predictive analysis
Fit polynomial curves and linear regressions (simple and multiple) loaded from the database or from JSON, then predict and get their statistics: slope, intercept, R2, errors and significance. Typical use: a simple trend or forecast. The full engine is in the ML pages.
pa polynomial_curve_fit_get_coeffpa polynomial_curve_fit_evalpa polynomial_curve_fit_eval_incrpa xy_scatterpa xy_scatterpa rl loadpa rl load_from_jsonpa rl load_emptypa rl existpa rl showpa rl add_datapa rl slopepa rl interceptpa rl predictpa rl intercept_std_errpa rl mean_square_errorpa rl countpa rl rpa rl sum_squarespa rl r_squarepa rl significancepa rl slope_confidence_intervalpa rl slope_std_errpa rl sum_squared_errorspa rl total_sum_squarespa rl x_sum_squarespa rl slope_confidence_intervalpa rl closepa rl close_allpa rm loadpa rm load_from_jsonpa rm set_no_interceptpa rm calculate_adjusted_r_squaredpa rm calculate_residual_sum_of_squarespa rm calculate_r_squaredpa rm calculate_total_sum_of_squarespa rm estimate_error_variancepa rm estimate_regressand_variancepa rm estimate_regression_standard_errorpa rm estimate_regression_parameters_variancepa rm estimate_residualspa rm estimate_regression_parameters_standard_errorspa rm estimate_regression_parameterspa rm predictpa rm existpa rm showpa rm closepa rm close_all
pa polynomial_curve_fit_get_coeff <data> <degree>
Description
Fit a polynomial by least squares on [x, y] points and get its coefficients in ascending order [c0, c1, c2...] (y = c0 + c1*x + c2*x^2...).
A polynomial of degree n needs at least n + 1 different x values.
Fit a polynomial by least squares on [x, y] points and get its coefficients in ascending order [c0, c1, c2...] (y = c0 + c1*x + c2*x^2...).
A polynomial of degree n needs at least n + 1 different x values.
Parameters
data: The JSON array of x,y points - string - required
degree: The degree of the polynomial curve - number - required
data: The JSON array of x,y points - string - required
degree: The degree of the polynomial curve - number - required
admin
pa polynomial_curve_fit_get_coeff "[ [1.0, 2.0], [1.0, 2.2], [1.0, 2.5], [1.2, 2.0], [1.11, 0.9], [5.0, 3.0], [5.2, 3.08], [5.1, 3.0], [5.15, 2.9] ]" "3"
mentdb
"[7.499085083330208,-7.6240029798174,2.4585392371279067,-0.22286556119637468]"
Used in use cases (2 recipes)
Electrochemist & battery engineer › OCV-SOC curve of a Li-ion cell
Forecaster & econometrician › Polynomial trend of user growth
Electrochemist & battery engineer › OCV-SOC curve of a Li-ion cell
Forecaster & econometrician › Polynomial trend of user growth
Often used with
pa polynomial_curve_fit_eval · pa polynomial_curve_fit_eval_incr · matrix col · num poly_derive · num poly_eval · plot add · plot fit · plot points
pa polynomial_curve_fit_eval · pa polynomial_curve_fit_eval_incr · matrix col · num poly_derive · num poly_eval · plot add · plot fit · plot points
pa polynomial_curve_fit_eval <coeff> <x>
Description
Evaluate a polynomial curve for a specific value
Evaluate a polynomial curve for a specific value
Parameters
coeff: The JSON array of coefficients - string - required
x: The x to evaluate - number - required
coeff: The JSON array of coefficients - string - required
x: The x to evaluate - number - required
admin
pa polynomial_curve_fit_eval "[7.499085083330208,-7.6240029798174,2.4585392371279067,-0.22286556119637468]" "2"
mentdb
0.30231158263603675
Used in use cases (2 recipes)
Electrochemist & battery engineer › OCV-SOC curve of a Li-ion cell
Forecaster & econometrician › Polynomial trend of user growth
Electrochemist & battery engineer › OCV-SOC curve of a Li-ion cell
Forecaster & econometrician › Polynomial trend of user growth
Often used with
pa polynomial_curve_fit_eval_incr · pa polynomial_curve_fit_get_coeff · matrix col · num poly_derive · num poly_eval · plot add · plot fit · plot points
pa polynomial_curve_fit_eval_incr · pa polynomial_curve_fit_get_coeff · matrix col · num poly_derive · num poly_eval · plot add · plot fit · plot points
pa polynomial_curve_fit_eval_incr <coeff> <min_x> <max_x> <increment>
Description
Evaluate a polynomial for x = min_x, min_x + increment... up to max_x: [[x, y], ...].
The x values are computed in decimal (0.1 + 0.2 = 0.3, no drift); increment > 0, 1000001 points max.
Evaluate a polynomial for x = min_x, min_x + increment... up to max_x: [[x, y], ...].
The x values are computed in decimal (0.1 + 0.2 = 0.3, no drift); increment > 0, 1000001 points max.
Parameters
coeff: The JSON array of coefficients - string - required
min_x: The min x to evaluate - number - required
max_x: The max x to evaluate - number - required
increment: The increment - number - required
coeff: The JSON array of coefficients - string - required
min_x: The min x to evaluate - number - required
max_x: The max x to evaluate - number - required
increment: The increment - number - required
admin
pa polynomial_curve_fit_eval_incr "[7.499085083330208,-7.6240029798174,2.4585392371279067,-0.22286556119637468]" 1 5 0.1
mentdb
[[1.0,2.1107557794443395],[1.1,1.7908802205034604],[1.2,1.505466319266179],[1.3,1.2531768823653158],[1.4,1.032674716433693],[1.5,0.8426226281041345],[1.6,0.6816834240094591],[1.7,0.5485199107824901],[1.8,0.44179489505604863],[1.9,0.36017118346295796],[2.0,0.30231158263603675],[2.1,0.2668788992081108],[2.2,0.25253593981199884],[2.3,0.2579455110805249],[2.4,0.2817704196465085],[2.5,0.3226734721427711],[2.6,0.37931747520213754],[2.7,0.4503652354574257],[2.8,0.5344795595414595],[2.9,0.6303232540870614],[3.0,0.7365591257270534],[3.1,0.8518499810942517],[3.2,0.97485862682149],[3.3,1.1042478695415765],[3.4,1.2386805158873395],[3.5,1.3768193724916022],[3.6,1.5173272459871825],[3.7,1.6588669430069025],[3.8,1.8001012701835881],[3.9,1.9396930341500598],[4.0,2.076305041539136],[4.1,2.208600098983643],[4.2,2.3352410131163976],[4.3,2.4548905905702236],[4.4,2.5662116379779434],[4.5,2.667866961972374],[4.6,2.7585193691863514],[4.7,2.836831666252677],[4.8,2.9014666598041945],[4.9,2.9510871564737027],[5.0,2.984355962894038]]
Used in use cases (2 recipes)
Electrochemist & battery engineer › OCV-SOC curve of a Li-ion cell
Forecaster & econometrician › Polynomial trend of user growth
Electrochemist & battery engineer › OCV-SOC curve of a Li-ion cell
Forecaster & econometrician › Polynomial trend of user growth
Often used with
pa polynomial_curve_fit_eval · pa polynomial_curve_fit_get_coeff · matrix col · num poly_derive · num poly_eval · plot add · plot fit · plot points
pa polynomial_curve_fit_eval · pa polynomial_curve_fit_get_coeff · matrix col · num poly_derive · num poly_eval · plot add · plot fit · plot points
pa xy_scatter <jsonArray> <title>
Description
Show a scatter plot
Show a scatter plot
Parameters
jsonArray: The JSON array of x,y points - string - required
title: The title - string - required
jsonArray: The JSON array of x,y points - string - required
title: The title - string - required
admin
pa xy_scatter "[ [1.0, 2.0], [1.0, 2.2], [1.0, 2.5], [1.2, 2.0], [1.11, 0.9], [5.0, 3.0], [5.2, 3.08], [5.1, 3.0], [5.15, 2.9] ]" "x, y"
mentdb
In editor ...
pa xy_scatter <cmId> <fieldX> <fieldY> <sqlSource>
Description
Show a predictive analysis scatter plot
Show a predictive analysis scatter plot
Parameters
cmId: The database connection id - string - required
fieldX: The field X - string - required
fieldY: The field X - string - required
sqlSource: The select query (origin) - string - required
cmId: The database connection id - string - required
fieldX: The field X - string - required
fieldY: The field X - string - required
sqlSource: The select query (origin) - string - required
admin
pa xy_scatter "demo_cm_mysql" "id" "quantity" "select * from products limit 0, 500"
mentdb
In editor ...
Used in use cases (2 recipes)
Agronomist › Phosphorus response: Mitscherlich law and economic optimum
Forecaster & econometrician › Trend forecast straight from the sales database
Agronomist › Phosphorus response: Mitscherlich law and economic optimum
Forecaster & econometrician › Trend forecast straight from the sales database
Often used with
cm get · cm remove · execute · file delete · json load select · math expm1 · math log · pa rl close
cm get · cm remove · execute · file delete · json load select · math expm1 · math log · pa rl close
pa rl load <regId> <cmId> <fieldX> <fieldY> <sqlSource>
Description
Load a linear regression from the database
Load a linear regression from the database
Parameters
regId: The regression id - string - required
cmId: The database connection id - string - required
fieldX: The field X - string - required
fieldY: The field X - string - required
sqlSource: The select query (origin) - string - required
regId: The regression id - string - required
cmId: The database connection id - string - required
fieldX: The field X - string - required
fieldY: The field X - string - required
sqlSource: The select query (origin) - string - required
admin
pa rl load "reg1" "demo_cm_mysql" "id" "quantity" "select * from products limit 0, 500";
mentdb
1
Used in use cases (2 recipes)
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Trend forecast straight from the sales database
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Trend forecast straight from the sales database
Often used with
cm get · cm remove · execute · file delete · pa rl close · pa rl count · pa rl predict · pa rl r_square
cm get · cm remove · execute · file delete · pa rl close · pa rl count · pa rl predict · pa rl r_square
pa rl load_from_json <regId> <jsonArray>
Description
Load a linear regression from a JSON array of doubles
Load a linear regression from a JSON array of doubles
Parameters
regId: The regression id - string - required
jsonArray: The JSON array - string - required
regId: The regression id - string - required
jsonArray: The JSON array - string - required
admin
pa rl load_from_json "reg1" "[ [1.0, 2.0], [2.0, 3.0], [3.0, 4.0], [4.0, 5.0], [5.0, 6.0] ]";
mentdb
1
Used in use cases (3 recipes)
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › Sales trend and next quarter forecast
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › Sales trend and next quarter forecast
Often used with
pa rl close · pa rl slope · pa rl intercept · pa rl predict · pa rl slope_confidence_interval · dsp detrend · dsp peaks · dsp periodogram
pa rl close · pa rl slope · pa rl intercept · pa rl predict · pa rl slope_confidence_interval · dsp detrend · dsp peaks · dsp periodogram
pa rl load_empty <regId>
Description
Load an empty linear regression
Load an empty linear regression
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl load_empty "reg1";
mentdb
1
Used in use cases (2 recipes)
Materials scientist › Weibull modulus of a ceramic
Forecaster & econometrician › ANOVA of leads vs advertising spend
Materials scientist › Weibull modulus of a ceramic
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl add_data · pa rl close · pa rl slope · pa rl slope_confidence_interval · json doc · json iobject · pa rl count · pa rl exist
pa rl add_data · pa rl close · pa rl slope · pa rl slope_confidence_interval · json doc · json iobject · pa rl count · pa rl exist
pa rl exist <regId>
Description
Check if a regression already exists
Check if a regression already exists
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl exist "reg1"
mentdb
1
Used in use cases (2 recipes)
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Forecaster & econometrician › ANOVA of leads vs advertising spend
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl intercept_std_err · pa rl slope · pa rl slope_std_err · json doc · json iobject · math round_sig · pa rl add_data
pa rl close · pa rl intercept_std_err · pa rl slope · pa rl slope_std_err · json doc · json iobject · math round_sig · pa rl add_data
pa rl show
Description
Show all regressions
Show all regressions
admin
pa rl show
mentdb
[ "reg1" ]
Used in use cases (2 recipes)
Forecaster & econometrician › ANOVA of leads vs advertising spend
Forecaster & econometrician › Trend forecast straight from the sales database
Forecaster & econometrician › ANOVA of leads vs advertising spend
Forecaster & econometrician › Trend forecast straight from the sales database
Often used with
pa rl close · pa rl slope · cm get · cm remove · execute · file delete · json doc · json iobject
pa rl close · pa rl slope · cm get · cm remove · execute · file delete · json doc · json iobject
pa rl add_data <regId> <x> <y>
Description
Add data to a regression
Add data to a regression
Parameters
regId: The regression id - string - required
x: The x - number - required
y: The y - number - required
regId: The regression id - string - required
x: The x - number - required
y: The y - number - required
admin
pa rl add_data "reg1" 5 56;
mentdb
1
Used in use cases (2 recipes)
Materials scientist › Weibull modulus of a ceramic
Forecaster & econometrician › ANOVA of leads vs advertising spend
Materials scientist › Weibull modulus of a ceramic
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl load_empty · pa rl slope · pa rl slope_confidence_interval · json doc · json iobject · pa rl count · pa rl exist
pa rl close · pa rl load_empty · pa rl slope · pa rl slope_confidence_interval · json doc · json iobject · pa rl count · pa rl exist
pa rl slope <regId>
Description
Get the slope (y = intercept + slope * x)
Get the slope (y = intercept + slope * x)
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl slope "reg1"
mentdb
7.25
Used in use cases (7 recipes)
Materials scientist › Weibull modulus of a ceramic
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Climate & environment scientist › Warming trend and a hidden cycle
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › ANOVA of leads vs advertising spend
and 1 more in the Use cases
Materials scientist › Weibull modulus of a ceramic
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Climate & environment scientist › Warming trend and a hidden cycle
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › ANOVA of leads vs advertising spend
and 1 more in the Use cases
Often used with
pa rl close · pa rl count · pa rl intercept · pa rl predict · pa rl r_square · pa rl slope_confidence_interval · pa rl load_from_json · cm get
pa rl close · pa rl count · pa rl intercept · pa rl predict · pa rl r_square · pa rl slope_confidence_interval · pa rl load_from_json · cm get
pa rl intercept <regId>
Description
Get the intercept (y = intercept + slope * x)
Get the intercept (y = intercept + slope * x)
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl intercept "reg1"
mentdb
-11.5
Used in use cases (4 recipes)
Materials scientist › Weibull modulus of a ceramic
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Materials scientist › Weibull modulus of a ceramic
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Often used with
pa rl close · pa rl slope · pa rl count · pa rl predict · pa rl r_square · pa rl load_from_json · pa rl slope_confidence_interval · cm get
pa rl close · pa rl slope · pa rl count · pa rl predict · pa rl r_square · pa rl load_from_json · pa rl slope_confidence_interval · cm get
pa rl predict <regId> <x>
Description
Make a prediction
Make a prediction
Parameters
regId: The regression id - string - required
x: The x - number - required
regId: The regression id - string - required
x: The x - number - required
admin
pa rl predict "reg1" 12
mentdb
75.5
Used in use cases (4 recipes)
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › Trend forecast straight from the sales database
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › Trend forecast straight from the sales database
Often used with
pa rl close · pa rl slope · pa rl count · pa rl intercept · pa rl r_square · cm get · cm remove · execute
pa rl close · pa rl slope · pa rl count · pa rl intercept · pa rl r_square · cm get · cm remove · execute
pa rl intercept_std_err <regId>
Description
Returns the standard error of the intercept estimate, usually denoted s(b0).
Returns the standard error of the intercept estimate, usually denoted s(b0).
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl intercept_std_err "reg1"
mentdb
19.764235376052373
Used in use cases (2 recipes)
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Forecaster & econometrician › ANOVA of leads vs advertising spend
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl exist · pa rl slope · pa rl slope_std_err · json doc · json iobject · math round_sig · pa rl add_data
pa rl close · pa rl exist · pa rl slope · pa rl slope_std_err · json doc · json iobject · math round_sig · pa rl add_data
pa rl mean_square_error <regId>
Description
Returns the sum of squared errors divided by the degrees of freedom, usually abbreviated MSE.
Returns the sum of squared errors divided by the degrees of freedom, usually abbreviated MSE.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl mean_square_error "reg1"
mentdb
390.625
Used in use cases (2 recipes)
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › ANOVA of leads vs advertising spend
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl r · pa rl slope · pa rl slope_confidence_interval · pa rl sum_squared_errors · pa rl total_sum_squares · dsp detrend · dsp peaks
pa rl close · pa rl r · pa rl slope · pa rl slope_confidence_interval · pa rl sum_squared_errors · pa rl total_sum_squares · dsp detrend · dsp peaks
pa rl count <regId>
Description
Get the number of pairs
Get the number of pairs
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl count "reg1"
mentdb
6
Used in use cases (4 recipes)
Materials scientist › Weibull modulus of a ceramic
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › Trend forecast straight from the sales database
Materials scientist › Weibull modulus of a ceramic
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › Trend forecast straight from the sales database
Often used with
pa rl close · pa rl r_square · pa rl slope · pa rl intercept · pa rl predict · cm get · cm remove · execute
pa rl close · pa rl r_square · pa rl slope · pa rl intercept · pa rl predict · cm get · cm remove · execute
pa rl r <regId>
Description
Returns Pearson's product moment correlation coefficient, usually denoted r.
Returns Pearson's product moment correlation coefficient, usually denoted r.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl r "reg1"
mentdb
0.5564589284286688
Used in use cases (2 recipes)
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › ANOVA of leads vs advertising spend
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl mean_square_error · pa rl slope · pa rl slope_confidence_interval · pa rl sum_squared_errors · pa rl total_sum_squares · dsp detrend · dsp peaks
pa rl close · pa rl mean_square_error · pa rl slope · pa rl slope_confidence_interval · pa rl sum_squared_errors · pa rl total_sum_squares · dsp detrend · dsp peaks
pa rl sum_squares <regId>
Description
Returns the sum of squared deviations of the predicted y values about their mean (which equals the mean of y).
Returns the sum of squared deviations of the predicted y values about their mean (which equals the mean of y).
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl sum_squares "reg1"
mentdb
700.8333333333334
Often used with
json doc · json iobject · pa rl add_data · pa rl close · pa rl exist · pa rl intercept_std_err · pa rl load_empty · pa rl mean_square_error
json doc · json iobject · pa rl add_data · pa rl close · pa rl exist · pa rl intercept_std_err · pa rl load_empty · pa rl mean_square_error
pa rl r_square <regId>
Description
Returns the coefficient of determination, usually denoted r-square.
Returns the coefficient of determination, usually denoted r-square.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl r_square "reg1"
mentdb
0.3096465390279824
Used in use cases (4 recipes)
Materials scientist › Weibull modulus of a ceramic
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › Trend forecast straight from the sales database
Materials scientist › Weibull modulus of a ceramic
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › Trend forecast straight from the sales database
Often used with
pa rl close · pa rl count · pa rl slope · pa rl intercept · pa rl predict · cm get · cm remove · execute
pa rl close · pa rl count · pa rl slope · pa rl intercept · pa rl predict · cm get · cm remove · execute
pa rl significance <regId>
Description
Returns the significance level of the slope (equivalently, of the correlation).
Returns the significance level of the slope (equivalently, of the correlation).
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl significance "reg1"
mentdb
0.2514643980065754
Used in use cases (2 recipes)
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › ANOVA of leads vs advertising spend
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl slope · cm get · cm remove · execute · file delete · json doc · json iobject
pa rl close · pa rl slope · cm get · cm remove · execute · file delete · json doc · json iobject
pa rl slope_confidence_interval <regId>
Description
Returns the half-width of a 95% confidence interval for the slope estimate.
Returns the half-width of a 95% confidence interval for the slope estimate.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl slope_confidence_interval "reg1"
mentdb
15.027949957243381
Used in use cases (4 recipes)
Materials scientist › Weibull modulus of a ceramic
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › ANOVA of leads vs advertising spend
Materials scientist › Weibull modulus of a ceramic
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl slope · pa rl add_data · pa rl count · pa rl intercept · pa rl load_empty · pa rl load_from_json · pa rl mean_square_error
pa rl close · pa rl slope · pa rl add_data · pa rl count · pa rl intercept · pa rl load_empty · pa rl load_from_json · pa rl mean_square_error
pa rl slope_std_err <regId>
Description
Returns the standard error of the slope estimate, usually denoted s(b1).
Returns the standard error of the slope estimate, usually denoted s(b1).
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl slope_std_err "reg1"
mentdb
5.412658773652741
Used in use cases (2 recipes)
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Forecaster & econometrician › ANOVA of leads vs advertising spend
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl exist · pa rl intercept_std_err · pa rl slope · json doc · json iobject · math round_sig · pa rl add_data
pa rl close · pa rl exist · pa rl intercept_std_err · pa rl slope · json doc · json iobject · math round_sig · pa rl add_data
pa rl sum_squared_errors <regId>
Description
Returns the sum of squared errors (SSE) associated with the regression model.
Returns the sum of squared errors (SSE) associated with the regression model.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl sum_squared_errors "reg1"
mentdb
1562.5
Used in use cases (2 recipes)
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › ANOVA of leads vs advertising spend
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl mean_square_error · pa rl r · pa rl slope · pa rl slope_confidence_interval · pa rl total_sum_squares · dsp detrend · dsp peaks
pa rl close · pa rl mean_square_error · pa rl r · pa rl slope · pa rl slope_confidence_interval · pa rl total_sum_squares · dsp detrend · dsp peaks
pa rl total_sum_squares <regId>
Description
Returns the sum of squared deviations of the y values about their mean.
Returns the sum of squared deviations of the y values about their mean.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl total_sum_squares "reg1"
mentdb
2263.3333333333335
Used in use cases (2 recipes)
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › ANOVA of leads vs advertising spend
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl mean_square_error · pa rl r · pa rl slope · pa rl slope_confidence_interval · pa rl sum_squared_errors · dsp detrend · dsp peaks
pa rl close · pa rl mean_square_error · pa rl r · pa rl slope · pa rl slope_confidence_interval · pa rl sum_squared_errors · dsp detrend · dsp peaks
pa rl x_sum_squares <regId>
Description
Returns the sum of squared deviations of the x values about their mean.
Returns the sum of squared deviations of the x values about their mean.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl x_sum_squares "reg1"
mentdb
13.333333333333334
Often used with
json doc · json iobject · pa rl add_data · pa rl close · pa rl exist · pa rl intercept_std_err · pa rl load_empty · pa rl mean_square_error
json doc · json iobject · pa rl add_data · pa rl close · pa rl exist · pa rl intercept_std_err · pa rl load_empty · pa rl mean_square_error
pa rl slope_confidence_interval <regId> <alpha>
Description
Returns the half-width of a (100-100*alpha)% confidence interval for the slope estimate.
Returns the half-width of a (100-100*alpha)% confidence interval for the slope estimate.
Parameters
regId: The regression id - string - required
alpha: The double alpha - number - not required
regId: The regression id - string - required
alpha: The double alpha - number - not required
admin
pa rl slope_confidence_interval "reg1" 0.2
mentdb
51.80063969449396
Used in use cases (4 recipes)
Materials scientist › Weibull modulus of a ceramic
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › ANOVA of leads vs advertising spend
Materials scientist › Weibull modulus of a ceramic
Climate & environment scientist › Warming trend and a hidden cycle
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › ANOVA of leads vs advertising spend
Often used with
pa rl close · pa rl slope · pa rl add_data · pa rl count · pa rl intercept · pa rl load_empty · pa rl load_from_json · pa rl mean_square_error
pa rl close · pa rl slope · pa rl add_data · pa rl count · pa rl intercept · pa rl load_empty · pa rl load_from_json · pa rl mean_square_error
pa rl close <regId>
Description
Close a regression
Close a regression
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rl close "reg1";
mentdb
1
Used in use cases (7 recipes)
Materials scientist › Weibull modulus of a ceramic
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Climate & environment scientist › Warming trend and a hidden cycle
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › ANOVA of leads vs advertising spend
and 1 more in the Use cases
Materials scientist › Weibull modulus of a ceramic
Aeronautical engineer › Parabolic drag polar from wind tunnel data
Climate & environment scientist › Warming trend and a hidden cycle
Industrial quality engineer › Gauge linearity and bias study from the lab database
Forecaster & econometrician › Sales trend and next quarter forecast
Forecaster & econometrician › ANOVA of leads vs advertising spend
and 1 more in the Use cases
Often used with
pa rl slope · pa rl count · pa rl intercept · pa rl predict · pa rl r_square · pa rl slope_confidence_interval · pa rl load_from_json · cm get
pa rl slope · pa rl count · pa rl intercept · pa rl predict · pa rl r_square · pa rl slope_confidence_interval · pa rl load_from_json · cm get
pa rl close_all
Description
Close all regressions
Close all regressions
admin
pa rl close_all;
mentdb
1
pa rm load <regId> <cmId> <fieldX1> <fieldX2> <fieldX3> <fieldX4> <fieldX5> <fieldY> <sqlSource>
Description
Load a multiple regression from the database
Load a multiple regression from the database
Parameters
regId: The regression id - string - required
cmId: The database connection id - string - required
fieldX1: The field X1 - string - required
fieldX2: The field X2 - string - required
fieldX3: The field X3 - string - required
fieldX4: The field X4 - string - required
fieldX5: The field X5 - string - required
fieldY: The field X - string - required
sqlSource: The select query (origin) - string - required
regId: The regression id - string - required
cmId: The database connection id - string - required
fieldX1: The field X1 - string - required
fieldX2: The field X2 - string - required
fieldX3: The field X3 - string - required
fieldX4: The field X4 - string - required
fieldX5: The field X5 - string - required
fieldY: The field X - string - required
sqlSource: The select query (origin) - string - required
admin
pa rm load "reg1" "demo_cm_mysql" "id" "quantity" "" "" "" "price" "select * from products limit 0, 500";
mentdb
1
Used in use cases (2 recipes)
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Promotion uplift from the weekly sales table
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Promotion uplift from the weekly sales table
Often used with
cm get · cm remove · execute · file delete · pa rm close · pa rm estimate_regression_parameters · sql connect · sql disconnect
cm get · cm remove · execute · file delete · pa rm close · pa rm estimate_regression_parameters · sql connect · sql disconnect
pa rm load_from_json <regId> <jsonArrayX> <jsonArrayY>
Description
Load a multiple regression from two JSON arrays of doubles
Load a multiple regression from two JSON arrays of doubles
Parameters
regId: The regression id - string - required
jsonArrayX: The JSON array of X - string - required
jsonArrayY: The JSON array of Y - string - required
regId: The regression id - string - required
jsonArrayX: The JSON array of X - string - required
jsonArrayY: The JSON array of Y - string - required
admin
pa rm load_from_json "reg1" "[ [ 1.0, 23.457 ], [ 2.0, 29.987 ], [ 3.0, 89.987 ], [ 4.0, 99.098 ], [ 5.0, 123.08 ] ]" "[7.5, 9.8, 14.7, 14.7, 19.4]";
mentdb
1
Used in use cases (10 recipes)
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Forecaster & econometrician › Demand model and price elasticity
Logistics & supply chain › Shipping tariff from past deliveries
and 4 more in the Use cases
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Forecaster & econometrician › Demand model and price elasticity
Logistics & supply chain › Shipping tariff from past deliveries
and 4 more in the Use cases
pa rm set_no_intercept <regId> <bool>
Description
Set no intercept
Set no intercept
Parameters
regId: The regression id - string - required
bool: The boolean - boolean - required
regId: The regression id - string - required
bool: The boolean - boolean - required
admin
pa rm set_no_intercept "reg1" true
mentdb
1
Used in use cases (5 recipes)
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Regression through the origin: heating energy of a building
Forecaster & econometrician › Cost model through the origin
Sales & marketing analyst › Media mix model through the origin
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Regression through the origin: heating energy of a building
Forecaster & econometrician › Cost model through the origin
Sales & marketing analyst › Media mix model through the origin
pa rm calculate_adjusted_r_squared <regId>
Description
Returns the adjusted R-squared statistic, defined by the formula R2adj = 1 - [SSR (n - 1)] / [SSTO (n - p)]
Returns the adjusted R-squared statistic, defined by the formula R2adj = 1 - [SSR (n - 1)] / [SSTO (n - p)]
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm calculate_adjusted_r_squared "reg1"
mentdb
0.9930302201822587
Used in use cases (5 recipes)
Process & reactor engineer › Yield model from a factorial design
Data scientist › Price of flats by multiple linear regression
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Demand model and price elasticity
Forecaster & econometrician › Cost model through the origin
Process & reactor engineer › Yield model from a factorial design
Data scientist › Price of flats by multiple linear regression
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Demand model and price elasticity
Forecaster & econometrician › Cost model through the origin
pa rm calculate_residual_sum_of_squares <regId>
Description
Returns the sum of squared residuals.
Returns the sum of squared residuals.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm calculate_residual_sum_of_squares "reg1"
mentdb
2.6787094169120644
Often used with
json doc · json iobject · math abs · math sqrt · pa rm calculate_total_sum_of_squares · pa rm close · pa rm estimate_error_variance · pa rm estimate_regressand_variance
json doc · json iobject · math abs · math sqrt · pa rm calculate_total_sum_of_squares · pa rm close · pa rm estimate_error_variance · pa rm estimate_regressand_variance
pa rm calculate_r_squared <regId>
Description
Returns the R-Squared statistic, defined by the formula R2 = 1 - SSR / SSTO
Returns the R-Squared statistic, defined by the formula R2 = 1 - SSR / SSTO
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm calculate_r_squared "reg1"
mentdb
0.9972120880729035
Used in use cases (6 recipes)
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Forecaster & econometrician › Demand model and price elasticity
Sales & marketing analyst › Media mix model through the origin
Forecaster & econometrician › Promotion uplift from the weekly sales table
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Forecaster & econometrician › Demand model and price elasticity
Sales & marketing analyst › Media mix model through the origin
Forecaster & econometrician › Promotion uplift from the weekly sales table
pa rm calculate_total_sum_of_squares <regId>
Description
Returns the sum of squared deviations of Y from its mean.
Returns the sum of squared deviations of Y from its mean.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm calculate_total_sum_of_squares "reg1"
mentdb
960.8299999999999
pa rm estimate_error_variance <regId>
Description
Estimates the variance of the error.
Estimates the variance of the error.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm estimate_error_variance "reg1"
mentdb
1.3393547084560322
pa rm estimate_regressand_variance <regId>
Description
Returns the variance of the regressand, i.e. Var(y).
Returns the variance of the regressand, i.e. Var(y).
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm estimate_regressand_variance "reg1"
mentdb
21.746999999999996
pa rm estimate_regression_standard_error <regId>
Description
Estimates the standard error of the regression.
Estimates the standard error of the regression.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm estimate_regression_standard_error "reg1"
mentdb
1.1573049332202954
Used in use cases (4 recipes)
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Forecaster & econometrician › Calibrate a two-rate electricity tariff
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Forecaster & econometrician › Calibrate a two-rate electricity tariff
pa rm estimate_regression_parameters_variance <regId>
Description
Estimates the variance of the regression parameters, i.e. Var(b).
Estimates the variance of the regression parameters, i.e. Var(b).
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm estimate_regression_parameters_variance "reg1"
mentdb
[ [ 1.1939297361248733, -0.6413091167219049, 0.012718472658507332 ], [ -0.6413091167219049, 1.3402027085716288, -0.04621465840546843 ], [ 0.012718472658507332, -0.04621465840546843, 0.0017221335163781243 ] ]
pa rm estimate_residuals <regId>
Description
Estimates the residuals, i.e. u = y - X*b.
Estimates the residuals, i.e. u = y - X*b.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm estimate_residuals "reg1"
mentdb
[ -0.21160225532182864, 0.39217249531173515, 0.5051039893042244, -1.3403164432563521, 0.6546422139622123 ]
Used in use cases (2 recipes)
Forecaster & econometrician › Calibrate a two-rate electricity tariff
Logistics & supply chain › Shipping tariff from past deliveries
Forecaster & econometrician › Calibrate a two-rate electricity tariff
Logistics & supply chain › Shipping tariff from past deliveries
Often used with
pa rm close · pa rm estimate_regression_parameters · pa rm load_from_json · json doc · json iobject · math abs · math sqrt · pa rm calculate_residual_sum_of_squares
pa rm close · pa rm estimate_regression_parameters · pa rm load_from_json · json doc · json iobject · math abs · math sqrt · pa rm calculate_residual_sum_of_squares
pa rm estimate_regression_parameters_standard_errors <regId>
Description
Returns the standard errors of the regression parameters.
Returns the standard errors of the regression parameters.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm estimate_regression_parameters_standard_errors "reg1"
mentdb
[ 1.264553444360703, 1.3397786414221338, 0.04802653051960952 ]
Used in use cases (8 recipes)
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Demand model and price elasticity
Logistics & supply chain › Shipping tariff from past deliveries
and 2 more in the Use cases
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Demand model and price elasticity
Logistics & supply chain › Shipping tariff from past deliveries
and 2 more in the Use cases
pa rm estimate_regression_parameters <regId>
Description
Estimates the regression parameters b.
Estimates the regression parameters b.
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm estimate_regression_parameters "reg1"
mentdb
[ 5.036908634809639, 1.3187573895222953, 0.05780518527475357 ]
Used in use cases (12 recipes)
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Demand model and price elasticity
and 6 more in the Use cases
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Demand model and price elasticity
and 6 more in the Use cases
pa rm predict <regId> <jsonX>
Description
Make a prediction
Make a prediction
Parameters
regId: The regression id - string - required
jsonX: The JSON that contains an array of x - string - required
regId: The regression id - string - required
jsonX: The JSON that contains an array of x - string - required
admin
pa rm predict "reg1" "[12, 34]"
mentdb
22.827373608418803
Used in use cases (9 recipes)
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Forecaster & econometrician › Demand model and price elasticity
Logistics & supply chain › Shipping tariff from past deliveries
Sales & marketing analyst › Media mix model through the origin
and 3 more in the Use cases
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Forecaster & econometrician › Demand model and price elasticity
Logistics & supply chain › Shipping tariff from past deliveries
Sales & marketing analyst › Media mix model through the origin
and 3 more in the Use cases
pa rm exist <regId>
Description
Check if a regression already exists
Check if a regression already exists
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm exist "reg1"
mentdb
1
pa rm show
Description
Show all regressions
Show all regressions
admin
pa rm show
mentdb
[ "reg1" ]
pa rm close <regId>
Description
Close a regression
Close a regression
Parameters
regId: The regression id - string - required
regId: The regression id - string - required
admin
pa rm close "reg1";
mentdb
1
Used in use cases (12 recipes)
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Demand model and price elasticity
and 6 more in the Use cases
Electrochemist & battery engineer › Diffusion coefficient from a Cottrell plot
Process & reactor engineer › Yield model from a factorial design
Pharmacist & pharmacokinetics › Population PK: renal and non-renal clearance
Data scientist › Price of flats by multiple linear regression
Statistician & biostatistician › Mincer wage equation from a survey table in SQL
Forecaster & econometrician › Demand model and price elasticity
and 6 more in the Use cases
pa rm close_all
Description
Close all regressions
Close all regressions
admin
pa rm close_all;
mentdb
1
