YoVDO

R for Excel Users

Offered By: LinkedIn Learning

Tags

Statistics & Probability Courses Data Analysis Courses Data Visualization Courses Descriptive Statistics Courses

Course Description

Overview

Update your data science skills by learning R. Learn how data analysis and statistics operations are run in Excel versus R and how to move data back and forth between each program.

Syllabus

Introduction
  • R and Excel: Data analysis done the right way
1. Install R on Your Computer
  • Installing R
2. Descriptive Statistics in Excel
  • Overview of Excel's Analysis ToolPak and its static results
3. Working between R and Excel
  • Installing DescTools
  • Moving data from Excel to R
  • Moving data from R to Excel
4. DescTools Univariate Analyses
  • Distributional information
5. Desc Output
  • Charts from Desc
  • Factor plots from Desc
6. Bivariate Analysis in DescTools
  • Bivariate analyses from Desc
  • Means by factor from Desc
  • Contingency tables from Desc
7. Bivariate Analysis in Excel
  • Numeric by numeric from Excel
  • Numeric by factor from Excel
  • Contingency table from Excel
Conclusion
  • Next steps

Taught by

Conrad Carlberg

Related Courses

Introduction to Artificial Intelligence
Stanford University via Udacity
Probabilistic Graphical Models 1: Representation
Stanford University via Coursera
Statistics One
Princeton University via Coursera
Intro to Statistics
Stanford University via Udacity
Passion Driven Statistics
Wesleyan University via Coursera