I did a study where I used 4 variables in a cluster analysis and came up with 5 natural groupings of the respondents. Now my client wants me to create an Excel typing tool for future respondents where they will put in the answers to the 4 variables (3 categorical, 1 continuous) and the tool will automatically fill in one of the 5 cluster groups based on their 4 answers. I can run discriminant analysis in SPSS with the current data and the predicted values are very close to the observed values so it works great. My problems is that I do not know how to create an algorithm in Excel that will automatically place the future respondents in the correct cluster group. I'm assuming I can get this information from the SPSS output but am not sure exactly how. Any help would be greatly appreciated! Thank you!