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