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?
What is the add-in for the PCA?
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.
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.?
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.
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?
It does not appear that the data mining tab is possible to use on newer versions of Excel? Kind of useless then..