Worksheet |
WorksheetMethods provides common utility methods for multivariate data analysis.
Inheritance HierarchySystemObject
Altaxo.Calc.Regression.MultivariateWorksheetAnalysis
Altaxo.Calc.Regression.MultivariatePCRWorksheetAnalysis
Altaxo.Calc.Regression.MultivariatePLS1WorksheetAnalysis
Altaxo.Calc.Regression.MultivariatePLS2WorksheetAnalysis
Altaxo.Calc.Regression.MultivariateWorksheetAnalysis
Altaxo.Calc.Regression.MultivariatePCRWorksheetAnalysis
Altaxo.Calc.Regression.MultivariatePLS1WorksheetAnalysis
Altaxo.Calc.Regression.MultivariatePLS2WorksheetAnalysis
Namespace: Altaxo.Calc.Regression.Multivariate
Assembly: AltaxoBase (in AltaxoBase.dll) Version: 4.8.3572.0 (4.8.3572.0)
SyntaxC#
public abstract class WorksheetAnalysis
The WorksheetAnalysis type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | WorksheetAnalysis | Initializes a new instance of the WorksheetAnalysis class |
Properties| Name | Description | |
|---|---|---|
 | AnalysisName | Name of the Analysis, like PLS1, PLS2 or PCR. |
Methods| Name | Description | |
|---|---|---|
 | CalculateAdditionalColumn | Calculates and stores a single additional result column. |
| CalculateAdditionalColumns | Calculates and stores all requested additional result columns. |
| CalculateAndStorePredictionScores(DataTable, Int32) | Calculates and stores prediction scores for all dependent variables. |
| CalculateAndStorePredictionScores(DataTable, Int32, Int32) | Calculates and stores prediction scores for a single dependent variable. |
| CalculateCrossPredictedAndResidual | Calculates and optionally stores cross-predicted values and residuals. |
| CalculateCrossPredictedY | Calculates cross-predicted y-values for the provided spectra. |
| CalculateCrossPRESS | Calculate the cross PRESS values and stores the results in the provided table. |
| CalculatePredictedAndResidual | Calculates and optionally stores predicted values and residuals. |
| CalculatePredictedY | For a given set of spectra, predicts the y-values and stores them in the matrix predictedY |
| CalculatePredictionScores | Calculates the prediction scores. In case of a single y-variable, the prediction score is a vector of the same length than a spectrum. Multiplying the prediction score (dot product) with a spectrum, it yields the predicted y-value (of cause mean-centered). |
| CalculatePreprocessedSpectra | Fills a provided table (should be empty) with the preprocessed spectra. The spectra are saved as columns (independently on their former orientation in the original worksheet). |
| CalculateXLeverage | Calculates the leverage of the spectral data. |
| CalculateXResidual | Calculates spectral residuals for the specified y-component and factor count. |
| CalculateYPredicted | Calculated the predicted y for the component given by whichY and for the given number of factors. |
| CalculateYResidual | Calculates the y-residuals (concentration etc.). |
| CreateNewRegressionObject | Creates a regression object appropriate for the current analysis. |
| EnsureMatchingXOfX | Compares the two arrays and throws an InvalidOperationException if the data not match. |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
| ExecuteAnalysis(AltaxoDocument, DataTableMatrixProxyWithMultipleColumnHeaderColumns, DimensionReductionAndRegressionOptions, DataTable) | Makes a PLS (a partial least squares) analysis of the table or the selected columns / rows and stores the results in a newly created table. Here, the spectra are stored in the data columns of the proxy, the target variables are located in the ColumnHeaderColumns of the proxy. |
| ExecuteAnalysis(IMatrixDouble, IMatrixDouble, DimensionReductionAndRegressionOptions, DataTable, IReadOnlyListDouble) | Execute an analysis and stores the result in the provided table. |
| ExecuteAnalysis(AltaxoDocument, DataTable, IAscendingIntegerCollection, IAscendingIntegerCollection, IAscendingIntegerCollection, Boolean, DimensionReductionAndRegressionOptions) | Makes a PLS (a partial least squares) analysis of the table or the selected columns / rows and stores the results in a newly created table. |
| ExecuteAnalysis(AltaxoDocument, DataTableMatrixProxyWithMultipleColumnHeaderColumns, MatrixDouble, MatrixDouble, Double, DimensionReductionAndRegressionOptions, DataTable, DimensionReductionAndRegressionResult) | Makes a PLS (a partial least squares) analysis of the table or the selected columns / rows and stores the results in a newly created table. |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetCalibrationModel | Returns an instance of the calibration model specific for the multivariate analysis. |
 | GetCrossPRESSValue_ColumnName | Gets the cross-PRESS column name. |
| GetCrossProduct_ColumnName | Gets the cross-product column name. |
| GetCrossProduct_ColumnName(Int32) | Gets the cross-product column name for the specified constituent. |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetMeasurementLabel_ColumnName | Gets the measurement label column name. |
| GetNumberOfFactors_ColumnGroup | Gets the column group used for the factor count column. |
| GetNumberOfFactors_ColumnName | Gets the column name used for the factor count column. |
| GetOriginalY | Using the information in the plsMemo, gets the matrix of original Y (concentration) data. |
| GetPredictionScore_ColumnGroup | Gets the column group used for prediction scores. |
| GetPredictionScore_ColumnName | Gets the prediction score column name for the specified constituent and factor. |
| GetPRESSValue_ColumnName | Gets the PRESS column name. |
| GetRawSpectra | Fills a matrix with the selected data of a table. |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| GetXCrossResidual_ColumnGroup | Gets the column group used for cross spectral residuals. |
| GetXCrossResidual_ColumnName | Gets the column name of a X-Crossvalidated spectral Residual column |
| GetXLeverage_ColumnGroup | Gets the column group used for leverage values. |
| GetXLeverage_ColumnName(Int32) | Gets the column name of a X-Leverage column |
| GetXLeverage_ColumnName(Int32, Int32) | Gets the column name of a X-Leverage column |
| GetXLoad_ColumnName(Int32) | Gets the x-load column name for the specified factor. |
| GetXLoad_ColumnName(Int32, Int32) | Gets the x-load column name for the specified constituent and factor. |
| GetXMean_ColumnName | Gets the column name used for the mean of x-values. |
| GetXOfSpectra | Returns the corresponding x-values of the spectra (In fact only the first spectra is used to determine which x-column is used). |
| GetXOfX_ColumnName | Gets the column name used for x-axis values of spectra. |
| GetXResidual_ColumnGroup | Gets the column group used for spectral residuals. |
| GetXResidual_ColumnName | Gets the column name of a X-Residual column |
| GetXScale_ColumnName | Gets the column name used for the scale of x-values. |
| GetXScore_ColumnName | Gets the x-score column name for the specified factor. |
| GetXWeight_ColumnName(Int32) | Gets the x-weight column name for the specified factor. |
| GetXWeight_ColumnName(Int32, Int32) | Gets the x-weight column name for the specified constituent and factor. |
| GetXYMatricesOfSpectralColumns | Gets the spectral and target variable matrices (both unpreprocessed) for analysis. |
| GetYCrossPredicted_ColumnGroup | Gets the column group used for cross-predicted y-values. |
| GetYCrossPredicted_ColumnName | Gets the column name of a Y-Cross-Predicted column |
| GetYCrossResidual_ColumnGroup | Gets the column group used for cross residual y-values. |
| GetYCrossResidual_ColumnName | Gets the column name of a Y-Cross-Residual column |
| GetYLoad_ColumnName(Int32) | Gets the y-load column name for the specified factor. |
| GetYLoad_ColumnName(Int32, Int32) | Gets the y-load column name for the specified constituent and factor. |
| GetYMean_ColumnName | Gets the column name used for the mean of y-values. |
| GetYOriginal_ColumnName | Gets the column name of a Y-Original column |
| GetYPredicted_ColumnGroup | Gets the column group used for predicted y-values. |
| GetYPredicted_ColumnName | Gets the column name of a Y-Predicted column |
| GetYResidual_ColumnGroup | Gets the column group used for y residuals. |
| GetYResidual_ColumnName | Gets the column name of a Y-Residual column |
| GetYScale_ColumnName | Gets the column name used for the scale of y-values. |
| IsDimensionReductionAndRegressionModel | Determines whether the specified table uses a dimension-reduction-and-regression data source. |
| MapSpectralX | This maps the indices of a master x column to the indices of a column to map. |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| NotFound | Throws an exception indicating that a required column was not found. |
| PredictValues(DataTableMatrixProxyWithMultipleColumnHeaderColumns, Int32, DataTable, DataTable) | This predicts the selected columns/rows against a user choosen calibration model. The orientation of spectra is given by the parameter spectrumIsRow. |
| PredictValues(DataTable, IAscendingIntegerCollection, IAscendingIntegerCollection, Int32, DataTable, DataTable) | This predicts the selected columns/rows against a user choosen calibration model. The orientation of spectra is given by the parameter spectrumIsRow. |
| RemoveNonNumericCells | For given selected columns and selected rows, the procedure removes all nonnumeric cells. Furthermore, if either selectedColumns or selectedRows is empty, the collection is filled by the really used rows/columns. |
| SaveAuxiliaryDataToTable | Saves auxiliary data that is associated with samples. |
| StoreCalculatedColumn | Stores the information that a given column was calculated inside the DataSource object of the table. |
| StoreCalibrationModelInTable | Stores the calibrationSet into the data table table. |
| StoreFRatioData | Stores F-ratio and F-probability data derived from PRESS values. |
| StoreNumberOfFactors | Stores the number-of-factors column in the destination table. |
| StoreOriginalY | Stores the original y-values in the destination table. |
| StorePreprocessedData | Stores preprocessing information and dependent-variable scaling in the table. |
| StorePRESSData | Stores PRESS data in the destination table. |
| StoreXOfX | Stores the x-axis values for the spectra in the destination table. |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
See Also