Join Conrad Carlberg for an in-depth discussion in this video Analyze one factor by another in Excel, part of R for Excel Users.
- [Voiceover] Finally let's take a look at…assembling the contingency table…from two factors in the pizza dataframe…both in R and in Excel.…For comparative purposes,…we'll call the desc function…and we'll specify area and we'll make it contingent…on driver…and we'll specify that the dataframe to use is…d.pizza and hit Return.…Let me scroll up a little bit here…so that we can see all of the results.…
Again, we've got the inferential tests here.…Pearson, Likelihood and Mantel-Haenszel…and the measures of the strength of association…Phi-Coefficient, Contingency and Cramer's V…and then we get down here to the contingency table itself…with drivers across the top…and areas down the side.…So that's quick and easy.…To get it in Excel,…it's going to take a little bit more work…but here is the pizza dataframe…in the Excel platform…and we'll again use a pivot table…to create the contingency table.…
So come over to the Insert tab…and having selected already a cell…that's inside the raw data area,…I click Pivot Table.…It gives me the range…
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's functions and Data Analysis add-in, and then scales up from there, showing R's more powerful features. Conrad Carlberg will help you effectively toggle between both programs, moving data back and forth so you can get the best of both worlds. Start by learning how to install R and the DescTools package, and the data files used in all the hands-on exercises. Then learn about calculating descriptive statistics on numeric and nominal variables, and running bivariate analyses in both Excel and R. In the "Next steps" video, Conrad breaks down the pros and cons of Excel vs. R and provides tips for learning more about statistics in each application.
- Installing R and DescTools
- Descriptive statistics in Excel and DescTools
- Moving data between R and Excel
- Running the Desc function
- Bivariate analysis in R and Excel