From the course: Complete Guide to Excel Statistics with Copilot
Join today to access over 24,400 courses taught by industry experts.
Copilot: Continuous probability
From the course: Complete Guide to Excel Statistics with Copilot
Copilot: Continuous probability
- [Instructor] In this chapter, we looked at a number of different issues relating to continuous probabilities. So what we want to do here is take a look at, what are some of the things that Copilot can help us with related to the problems that we did in this chapter? So first thing that we're going to do is we're going to see whether or not it can find z-scores for us and then interpret those z-scores, such that we know where the player is from a height perspective on a normal distribution. So let's go and, first thing we need to do is turn this into a table. All right, and let's see what it does. All right, so here we go. It's telling us that it can create a new column that calculates the z-score for each player height. So we can copy this. And let's see if we can put it here. And there you go. There's the z-score. Now, what's really great about this is, had we not used Copilot in this particular situation, we would've had to first calculate the mean for our distribution and then…
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.
