Join Conrad Carlberg for an in-depth discussion in this video Descriptive statistics in Excel, part of R for Excel Users.
- [Voiceover] Let's take a closer look…at the distributional information…that you can get back from the Excel Data Analysis Add-In,…in particular, the Descriptive Statistics Tool.…The data that you see here in the worksheet,…is the Pizza Dataframe from R,…that I exported into Excel using…the Desk Tools Command Excel View,…and what I'd like to do,…is analyze delivery minutes,…so what we'll do is,…we'll go to the Data Tab in Excel,…and click the Data Analysis Link over here…in the Analysis Group.…
And choose Descriptive Statistics, and click Okay,…and it is coming back fortunately,…with the selections that we'd wanna make,…we want to choose K1 through K1210,…to get the delivery minutes.…It's grouped by columns,…so each, each variable occupies a different column.…There is a label in the first row, Delivery Minutes.…We'd like the output range to start in cell R1.…We want the Summary Statistics.…We want the Confidence Interval for the mean,…and I've asked for the fifth largest and the fifth…smallest values in the Delivery Minutes Variable…
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