Join Conrad Carlberg for an in-depth discussion in this video Move data from R to Excel, part of R for Excel Users.
- [Voiceover] In the prior lesson…we took a look at a function called XLGetRange,…by which you're able to import data…from Excel directly into R.…We'll take a look at a companion functionality…in this lesson which is called XLView,…and it just reverses the process,…instead of importing from Excel into R,…we'll use it to export from R into Excel.…And the XLView function is part of the…R DCOM client package that we downloaded previously,…but we can get at that, by running library on DescTools,…so we'll start out with that.…
And, the DescTools package includes, inside of it,…a data frame called d.pizza,…which is a fictitious database saved by a company…that is in the business of delivering pizzas,…we'll take a look at it in Excel in just a moment here,…but in as much as it's part of DescTools,…we can run the XLView function directly on it,…and I'll just type that in.…The name of the data frame is d.pizza, and Return,…and all of the data is now exported into Excel,…actually a semicolon separated values format,…and we can get that into columns,…
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