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.3261.0 (4.8.3261.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 | |
| CalculateAdditionalColumns | |
| CalculateAndStorePredictionScores(DataTable, Int32) | |
| CalculateAndStorePredictionScores(DataTable, Int32, Int32) | |
| CalculateCrossPredictedAndResidual | |
| CalculateCrossPredictedY | |
| CalculateCrossPRESS | Calculate the cross PRESS values and stores the results in the provided table. |
| CalculatePredictedAndResidual | |
| 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 | |
| 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 | |
| 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, IMatrixDouble, IMatrixDouble, 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 | |
| GetCrossProduct_ColumnName | |
| GetCrossProduct_ColumnName(Int32) | |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetMeasurementLabel_ColumnName | |
| GetNumberOfFactors_ColumnGroup | |
| GetNumberOfFactors_ColumnName | |
| GetOriginalY | Using the information in the plsMemo, gets the matrix of original Y (concentration) data. |
| GetPredictionScore_ColumnGroup | |
| GetPredictionScore_ColumnName | |
| GetPRESSValue_ColumnName | |
| GetRawSpectra | Fills a matrix with the selected data of a table. |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| GetXCrossResidual_ColumnGroup | |
| GetXCrossResidual_ColumnName | Gets the column name of a X-Crossvalidated spectral Residual column |
| GetXLeverage_ColumnGroup | |
| 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) | |
| GetXLoad_ColumnName(Int32, Int32) | |
| GetXMean_ColumnName | |
| 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 | |
| GetXResidual_ColumnGroup | |
| GetXResidual_ColumnName | Gets the column name of a X-Residual column |
| GetXScale_ColumnName | |
| GetXScore_ColumnName | |
| GetXWeight_ColumnName(Int32) | |
| GetXWeight_ColumnName(Int32, Int32) | |
| GetXYMatricesOfSpectralColumns | Gets the spectral and target variable matrices (both unpreprocessed) for analysis. |
| GetYCrossPredicted_ColumnGroup | |
| GetYCrossPredicted_ColumnName | Gets the column name of a Y-Cross-Predicted column |
| GetYCrossResidual_ColumnGroup | |
| GetYCrossResidual_ColumnName | Gets the column name of a Y-Cross-Residual column |
| GetYLoad_ColumnName(Int32) | |
| GetYLoad_ColumnName(Int32, Int32) | |
| GetYMean_ColumnName | |
| GetYOriginal_ColumnName | Gets the column name of a Y-Original column |
| GetYPredicted_ColumnGroup | |
| GetYPredicted_ColumnName | Gets the column name of a Y-Predicted column |
| GetYResidual_ColumnGroup | |
| GetYResidual_ColumnName | Gets the column name of a Y-Residual column |
| GetYScale_ColumnName | |
| IsDimensionReductionAndRegressionModel | |
| 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 | |
| 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. |
| 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 | |
| StoreNumberOfFactors | |
| StoreOriginalY | |
| StorePreprocessedData | |
| StorePRESSData | |
| StoreXOfX | |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
See Also