Home
Videos uploaded by user “Jalayer Academy”
Excel - IFERROR function
 
03:56
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 170205 Jalayer Academy
Excel Pivot Table
 
09:07
Introduction to Pivot Tables in Excel. Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. Thanks
Views: 11367 Jalayer Academy
Excel - Macro Introduction  (lesson 1)
 
07:02
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 52412 Jalayer Academy
Excel - Plotting Multiple Lines on One Plot
 
04:54
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 225261 Jalayer Academy
Excel Nested IF function
 
09:45
In this tutorial we learn when it is appropriate to use a nested IF function and how to execute one. If you are not familiar with regular IF function check out my introduction to IF function video linked here http://www.youtube.com/watch?v=mr1EbBMksio
Views: 415417 Jalayer Academy
Excel - Basic Descriptive Statistics (Mean, Variance, Standard Devation, etc.)
 
06:27
This video shows how to get basic descriptive statistics from a single sample in excel. Various useful function are shown and explained clearly and simply. Please check out my other Excel tutorials.
Views: 25897 Jalayer Academy
Google Sheets - SumIF, CountIF, AverageIF
 
05:02
countif, sumif, averageif functions in Google Sheets
Views: 53576 Jalayer Academy
Excel IF function
 
07:33
This is a tutorial in Excel's If function. It is one of the most used and useful logical functions in Excel and is usually the starting place and basis for more advance logical functions. Be sure to check out my Vlookup tutorial, which has gotten great reviews from students on the web. http://www.youtube.com/watch?v=CtHJrjW31cA&feature=plcp&context=C340a648UDOEgsToPDskK48QgjzwPXc9MPYF6KNGLs
Views: 556407 Jalayer Academy
Excel - Index function
 
06:47
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 164839 Jalayer Academy
Excel - One-Way ANOVA      Analysis Toolpack
 
14:10
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. Technically you should say Fail to Reject Ho because you have determined there is a lack of evidence against Ho. You have not proven Ho in any significant way. With that said, many introductory courses teach students that they can conclude that we Accept Ho. Please be aware of the nuance regardless of how you choose to phrase the conclusion. Reject Ho, however, is a stronger statement that we can justifiably make using the laws of probability and the level of significance of the test. When we Reject Ho we are concluding that there is enough evidence against Ho with the state level of significance used. We are willing to accept the chance of making a Type I Error, but we are very clear about the probability of its occurrence, i.e., it is equal to alpha (at least nominally).
Views: 232429 Jalayer Academy
Excel - Macro Introduction  (lesson 2)
 
02:50
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 18401 Jalayer Academy
Excel - Time Series Forecasting - Part 1 of 3
 
18:06
Part 2: http://www.youtube.com/watch?v=5C012eMSeIU&feature=youtu.be Part 3: http://www.youtube.com/watch?v=kcfiu-f88JQ&feature=youtu.be This is Part 1 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Parts 2 and 3 upon completing Part 1. The links for 2 and 3 are in the video as well as above.
Views: 743944 Jalayer Academy
Excel - Simple Linear Regression
 
07:56
Simple Linear Regression using Microsoft Excel
Views: 209713 Jalayer Academy
Excel Histogram - statistics
 
09:29
This tutorial takes you from A to Z on how to create a histogram in Excel. For other Excel statistics tutorials check out my channel.
Views: 180392 Jalayer Academy
Multiple Regression in Excel
 
11:02
Multiple Regression in Excel in a nutshell. Focusing on Excel functionality more than presentation of regression theory.
Views: 56025 Jalayer Academy
Text Mining (part 1)  -  Import Text into R (single document)
 
06:46
Text Mining with R. Import a single document into R.
Views: 13807 Jalayer Academy
Access - Query Sort
 
03:13
Many more great Excel and Access tutorials linked below: http://www.youtube.com/rdjalayer Be sure to Subscribe so that you get access to new Excel and Access tutorial videos when they are released, including more advanced techniques and many useful and practical ones. Thanks for watching!
Views: 11064 Jalayer Academy
R - Twitter Mining with R (part 1)
 
11:39
Twitter Mining with R part 1 takes you through setting up a connection with Twitter. This requires a couple packages you will need to install, and creating a Twitter application, which needs to be authorized in R before you can access tweets. We quickly go through this entire process which may take some flexibility on your part so be patient and be ready troubleshoot as details change with updates. Warning: You are going to face challenges setting up the twitter API connection. The steps for this part have been known to change slightly over time for a variety of reasons. Follow the general steps and expect a few errors along the way which you will have to troubleshoot. It is hard to solve these issues remotely from where I am.
Views: 62234 Jalayer Academy
Excel - Vlookup Array function
 
05:23
Using vlookup in an array.
Views: 12515 Jalayer Academy
Excel Filter Tutorial
 
07:06
This video introduces the filtering functionality in Microsoft Excel. Be sure to watch the more advanced filtering videos on my channel if you wish to continue learning about filters.
Views: 218002 Jalayer Academy
Excel - Time Series Forecasting - Part 2 of 3
 
15:01
Part 1: http://www.youtube.com/watch?v=gHdYEZA50KE&feature=youtu.be Part 3: http://www.youtube.com/watch?v=kcfiu-f88JQ&feature=youtu.be This is Part 2 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Part 1 before watching this part and Part 3 upon completing Part 1 and 2. The links for 1 and 3 are in the video as well as above.
Views: 301287 Jalayer Academy
Tukey Kramer Multiple Comparison Procedure and ANOVA with Excel
 
17:44
This procedure is done after Rejecting the Null Hypothesis in a One-Way ANOVA F-test. The Studentized Range table that will give you the Qu value in the video can be found at the link below: http://cse.niaes.affrc.go.jp/miwa/probcalc/s-range/srng_tbl.html I used alpha = 0.05
Views: 79783 Jalayer Academy
R - Polynomial Regression
 
05:21
Check out more R tutorials on Jalayer Academy: https://www.youtube.com/playlist?list=PL7E00524A580CFCA1
Views: 28354 Jalayer Academy
Excel Nested AND function
 
08:06
This video shows how and why to Nest an AND function inside an IF function in Excel. If you are new to IF functions or AND functions I have made a video that introduces the basics of each linked here: http://www.youtube.com/watch?v=mr1EbBMksio I have also made a Nested OR function video linked here: http://www.youtube.com/watch?v=Mz-XxgpCttc
Views: 21534 Jalayer Academy
R - Histogram by Factor Variable  (lesson 2)
 
03:44
Many more R, Excel, Access, Math, Stats, and more tutorials linked below: www.youtube.com/rdjalayer Subscribe and click on ads to keep this series of R videos alive and growing
Views: 12607 Jalayer Academy
Excel - Polynomial Quadratic Regression
 
07:15
Polynomial Regression / Quadratic Regression
Views: 41982 Jalayer Academy
Basic Skills in Excel
 
05:21
This video covers navigating and comfortably moving around in Excel, which I have found many of my students need help in. Oftentimes students are taught to use intermediate and advanced functions in Excel and have yet to get comfortable with the extremely useful basic navigation techniques. Be sure to check out my other Excel videos.
Views: 11536 Jalayer Academy
Excel AND function - beginner
 
05:27
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 41246 Jalayer Academy
Excel Advanced Filter - part (1 of 2)
 
10:57
Part 2: http://www.youtube.com/watch?v=wMddq7yn9BI This tutorial video is part 1 of a two part lesson on using Advanced Filters in excel. Advanced filtering is extremely useful when you need to find pertinent information in piles of data. Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 169266 Jalayer Academy
Excel - sumIF , countIF , averageIF functions
 
06:59
This video goes through an example which shows you a practical use of the sumif, countif, and averageif functions in Microsoft Excel. Be sure to check my other Excel tutorial videos on my channel.
Views: 17849 Jalayer Academy
Vlookup Excel Best
 
10:50
Vlookup Function http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp This video is an introduction to the Vlookup function in Excel. Be sure to watch my other Excel tutorial videos on my channel (LINKED ABOVE), including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. Thanks
Views: 1943628 Jalayer Academy
Excel Advanced Filter - part (2 of 2)
 
06:04
if you missed Part 1: http://www.youtube.com/watch?v=UC1jb-Aqpfw This tutorial video is part 1 of a two part lesson on using Advanced Filters in excel. Advanced filtering is extremely useful when you need to find pertinent information in piles of data. Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 45283 Jalayer Academy
kNN Machine Learning Algorithm - Excel
 
26:51
kNN, k Nearest Neighbors Machine Learning Algorithm tutorial. Follow this link for an entire Intro course on Machine Learning using R, did I mention it's FREE: https://www.youtube.com/playlist?list=PLjPbBibKHH18I0mDb_H4uP3egypHIsvMn Also, be sure to check out my channel for over 300 tutorials on Excel, R, Statistics, basic Math, and more.
Views: 56368 Jalayer Academy
R - kNN - k nearest neighbor (part 1)
 
14:50
In this module we introduce the kNN k nearest neighbor model in R using the famous iris data set. We also introduce random number generation, splitting the data set into training data and test data, and Normalizing our numerical features (a form of rescaling necessary for certain learning algorithms).
Views: 84173 Jalayer Academy
R - tapply function
 
04:04
Many more R, Excel, Access, Math, Stats, and more tutorials linked below: www.youtube.com/rdjalayer Subscribe and click on ads to keep this series of R videos alive and growing
Views: 12570 Jalayer Academy
R - Simple Linear Regression (part 1)
 
08:25
When we have one numeric dependent variable (target) and one independent variable where a scatterplot shows a linear pattern we can employ simple linear regression (SLR) from the Regression family of techniques.
Views: 22397 Jalayer Academy
Excel Statistics Variance
 
07:17
Other great Statistics videos: http://www.youtube.com/watch?v=-tFWH7AYLek http://www.youtube.com/watch?v=B7HTX_4rgtA This video takes you through the calculation of Variance step by step. It also introduces Excel functions for doing it in one fast step.
Views: 25526 Jalayer Academy
PowerPoint - embed Excel     spreadsheet into Slides
 
08:02
Be sure to watch my other tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. PowerPoint video tutorials: http://www.youtube.com/playlist?list=PL8C4DCBE7F11C0DF2&feature=plcp
Views: 132502 Jalayer Academy
Text Mining (part 5) -  Import a Corpus in R
 
11:26
Import multiple text documents and create a Corpus.
Views: 8197 Jalayer Academy
Excel - Copy and Clone entire Worksheet
 
05:29
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 138747 Jalayer Academy
R  - Regression Trees - CART
 
18:24
Regression Trees are part of the CART family of techniques for prediction of a numerical target feature. Here we use the package rpart, with its CART algorithms, in R to learn a regression tree model on the msleep' data set available in the ggplot2 package.
Views: 32749 Jalayer Academy
Access Basic Skills - Beginning
 
02:15
Many more great Excel and Access tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 8328 Jalayer Academy
Cronbach's Alpha - Excel
 
13:50
Cronbach's alpha is a measure that assesses the internal consistency, of a set of scale or test items.
Views: 8738 Jalayer Academy
Excel - Time Series Forecasting - Part 3 of 3
 
17:03
Part 1: http://www.youtube.com/watch?v=gHdYEZA50KE&feature=youtu.be Part 2: http://www.youtube.com/watch?v=5C012eMSeIU&feature=youtu.be This is Part 3 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Part 1 and 2 before watching this part. The links for Parts 1 and 2 are in the video as well as above.
Views: 263478 Jalayer Academy
Access - PivotChart  (lesson 1)
 
05:05
Many more great Excel and Access tutorials linked below: http://www.youtube.com/rdjalayer Be sure to Subscribe so that you get access to new Excel and Access tutorial videos when they are released, including more advanced techniques and many useful and practical ones. Thanks for watching!
Views: 8451 Jalayer Academy
Text Mining (part4)  -  Postive and Negative Terms for Sentiment Analysis in R
 
06:27
Find the terms here: http://ptrckprry.com/course/ssd/data/positive-words.txt http://ptrckprry.com/course/ssd/data/negative-words.txt
Views: 8478 Jalayer Academy
R - kNN - k nearest neighbor (part 2)
 
13:00
In this module we introduce the kNN k nearest neighbor model in R using the famous iris data set. We also introduce random number generation, splitting the data set into training data and test data, and Normalizing our numerical features (a form of rescaling necessary for certain learning algorithms).
Views: 42188 Jalayer Academy
Excel - Match Function   (lesson #2)
 
10:26
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment.
Views: 35517 Jalayer Academy
R - LOWESS smoothing curve
 
11:13
LOESS and LOWESS (locally weighted scatterplot smoothing) are two strongly related non-parametric regression methods that combine multiple regression models in a k-nearest-neighbor-based meta-model.
Views: 15177 Jalayer Academy