R for Excel Users

Introduction

• Welcome
• Exercise files

1. Install R

• Download and install R's base package

2. Descriptive Statistics in Excel

• Excel's data analysis add-in
• Descriptive statistics in Excel

3. Working between R and Excel

• Install DescTools in R
• Moving Data from an Excel List to an R Data Frame
• Moving Data from an R Data Frame to an Excel List

4. Introduction to DescTools

• Control the numeric format of output in R
• Basic descriptive statistics in DescTools

5. DescTools Output

• Run the Desc function on numeric variables
• Run the Desc function on nominal variables

6. Bivariate Analysis in R

• Analyze one numeric variable by another in R
• Analyze a numeric variable against a factor in R
• Analyze one factor by another in R

7. Bivariate Analysis in Excel

• Analyze one numeric variable by another in Excel
• Analyze a numeric variable against a factor in Excel
• Analyze one factor by another in Excel

Conclusion

• Next Steps