Join Conrad Carlberg for an in-depth discussion in this video Analyze one factor by another in R, part of R for Excel Users.
- [Voiceover] One more bivariate analysis to go…and so far we've looked at a numeric by numeric analysis…out of which we got correlations.…And we've looked at a numeric by factor analysis…out of which we got breakdowns of means and medians…by the factor that we called for.…The third type remains is to analyze…one factor by another factor…and to get a contingency table from those.…And we can do that using the Desc function…by calling the Desc function and breaking down…the relationship between area and driver.…
Again from the same data frame of d.pizza.…So we hit Return and we get a chart of…contingency table, rather,…and if we come up to the beginning of the output,…then we get our inferential statistics…from the analysis.…A little bit of information regarding the number of cases…and how many rows and columns are in this table.…There are seven columns and three rows.…Seven columns because there are seven drivers…and three rows because there are three areas.…
The first set of inferential statistics…include the Pearson Chi-squared test,…
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