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

Classification Algorithm Stored Model Sheet
Linear Discriminant Analysis Classification DA_Stored
Logistic Regression Classification LogReg_Stored
k-Nearest Neighbors Classification KNNC_Stored
Classification Trees CT_Stored
Naive Bayes Classification NB_Stored
Neural Networks Classification NNC_Stored
Ensemble Methods for Classification