1 00:00:00,266 --> 00:00:03,266 2 00:00:03,266 --> 00:00:09,599 Hello, and welcome to a video on creating new variables in Excel. Creating variables 3 00:00:09,600 --> 00:00:09,633 4 00:00:09,633 --> 00:00:15,533 in Excel is pretty simple. You just need to know a couple of things about how Excel works and then you should be good to go. 5 00:00:15,533 --> 00:00:17,466 6 00:00:17,466 --> 00:00:23,466 First things first, if you've never used Excel before, this is called a cell. This is a cell, this is 7 00:00:23,466 --> 00:00:29,232 a cell, and this is also a cell. All of these cells have names. This cell is 8 00:00:29,233 --> 00:00:30,133 9 00:00:30,133 --> 00:00:36,233 D1, and you can see it's name right here. This cell is J10. This one is 10 00:00:36,233 --> 00:00:41,766 G10, and you can see that it makes sense because they line up with their 11 00:00:41,766 --> 00:00:42,466 12 00:00:42,466 --> 00:00:48,532 two portions of their name. Let's make 13 00:00:48,533 --> 00:00:48,566 14 00:00:48,566 --> 00:00:54,499 a new variable called ID. And in this case, I want to say that ID is equal to the 15 00:00:54,500 --> 00:00:54,800 16 00:00:54,800 --> 00:01:01,133 quantity 18 times 6 divided by 2. So 18 times 6 17 00:01:01,133 --> 00:01:07,266 all over 2 and we'll hit enter. And I'm using the equal sign here to let Excel know that I'm doing 18 00:01:07,266 --> 00:01:13,332 a math problem. And then I want it to do some math for me. Okay, so it's 19 00:01:13,333 --> 00:01:13,366 20 00:01:13,366 --> 00:01:19,499 equal to 54. I'm going to double-click on the side of this box, and it will automatically 21 00:01:19,500 --> 00:01:25,166 populate 54 all the way down to our final variable. 22 00:01:25,166 --> 00:01:25,799 23 00:01:25,800 --> 00:01:32,033 If you don't want to double-click or you have a hard time double-clicking, you can also drag the edge of this box 24 00:01:32,033 --> 00:01:32,066 25 00:01:32,066 --> 00:01:37,932 down, and it will also populate it with 54. Just make sure you go all the way down to the end of your 26 00:01:37,933 --> 00:01:38,233 27 00:01:38,233 --> 00:01:43,733 numbers. Let's make another new variable, and we'll call it IV-3. 28 00:01:43,733 --> 00:01:44,433 29 00:01:44,433 --> 00:01:50,066 And in this case, when we say equals, we want to say equals 30 00:01:50,066 --> 00:01:50,499 31 00:01:50,500 --> 00:01:54,900 IV-1 times IV-2. 32 00:01:54,900 --> 00:01:56,700 33 00:01:56,700 --> 00:02:02,466 And we'll say that's equal to IV-3. So let's hit enter, and we get quite a big number, 34 00:02:02,466 --> 00:02:03,732 35 00:02:03,733 --> 00:02:08,199 and I'm going to go ahead and drag it down this time. Instead of double-clicking so you can see the difference. 36 00:02:08,200 --> 00:02:15,266 37 00:02:15,266 --> 00:02:22,432 Okay, what it's done is take each of these numbers, so 80 times 88.5, 38 00:02:22,433 --> 00:02:22,466 39 00:02:22,466 --> 00:02:27,766 the 7080, 78 times 93, is 7254, 80 40 00:02:27,766 --> 00:02:28,966 41 00:02:28,966 --> 00:02:32,432 times 80 is 6400, and so on and so forth. 42 00:02:32,433 --> 00:02:35,033 43 00:02:35,033 --> 00:02:41,199 A useful thing about Excel is that we can click in this box here, and we can see what our numbers 44 00:02:41,200 --> 00:02:41,233 45 00:02:41,233 --> 00:02:47,399 are that we're multiplying together. So if you're ever looking at your formula up here, and you're unsure if you've got 46 00:02:47,400 --> 00:02:53,466 the right cell numbers in your formula, you can just click and have 47 00:02:53,466 --> 00:02:53,499 48 00:02:53,500 --> 00:02:59,633 a visual outline for what you have there. Okay, let's 49 00:02:59,633 --> 00:03:05,299 make one more variable, we'll call it 50 00:03:05,300 --> 00:03:05,766 51 00:03:05,766 --> 00:03:11,899 IV4. And this time IV4 will be equals 52 00:03:11,900 --> 00:03:13,266 53 00:03:13,266 --> 00:03:16,499 IV2 divided by IV. 54 00:03:16,500 --> 00:03:20,033 55 00:03:20,033 --> 00:03:26,266 Okay, then I'll hit enter, so V2 divided by C2. This forward 56 00:03:26,266 --> 00:03:32,399 slash symbol is the division symbol in Excel. Okay, 57 00:03:32,400 --> 00:03:32,866 58 00:03:32,866 --> 00:03:38,899 and I double-click that to populate it the whole way down. So now we have all of our numbers made. This is a whole 59 00:03:38,900 --> 00:03:38,933 60 00:03:38,933 --> 00:03:42,966 lot of math that we did not have to do. Excel did it for us. 61 00:03:42,966 --> 00:03:45,466 62 00:03:45,466 --> 00:03:51,932 All right, since we're here, I'll go ahead and show you another couple of tricks you can do with Excel. First things first, 63 00:03:51,933 --> 00:03:52,399 64 00:03:52,400 --> 00:03:58,833 let's talk about summing. So we can use the equals sum function 65 00:03:58,833 --> 00:03:59,066 66 00:03:59,066 --> 00:04:05,066 and open a parentheses. Select all of the numbers that we wanted to add up for 67 00:04:05,066 --> 00:04:05,099 68 00:04:05,100 --> 00:04:05,566 us. 69 00:04:05,566 --> 00:04:12,332 70 00:04:12,333 --> 00:04:18,633 Close the parentheses and hit enter, and there we go. Now we have the sum of all of the numbers 71 00:04:18,633 --> 00:04:18,666 72 00:04:18,666 --> 00:04:24,566 in this column. Here. If I wanted to drag this over this way, 73 00:04:24,566 --> 00:04:25,566 74 00:04:25,566 --> 00:04:31,666 now it's giving me the sum of all of the numbers in this column here. And I know that because I've clicked in my formula bar 75 00:04:31,666 --> 00:04:37,799 and it's highlighting these numbers. If I wanted to drag that even further, it will 76 00:04:37,800 --> 00:04:37,833 77 00:04:37,833 --> 00:04:43,833 give me the sum of all of these numbers here. What are some other functions we 78 00:04:43,833 --> 00:04:49,866 can use in Excel? Well, there are a lot. There's a function for almost everything you can think 79 00:04:49,866 --> 00:04:54,532 of. If we wanted the mean, we would use equals average, 80 00:04:54,533 --> 00:04:55,899 81 00:04:55,900 --> 00:05:01,566 and let's find the average of the column we just found a sum for. 82 00:05:01,566 --> 00:05:08,099 83 00:05:08,100 --> 00:05:12,066 Okay, and it looks like it's 1.249543. 84 00:05:12,066 --> 00:05:14,132 85 00:05:14,133 --> 00:05:20,366 It would have been very tedious to add up all of these little numbers, and then divide them 86 00:05:20,366 --> 00:05:20,399 87 00:05:20,400 --> 00:05:26,400 by our N, but again, Excel did that part for us, so we don't have 88 00:05:26,400 --> 00:05:32,533 to worry about it. Okay, and this was a little more than what you needed to do your first 89 00:05:32,533 --> 00:05:38,533 assignment, so you should be good to go. Let us know if you have any questions, please reach out to one of the 90 00:05:38,533 --> 00:05:38,566 91 00:05:38,566 --> 00:05:43,799 tutors or your instructor if there aren't any tutors this semester, and have fun learning Excel.