Thank you very much for sharing. I'd like to do this myself on a dataset. Can you confirm you used the Analytic Solver Data Science extension from Frontline Solvers?
I think you forgot to mention that we need to add in an additional software package such as XLSTAT or something like that. That sure would have saved me a bunch if time trying to figure out why I don’t see the correct tabs.
Hi Dr Burch - Ditto to questioner below. In Microsoft 365 Excel, I can't find 'Data Mining' tab. I used to be able to do PCA in Excel, and crank out component scores & latents. Suggestions, please.
Thank you very much for sharing. I'd like to do this myself on a dataset. Can you confirm you used the Analytic Solver Data Science extension from Frontline Solvers?
I think you forgot to mention that we need to add in an additional software package such as XLSTAT or something like that. That sure would have saved me a bunch if time trying to figure out why I don’t see the correct tabs.
What is the add-in for the PCA?
Thank you for sharing these excellent tutorials. Could you please tell me how can I add this Analytic solver and Data mining extension in my excel.?
Where can the add-in for the PCA found in Excel?
Great video but how does one find the data mining analysis icon in excel?
Hi Dr Burch - Ditto to questioner below. In Microsoft 365 Excel, I can't find 'Data Mining' tab. I used to be able to do PCA in Excel, and crank out component scores & latents. Suggestions, please.
It does not appear that the data mining tab is possible to use on newer versions of Excel? Kind of useless then..