R for Excel Users

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.

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