In this article
The scripting model for Linear Regression includes a method for performing a dynamic regression calculation. This scripting model can typically be used in content headers in aggregated tables to specify which data from a linear regression is to be displayed. An example of this:
var utils = report.MultivarStatisticsUtils;
var regRun : RegressionRun = report.MultivarStatisticsUtils.GetDynamicLinearRegressionRun("linear regression", 1);
var hcb : HeaderContent = table.ColumnHeaders[0];
hcb.SetCellValue(0, regRun.RegCoeff[1]);
hcb.SetCellValue(1, regRun.RegCoeff[2]);
hcb.SetCellValue(2, regRun.RegCoeff[3]);
hcb.SetCellValue(3, regRun.RegCoeff[4]);
var hcbeta : HeaderContent = table.ColumnHeaders[1];
hcbeta.SetCellValue(0, regRun.StandardizedRegCoeff[1]);
hcbeta.SetCellValue(1, regRun.StandardizedRegCoeff[2]);
hcbeta.SetCellValue(2, regRun.StandardizedRegCoeff[3]);
hcbeta.SetCellValue(3, regRun.StandardizedRegCoeff[4]);
var hcpii : HeaderContent = table.ColumnHeaders[2];
hcpii.SetCellValue(0, ((100 - regRun.IndepVarMeanPercentValues[0])*regRun.StandardizedRegCoeff[1]));
hcpii.SetCellValue(1, ((100 - regRun.IndepVarMeanPercentValues[1])*regRun.StandardizedRegCoeff[2]));
hcpii.SetCellValue(2, ((100 - regRun.IndepVarMeanPercentValues[2])*regRun.StandardizedRegCoeff[3]));
hcpii.SetCellValue(3, ((100 - regRun.IndepVarMeanPercentValues[3])*regRun.StandardizedRegCoeff[4]));
An overview of the scripting models available for Linear Regression:
MultivarStatisticsUtils:
RegressionRun GetLinearRegressionRun(string linRegName, int runNumber)
RegressionRun GetLastLinearRegressionRun(string linRegName)
RegressionRun[] GetAllLinearRegressionRuns(string linRegName)
RegressionRun GetDynamicLinearRegressionRun(string linRegName, int runNumber)
The first three methods retrieve the static calculations from the analyst toolbox – the last gets the dynamically calculated regression based on a static calculation in the analyst toolbox. This will be the one to use in this case.
Properties on the RegressionRun object:
RegressionRun
string DependentVariableName
string[] IndependentVariableNames
string FilterExpression
double[] RegCoeff <- B values
double[] RegCoeffStdError
double[] StandardizedRegCoeff <- Beta values
double[] RegCoeffTValues
double[] RegCoeffTSigValues
double[] IndepVarMeanValues
string[] IndepVarMeanPercentValues
double R
double RSquared
double AdjRSquared
double StdErrorEstimate
double SumSquaredReg
double SumSquaredErr
double MeanSquaredReg
double MeanSquaredErr
double FValue
double FSigValue
double NumObservations
double RegDegreesFreedom
double ResidualDegreesFreedom
DateTime CalculationTimestamp