How Do You Use Excel For Statistics?
“Microsoft Excel is a registered trademark of Microsoft Office products, and I am in no way, shape, or form affiliated with Microsoft Office or Microsoft. Okay, we’re going to learn how to use Excel, and we’re going to learn how to use Excel’s statistics, so I’m going to put in some false names and some quantities. Now mind you, this is just a very simple little thing. The next thing you want to do is you want to go to Tools, and you want to click on Data Analysis. This is going to bring up a data analysis wizard. You get to pick whichever data analysis tool you want to use. We use Rank and Percentile Analysis. Now it’s going to pull up; you want to actually pick which range you want to use, okay. And then Labels in the First Row and it’s gonna’ insert a new worksheet, and then you click OK. Now, if you look down here you’ll see a worksheet that’s called Rank, and you look at number three, or C3. That 99; its rank was first, it was a hundred percentile, whereas the last one was ranked
