KamakuraAnalyticTools
KamakuraAnalyticTools
  • 18
  • 148 353
How to install KATE (Kamakura's Analytic tools for Excel)
A new tutorial showing the steps you must follow to successfully install KATE. Every small step matters!
Переглядів: 3 340

Відео

ExtracText for Excel
Переглядів 4184 роки тому
This tutorial describes an Excel tool for text extracting, mining, and coding, which is part of KATE (Kamakura's Analytic Tools for Excel). You may download and install this free suite of Excel AddIns from wak2.web.rice.edu/bio/Kamakura_Analytic_Tools.html
Logistic Regression for Excel
Переглядів 52 тис.4 роки тому
In this tutorial I show how Logistic Regression works, and how you can run a logistic regression "from scratch" using Excel. I also show how my free KATE (Kamakura's Analytic Tools for Excel) allows you to easily run a Logistic Regression and/or a Predictive Stepwise Logistic Regression within Excel.
Predictive Stepwise Logistic Regression for Excel
Переглядів 9964 роки тому
This tutorial describes the simple process for selecting predictors for a Logistic Regression to maximize predictive fit, instead of calibration fit. It also demonstrates how you can run a Predictive Stepwise Logistic Regression using KATE (Kamakuras Analytic Tools for Excel)
Predictive Stepwise Linear Regression for Excel
Переглядів 2434 роки тому
A tutorial for Predictive Stepwise Linear Regression, one of the analytic tools available for free on KATE (Kamakura's Analytic Tools for Excel). This tool works similarly to traditional Stepwise Regression. However, instead of selecting predictors based on calibration fit, this tool builds a regression model that maximizes predictive fit.
Stepwise Linear Regression for Excel
Переглядів 9244 роки тому
A practical and intuitive explanation of how Linear Regression works, and how it is calibrated using OLS (Ordinary Least Squares). I also show how you can automatically select predictors with Stepwise Linear Regression using KATE (Kamakura's Analytic Tools for Excel) Don't forget to watch the tutorial on "Predictive Stepwise Linear Regression for Excel" If you want to build more complex non-lin...
Non-Linear Regression for Excel
Переглядів 4834 роки тому
An explanation of how you can estimate a non-linear model via Ordinary Least Squares using Excel. I show how to develop and calibrate a simple (but non-linear) epidemiological model for Covid-19 contagion in one country using Non-Linear Regression. This is not something you can do by mere variable-transformations.
Latent Class Analysis for Excel
Переглядів 2,6 тис.6 років тому
In this tutorial I explain the intuition behind Latent Class Analysis and its estimation via the Expectation-Maximization algorithm. I also show how you can run a LCA using KATE (Kamakura's Analytic Tools for Excel), which you may download for free at www.KATExcel.com. Table of Contents: 00:00 - Introduction 00:18 - K-Means clustering 14:55 - Running LCA
Merge by Keys
Переглядів 2406 років тому
Merge by Keys
Geographically Weighted Regression for Excel
Переглядів 6 тис.6 років тому
In this tutorial I explain the ideas behind geographically-weighted regression and show how you can run a Nearest K-neighbors Regression (special case of GWR) usding KATE (Kamakura's Analytic Tools for Excel). You may download and install KATE for free from www.KATExcel.com. Table of Contents: 00:00 - Introduction 07:51 - Marker 1 07:53 - Marker 2
Correspondence Analysis for Excel
Переглядів 3,5 тис.6 років тому
In this tutorial I explain the basic ideas behind Correspondence Analysis and show how you can run a multiple correspondence analysis using KATE (Kamakura's Analytic Tools for Excel), which you may download for free at www.KATExcel.com. Table of Contents: 00:00 - Introduction 00:20 - The intuition behind MCA 03:11 - Simple example of MCA
WordMap: BasicText Mining for Excel
Переглядів 1,1 тис.6 років тому
This video shows how you can translate text documents into a word cloud using Excel. WordMap performs basic text mining (stemming and filtering out prepositions, pronouns, common words, etc) on a collection of documents and then maps the extracted topics into a word cloud that reflects not only topic frequency but also affinity. WordMap also Habla Español and Fala Português! WordMap can perform...
Scatterplot with Labels for Excel
Переглядів 8506 років тому
In this tutorial I show how you can produce a scatterplot with labels automatically attached to each data point, using KATE (Kamakura's Analytic Tools for Excel), which you may download for free at www.KATExcel.com. If you have too many data points and expect them to overlap in the scatterplot, you may use the option of jittering them. This jittering is far from perfect, but better than having ...
Logistic Regression for Excel
Переглядів 30 тис.6 років тому
Table of Contents: 00:00 - Introduction 01:47 - Maximum Likelihood Estimation 07:49 - Assessing fit 12:01 - Running a Logistic Regression If you want to build a Logistic Regression automatically with Excel, watch my tutorial on "Predictive Stepwise Logistic Regression for Excel"
Factor or Principal Component Analysis for Excel
Переглядів 3,2 тис.6 років тому
Factor or Principal Component Analysis for Excel
3D scatterplot with Labels for Excel
Переглядів 30 тис.6 років тому
3D scatterplot with Labels for Excel
K-Means Clustering for Excel
Переглядів 9 тис.6 років тому
K-Means Clustering for Excel
How to install KATE (Kamakura's Analytic Tools for Excel)
Переглядів 4,1 тис.6 років тому
How to install KATE (Kamakura's Analytic Tools for Excel)

КОМЕНТАРІ

  • @ferencb.7083
    @ferencb.7083 Місяць тому

    Dear Sir, my Excel has this message after I tried debugging: "Set CurrentAddIn = Application.AddIns.Add(FullAddInPath, False) ' do not copy add-in". What can be the problem?

  • @marufahmad6905
    @marufahmad6905 7 місяців тому

    MS 365 Excel has disabled macros and I can't figure out how to allow macros.

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

    Thanks

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

    Thanks ,help a lot

  • @Opkopen
    @Opkopen Рік тому

    Nice

  • @jack-sv5qu
    @jack-sv5qu Рік тому

    hi sir, kindly share the link to download the data.

  • @Melody-ct1rt
    @Melody-ct1rt Рік тому

    is Logit Coeficiens same with 'coefficient' in linear regression? But how do we know if the predictors are actually gave proper 'r' ?

  • @999Belgirl
    @999Belgirl Рік тому

    Hello Mr Kamakura, I wanted to ask do you do lessons as a private tutor for Excel?

  • @qasimzaheer1140
    @qasimzaheer1140 Рік тому

    I get an error that says my data contains non-numerical values. It doesnt at all. How I do solve this, been at for hours now

  • @utkar1
    @utkar1 2 роки тому

    Time stamps @00:00 - Introduction @00:18 - KMeans Clustering @01:25 - Limitations of KMeans Clustering @02:27 - Latent Class Analysis

  • @sunnybaggu785
    @sunnybaggu785 2 роки тому

    How to draw 3d tetrahedron shape in excel chart

  • @johnowusukonduah2305
    @johnowusukonduah2305 2 роки тому

    THANK YOU SIRE FOR THIS GREAT TUTORIAL

  • @gaonkarbhushansadanand6410
    @gaonkarbhushansadanand6410 2 роки тому

    Shouldn't the 'IF' condition for calculating likelihood equate to something? e.g. if(B4=1, L4, (1-L4))

    • @leventdemir1757
      @leventdemir1757 Рік тому

      It's the same thing. You can leave it as If(B4,x,y) and it assumes If(B4=1).

  • @Nailesh232
    @Nailesh232 3 роки тому

    Thanks. Great Work Done !

  • @sandydsa
    @sandydsa 3 роки тому

    @Kamakura Analytic Tools. Thank you very much! Very helpful video. I noticed that some cells are empty. Is that ok in general? Also, did you have to transform the data or are those raw data?

  • @dilkumarbantawarai736
    @dilkumarbantawarai736 3 роки тому

    Perfect and good video tutorials for learners, Thank you very much.

  • @vuhanh2944
    @vuhanh2944 4 роки тому

    Dear Teacher, I would like to have this excel file of Logistics Regression, can you give me? please, thank you very much

  • @vuhanh2944
    @vuhanh2944 4 роки тому

    Ah, I see, KATE won't work on Apply/ Macbook

  • @vuhanh2944
    @vuhanh2944 4 роки тому

    Dear Teacher, I use Macbook, may I know if Macbook can install KATE?

  • @vuhanh2944
    @vuhanh2944 4 роки тому

    Dear Teacher, may I have excel file? I would like to learn details of formulas, thank you very much

  • @vuhanh2944
    @vuhanh2944 4 роки тому

    Thank you very much, great lesson

  • @yulinliu850
    @yulinliu850 4 роки тому

    Wonderful tool in Excel!

  • @linkasmr5666
    @linkasmr5666 4 роки тому

    were you trying to give people a seizure with that intro? lmao.

  • @dudunkoso5582
    @dudunkoso5582 4 роки тому

    This is so so helpful. I can’t thank you enough for taking the time to publish this video.

  • @fernandojosearaujodasilva1918
    @fernandojosearaujodasilva1918 4 роки тому

    You have done an excellent work. Clear and objective.

  • @cl7647
    @cl7647 4 роки тому

    Thank you so much for this! Really appreciate it!

  • @ashisranjanudgata5526
    @ashisranjanudgata5526 4 роки тому

    Ur video is very good. Can u make a detail video about the various features of Excel as per Geographical Weighted Regression

  • @kellyluanecorrea2719
    @kellyluanecorrea2719 4 роки тому

    Brilliant explanation. This is what I was looking to understand, thank you so much. Was wondering if you could assist on how to dummy code an income variable. Mydataset has income as a independent variable which when I use Solver, I get error message NUM!. I presume because the income figures are large? Would appreciate any help, Thanks.

  • @yulinliu850
    @yulinliu850 4 роки тому

    Thanks!

  • @juanjosezaballa5117
    @juanjosezaballa5117 4 роки тому

    I'm having problems with the instalation process. Excel gives me back a message saying something like "error 1004 Add property cannot be obtained". Any way of getting around it?

    • @edwardli9237
      @edwardli9237 4 роки тому

      Having the same issue, cannot download

    • @michaelpollock716
      @michaelpollock716 Рік тому

      @@edwardli9237 Excel has disabled macros and I can[t figure out how to allow macros

  • @nilajahrivers1109
    @nilajahrivers1109 4 роки тому

    Thank you. You really helped me. I really appreciate it Sr.

  • @saadiamazhar
    @saadiamazhar 4 роки тому

    Sir what about data in 100000s?

  • @ashokachoudhurybhattachary9137
    @ashokachoudhurybhattachary9137 4 роки тому

    Big thanks , great explanation

  • @yihaoliu8512
    @yihaoliu8512 4 роки тому

    It is very helpful! I had a hard time in finding the detailed lecture about the process of LCA. This is the best one.

  • @leonardocabrera9253
    @leonardocabrera9253 4 роки тому

    May you share the file?

  • @AhmedAhmed-gj4fr
    @AhmedAhmed-gj4fr 4 роки тому

    Hello, doest it work for excel 2016 on mac, pleas?

  • @zakariaabderrahmanesadelao3048
    @zakariaabderrahmanesadelao3048 5 років тому

    very clear explanation thank you professor.

  • @tomerweil
    @tomerweil 5 років тому

    Wow, big big thanks! You have helped me so much

  • @ggg-ox3hr
    @ggg-ox3hr 5 років тому

    Or you can learn python...

  • @fernandojackson7207
    @fernandojackson7207 5 років тому

    Mr Kamakura, I tried to download and was told that I don't have the right version of Excel. Can you suggest something please?

  • @fernandojackson7207
    @fernandojackson7207 5 років тому

    Excellent. How do we know the k-means converges and does not loop indefinitely?

  • @jeff6830
    @jeff6830 5 років тому

    Where did you get the data set?

  • @brunolevy4021
    @brunolevy4021 5 років тому

    hello am trying to use your tool for LCA on different type pf data and am systematically getting the message "at least one item has only one category"

  • @Ghosted760
    @Ghosted760 5 років тому

    Followed your instructions to the letter, but I keep getting a message from Excel that says the "macro has not been loaded".... help!

  • @LeninCortez8
    @LeninCortez8 5 років тому

    Thanks for the video, it was very helpful. Finally I could use the DEA Analysis

  • @rubemau
    @rubemau 6 років тому

    Professor, tudo bem? Gostei bastante do seu vídeo e da sua explicação. Uma coisa, de quem é relativamente leigo no assunto: não é necessário levar em consideração a autocorrelação espacial nesse tipo de modelo? Desde já, lhe agradeço!