Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

R for Excel Users

via LinkedIn Learning

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Reviews

4.6 rating at LinkedIn Learning based on 68 ratings

Start your review of R for Excel Users

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.