Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
R for Excel Users

R for Excel Users

1h 15mIntermediate2023-07-26

Authors

Conrad Carlberg

Conrad Carlberg

Writer and Consultant in Quantitative and Statistical Analysis

Course details

Data scientists who use Excel realize that R is emerging as the new standard for statistical wrangling (especially for larger data sets). This course serves as the perfect bridge for the many Excel-reliant data analysts and business users who need to update their data science skills by learning R. Much of the course focuses on how crucial statistical tasks and operations are done in R—often with the DescTools package—as contrasted with Excel functions and Data Analysis add-in, and then scales up from there, showing the more powerful features of R. Conrad Carlberg helps you effectively toggle between both programs, moving data back and forth so you can get the best of both worlds. Learn about calculating descriptive statistics, running bivariate analyses, and more.

Skills covered

RStatisticsSpreadsheetsProgramming LanguagesData ScienceBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

  • 01 - R and Excel - Data analysis done the right way

1. Install R on Your Computer

  • 02 - Installing R

2. Descriptive Statistics in Excel

  • 03 - Overview of Excel's Analysis ToolPak and its static results

3. Working between R and Excel

  • 04 - Installing DescTools
  • 05 - Moving data from Excel to R
  • 06 - Moving data from R to Excel

4. DescTools Univariate Analyses

  • 07 - Distributional information

5. Desc Output

  • 08 - Charts from Desc
  • 09 - Factor plots from Desc

6. Bivariate Analysis in DescTools

  • 10 - Bivariate analyses from Desc
  • 11 - Means by factor from Desc
  • 12 - Contingency tables from Desc

7. Bivariate Analysis in Excel

  • 13 - Numeric by numeric from Excel
  • 14 - Numeric by factor from Excel
  • 15 - Contingency table from Excel

Conclusion

  • 16 - Next steps

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
Zarinpal
Zibal