From the course: R for Excel Users
Join today to access over 24,900 courses taught by industry experts.
Overview of Excel's Analysis ToolPak and its static results - R Tutorial
From the course: R for Excel Users
Overview of Excel's Analysis ToolPak and its static results
- [Instructor] I'd like to give you a basis for a comparison of how Excel does some fairly standard analyses of a small data set, and how R supplies the same kinds of analyses. Here I have a list in columns A and B, what Excel terms a list. The list contains values in an informal kind of arrangement. In this case, list contains values from two different variables, height and weight. It's typical in a list to have different variables in different columns, and to have different records in different rows. So that's the way that this is set up. And the way that most people will go about getting statistics from this list is by way of worksheet functions. Now here I've entered the worksheet function called min and that returns, in this case, the minimum value in the range A2 to A21. And similarly in this cell, I have the average of those same values, 69.65. The good news about worksheet functions is that they're what's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.