Principal Component Analysis with Excel Solver

Поділитися
Вставка
  • Опубліковано 10 гру 2024

КОМЕНТАРІ • 8

  • @DDendrite2
    @DDendrite2 8 місяців тому +2

    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?

  • @kendesmarais9018
    @kendesmarais9018 8 місяців тому +8

    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.

  • @kydkidd
    @kydkidd Рік тому +10

    What is the add-in for the PCA?

  • @nes9714
    @nes9714 9 місяців тому +2

    Where can the add-in for the PCA found in Excel?

  • @riazuddin596
    @riazuddin596 Рік тому +3

    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.?

  • @pablonutribar8708
    @pablonutribar8708 8 місяців тому +3

    It does not appear that the data mining tab is possible to use on newer versions of Excel? Kind of useless then..

  • @geneticsprof
    @geneticsprof Рік тому +1

    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.

  • @felixoyie936
    @felixoyie936 7 місяців тому +1

    Great video but how does one find the data mining analysis icon in excel?