- Видео 13
- Просмотров 118 444
ExcelStatistics
США
Добавлен 23 май 2016
This channel is a combination of Excel and Statistics Tutorials. Videos will be short and sweet to focus on a particular area. Use the playlists to work all the way through a given area.
Statistics VIII - Time Series Forecasting
Learn to do some basic Time Series Forecasting using Excel.
Просмотров: 12 191
Видео
Statistics VIII - Multiple Correlation and Regression
Просмотров 78 тыс.7 лет назад
Learn how to complete multiple correlation and multiple regression utilizing Excel.
Statistics VII - Correlation and Simple Regression
Просмотров 7587 лет назад
Using Excel to calculate correlation and conduct a Simple Linear Regression
Statistics VI - Three Group Hypothesis Testing
Просмотров 9 тыс.7 лет назад
Utilizing Excel to perform 3hree or more group hypothesis testing with ANOVA.
Statistics V - Two Group Hypothesis Testing
Просмотров 6187 лет назад
Utilizing Excel to perform a t-Test on 2 groups of data
Statistics IV - Single Group Hypothesis Testing
Просмотров 3837 лет назад
Use confidence interval to perform hypothesis testing with a single group of data.
Statistics III - Poisson Distribution
Просмотров 13 тыс.7 лет назад
Using Excel to calculate basic probabilities for the Poisson Distribution
Statistics III - Normal Distribution
Просмотров 3367 лет назад
Using Excel to calculate basic probabilities for the Normal Distribution
Statistics III - Binomial Distribution
Просмотров 4747 лет назад
Using Excel to calculate values in the Binomial Distribution
Statistics I - Descriptive Statistics
Просмотров 3977 лет назад
A brief tutorial of how to make use of the Descriptive Statistics function the MS Excel Data Analysis ToolPak. This video was recorded with Excel 2016, but works the same for all version 2007 and newer.
Statistics I - Data Analysis ToolPak
Просмотров 5517 лет назад
Instructions on how to install/activate the Data Analysis ToolPak in MS Excel. Example is done on Excel 2016, but works the same for 2007 and newer.
Basic Excel 1 - Parts of a Spreadsheet
Просмотров 2,7 тыс.8 лет назад
In Parts of a Spreadsheet will discuss the basic layout of Excel such as row and column references, sheets, zooming, and ribbon navigation.
why is "input range contains non-numeric data" shown? is there a way to fix this.. please help
not audible
THANK YOU THANK YOU SO MUCH!!! I HAVE BEEN STOCK ON MY STATISTICS ASSIGNMENT FOR AGES NOW AND YOUR VIDEO JUST HELPED ME GET IT DONE!! THANK YOUUU!!
How to do regression for camel analysis for 5 banks pls reply
noice
Is it possible to graph the regression?
Hi can you teach me
What
Very helpful. You explained it easily.
Thank you for the suggestions! One question: in here you're just comparing how well the 3 methods fit historical data. How how you know that the best historical fit is the best prediction? Also, how do you create a plateau effect?
Can't understand why your videos have so little traffic. Relevant and useful content !
Hello. I want to let you know that you did a mistake doing a regression calculus because you can't multiply years with population, they are two totaly different things - years are as a date and population is just a numeric data. If I'm thinking wrong please let me know.
You are incorrect. They are X & Y variables in the regression (year and population). The Year Coefficient multiplies times the year to estimate the population. By this estimate, the population grows 3.1 million per year. Mathematically speaking it is irrelevant what the labels are for the data.
@@excelstatistics358 thank you for letting me know how it is!
The p-values of all 3 independant variables in the regression model are greater than 0,05 means these independant viariables are not significant. If the null hypothesis is - there is no correlation between 3 variables and GPA, p-value says we cannot reject the null hypothesis. How do you explain that ?
Great video! Very helpful!
Hi, Can u plz share a video to describe Normal Dist of given two data series (say 2000+ data each) and compare both them in in single graph.