From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Generate random data
From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Generate random data
- [Instructor] A lot of times, we need to generate a lot of fake data. We might want to do some training, or in this case, we're getting to know some new features in Excel. In this case, we've got movies and directors. We would like to generate a range of fake data that represent counts of one through four-star ratings. We could go through cell by cell and type in some data, but we are not going to do that. We're going to use RANDARRAY. Equals RANDARRAY, okay, double click here. Notice in that hint box, all of the components of this function are optional. In this case, we're going to use all of 'em. How many rows of fake data do we need? I know that we've got 11 movies, so I'm going to just type in 11, comma. How many columns? One, two, three, four. Comma, what is the minimum? We get to make this up. Let's say the minimum is going to be two, comma, and the max, 59. Comma, in this case we do want integers. It makes sense that we had nine one-star ratings, not 9.185. All right, so we…
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.