Видео

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.

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.

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.

This video looks at using Excel to conduct Two-Sample t and z tests for means.

In this video we look at using Excel to solve two-sample tests for proportions.

In this video we look at using the ANOVA-Template.xlsx file to perform a Friedman's test.

This video looks at using the ANOVA-Template.xlsx file to conduct a Kruskal-Wallis test.

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.

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.

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.

In this video we look at some of the common errors and issues that must be dealt with in cleaning the data for analysis.

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.

In this video we look at how to set up the dataset, from a Stats survey, and put it into Excel.

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.

BUS 307 T4 - T10 (W21)

BUS 307 T1 - T4 (W21)

BUS 307 A10 - A12 (W21)

BUs 307 A18 - A33 (W21)

BUS 307 A13 - A17 (W21)

BUS 307 A8 - A9 (W21)

BUS 307 A7 - A8 (W21)

BUS 307 A4 - A6 (W21)

BUS 307 A1 - A3 (W21)

BUS 307 I8 - I17 (W21)

BUS 307 I1 - I7 (W21)

BUS 307 V7 - V12 (W21)

BUS 307 V4 - V7 (W21)

BUS 307 V1 - V3 (W21)

BUS 307 D17 - D30 (W21)