PsiPosteriors()

 PsiPosteriors(Model, Input_Data, [Header]) 

Computes the posterior probabilities for Input_Data using a Classification model stored in PMML format. Note: If using an Excel version that does not support Dynamic Arrays, this formula must be entered as an Excel array.

Input_Data: Range containing the stored Classification model in PMML format.

Model: Range containing the new data for computing posterior probabilities. Range must contain a header with column names and at least one row of data containing the exact same features (or columns) as the data used to create the model.

Header: (Optional) If True, a heading will be inserted above the returned results.

In Analytic Solver Cloud and in newer versions of desktop Excel, PsiPosterior() returns a Dynamic Array (see Note in section heading, above). To use this function as a dynamic array, you need only enter the Psi function in one cell as a normal function, i.e., not as a control array. The contents of the Dynamic Array will "spill" down the column. If a nonblank cell is "blocking" the contents of the Dynamic Array, PsiForecast() will return #SPILL until such time as the blockage is removed.

Output:Multiple columns containing a header with class labels and estimated posterior probabilities for each class label for all records in Input_Data.

Supported Models:

• Classification:
  • Linear Discriminant Analysis
  • Logistic Regression
  • K-Nearest Neighbors
  • Classification Tree
  • Naïve Bayes
  • Neural Network
  • Random Trees
  • Bagging (with any supported weak learner)
  • Boosting (with any supported weak learner)

Previous related Psi Scoring functions: N/A