- 18
- 148 353
KamakuraAnalyticTools
United States
Приєднався 13 сер 2018
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
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
How to install KATE (Kamakura's Analytic Tools for Excel)
Переглядів 4,1 тис.6 років тому
How to install KATE (Kamakura's Analytic Tools for Excel)
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?
MS 365 Excel has disabled macros and I can't figure out how to allow macros.
Thanks
Thanks ,help a lot
Nice
hi sir, kindly share the link to download the data.
is Logit Coeficiens same with 'coefficient' in linear regression? But how do we know if the predictors are actually gave proper 'r' ?
Hello Mr Kamakura, I wanted to ask do you do lessons as a private tutor for Excel?
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
Time stamps @00:00 - Introduction @00:18 - KMeans Clustering @01:25 - Limitations of KMeans Clustering @02:27 - Latent Class Analysis
How to draw 3d tetrahedron shape in excel chart
THANK YOU SIRE FOR THIS GREAT TUTORIAL
Shouldn't the 'IF' condition for calculating likelihood equate to something? e.g. if(B4=1, L4, (1-L4))
It's the same thing. You can leave it as If(B4,x,y) and it assumes If(B4=1).
Thanks. Great Work Done !
@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?
Perfect and good video tutorials for learners, Thank you very much.
Dear Teacher, I would like to have this excel file of Logistics Regression, can you give me? please, thank you very much
Ah, I see, KATE won't work on Apply/ Macbook
Dear Teacher, I use Macbook, may I know if Macbook can install KATE?
Dear Teacher, may I have excel file? I would like to learn details of formulas, thank you very much
Thank you very much, great lesson
Wonderful tool in Excel!
were you trying to give people a seizure with that intro? lmao.
This is so so helpful. I can’t thank you enough for taking the time to publish this video.
You have done an excellent work. Clear and objective.
Thank you so much for this! Really appreciate it!
Ur video is very good. Can u make a detail video about the various features of Excel as per Geographical Weighted Regression
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.
Thanks!
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?
Having the same issue, cannot download
@@edwardli9237 Excel has disabled macros and I can[t figure out how to allow macros
Thank you. You really helped me. I really appreciate it Sr.
Sir what about data in 100000s?
use the program R
Big thanks , great explanation
It is very helpful! I had a hard time in finding the detailed lecture about the process of LCA. This is the best one.
May you share the file?
Hello, doest it work for excel 2016 on mac, pleas?
very clear explanation thank you professor.
Wow, big big thanks! You have helped me so much
can you pls explain the last inference
Or you can learn python...
How would python help me exactly?
Mr Kamakura, I tried to download and was told that I don't have the right version of Excel. Can you suggest something please?
Excellent. How do we know the k-means converges and does not loop indefinitely?
Where did you get the data set?
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"
Followed your instructions to the letter, but I keep getting a message from Excel that says the "macro has not been loaded".... help!
Thanks for the video, it was very helpful. Finally I could use the DEA Analysis
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!