True" hi. In this video, we are going to cover Module 1 x4 guidelines and rubric. So, as you can see, this particular exercise comes with a spreadsheet, a datasheet if you would. It's called the Superstore Excel workbook. So, I'm going to go ahead and download that workbook, which already downloads onto my laptop here and open up the workbook. There are a lot of varieties of sheets that we'll be using. So, for this Module 1, we're going to focus on the orders sheet. Let's go back here to Module 1 guidelines, and it says here we're going to focus on create a table to represent the mean, the median, and the mode for each attribute. The attributes they'd like you to do is the sales, quantity, discount, and profit. So, I'm going to go ahead and it wants you to put it on the descriptive stats worksheet. So, we're going to go ahead and click here and go into descriptive stats. I'm going to go ahead and create a let's see; I'm going to say sales, quantity, discount, profit Music Excel sheets, where if we want to do that. So, for sales, I'm going to click for the mean, the Excel formula is equal to average. I'm going to go back here to the orders sheet, and if you scroll to the right, you'll see the column R contains the sales for each of these orders. Okay, so as you can see, this sheet consists of all the orders, okay, um, and we'll score in here, right? You can see each row has a variety of variables, and one of them is the order. So, the order ID, order date, ship date, ship mode, etc. And again, scrolling to the right, you have each sale, if you...
Award-winning PDF software
Video instructions and help with filling out and completing Dd 1750
