File Uploads for Blog
This page is for maintaining links to QPacks which are used in blog posts. If you create a QPack for a blog post, link to it here below the page title.
- 1 Q
- 2 Displayr
- 3 Displayr
How to Predict Categories From Linear Discriminant Analysis in Excel
Linear Discriminant Analysis is used to predict the categories of a categorical variable based on the respondent's values from two or more numeric variables. The predicted categories from LDA can be saved to your data set using Create > Classifier > Save Variable(s) > Discriminant Variables. Sometimes, it is necessary to make these predictions outside of Q, e.g. in a spreadsheet or an online tool. This page describes how to get the required data from the LDA to set up the calculation in Excel.
Using Stata Files
QScript for getting variable labels for a Stata DTA file that has been imported as an R data set.