- Видео 122
- Просмотров 78 312
Doug MacDormand
Добавлен 23 сен 2018
This channel contains video lessons for the BUS 306 and BUS 307 Business Stats courses at RDC.
Stepwise Regression Using Excel
This mini-lesson shows how you can do a backwards stepwise regression using Excel.
Просмотров: 31 467
Видео
Check-all-that-apply Questions
Просмотров 4,8 тыс.3 года назад
In this video we take a look at how to handle Check-all-that-apply questions. Specifically, if an electronic form is used to gather data, the results, for each respondent, may come as a long line of text, with commas separating each of the options that they checked. We will look at how to break them into separate columns as well as how to convert them into values that will make analyses easier.
Test of Independence using Test of Independence-Template.xlsx
Просмотров 2043 года назад
This video looks at using the Test of Independence-Template.xlsx file for analyzing tests of questions of relationship between two nominal variables. It will also be useful for showing you how to write up your analysis of a question to go in the appendix of your report.
Correlation and SLR using the Template file
Просмотров 1123 года назад
This video looks at using the Correlation and SLR - Template.xlsx file for analyzing the relationship between two interval variables, one interval and one ordinal variable, and two ordinal variables.
Two-Sample Tests of Means using Excel
Просмотров 2013 года назад
This video looks at using Excel to conduct Two-Sample t and z tests for means.
Two-Sample Test of Proportions using Excel
Просмотров 1213 года назад
In this video we look at using Excel to solve two-sample tests for proportions.
Friedman's Test using ANOVA Template File
Просмотров 1563 года назад
In this video we look at using the ANOVA-Template.xlsx file to perform a Friedman's test.
Kruskal-Wallis Using ANOVA Template File
Просмотров 2093 года назад
This video looks at using the ANOVA-Template.xlsx file to conduct a Kruskal-Wallis test.
ANOVA using Excel's Analysis Toolpak and the ANOVA-Template.xlsx File
Просмотров 5093 года назад
In this video we look at how to use Excel's ANOVA: Single Factor tool, from the Analysis Toolpak, to conduct a one-way ANOVA test. We also look at using the ANOVA-Template.xlsx file to perform a one-way ANOVA test. This will also test for normality and homogeneity of variances, resulting in a Kruskal-Wallis test, if conditions fail.
Data Cleaning - Part 5 - Special Question Types
Просмотров 1043 года назад
In this last video we look at some of the issues involved with special question types, including branching questions, check all that apply questions, ranking questions, and open ended questions.
Data Cleaning - Part 4 - Errors and Issues 2
Просмотров 813 года назад
In this video we continue looking how to correct some of the errors and issues in the creation of a dataset from a Stats survey.
Data Cleaning - Part 3 - Errors and Issues 1
Просмотров 1373 года назад
In this video we look at some of the common errors and issues that must be dealt with in cleaning the data for analysis.
Data Cleaning - Part 2 - Useful Tools
Просмотров 1543 года назад
In this video we look at using common stats functions and procedures for checking the range and validity of data in a created dataset from a survey.
Data Cleaning - Part 1 - Setup
Просмотров 3663 года назад
In this video we look at how to set up the dataset, from a Stats survey, and put it into Excel.
BUS 307 T10 - T14 (W21)
Просмотров 1843 года назад
This video looks at the two-sample test of proportions, from pages T10 to T14 of Unit T (Two-Sample Tests) from the BUS 307 manual.