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

Passion Driven Statistics
Wesleyan University via Coursera
Introduction to Statistics: Descriptive Statistics
University of California, Berkeley via edX
Statistics in Medicine
Stanford University via Stanford OpenEdx
Estadística para investigadores: Todo lo que siempre quiso saber
Universidad de Salamanca via Miríadax
Estadística descriptiva
Universidad Politécnica de Cartagena via Miríadax