Business Analytics: Multiple Comparisons in R and Excel

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Statistical Analysis Courses

Course Description

Overview

Learn how to run multiple comparison tests in Excel and R to pinpoint mean differences in multiple groups of data.

Syllabus

Introduction

Pinpoint group mean differences
Getting started

1. Tukey Multiple Comparisons Test

Tukey honestly significant difference (HSD): Overview
Tukey: Preliminary tests in Excel
Tukey: Test of mean differences in Excel
Tukey: Preliminary tests in R
Tukey: Test of mean differences in R
Tukey: Choice of error rates

2. Scheffé Multiple Comparisons Test

Scheffé: Overview
Scheffé: Preliminary tests in Excel
Scheffé: Contrasts in Excel
Scheffé: Calculating Psi
Scheffé: Test of mean differences in R
Scheffé: Critical values and confidence intervals

Conclusion

Next steps

Taught by

Conrad Carlberg

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard