Speaker 1: Hello, everyone. In this video, we will try to understand how to find the frequency distribution and the mean of the data if we are working on a large-scale data. So for example, we have up to 50 respondents and we want to find out what is the frequency distribution, how many people answered 5, 4, 3, 2, or 1 in some questions. Then it will be a tedious task to do it manually. That's why I suggest that you use Excel so that the data will be 100% accurate and it will be much better, efficient, and faster. So you will see that I arranged the data in this way and I suggest that you do the same so that the data will be easier for you to work on. So let's proceed with the first step. Highlight all the cells that will contain our data for the frequency distribution. So type in equals, then type in the word frequency, open parenthesis, then highlight the data for the question that you wanted to find out how many frequency distribution do they have. So let's highlight this one. Make sure that you highlight it from the top up to the bottom of the data and then type in comma. After you type in the comma, highlight this part because we wanted to find out how many answered 5, 4, 3, 2, 1 and this contains the 5, the 4, the 3, the 2, and the 1. Then close parenthesis. Next step would be adding a dollar sign for all this part, for H5, for the number, for the H again, and for the number. The reason why we include dollar sign means that even if we go to question 2, question 3, so on and so forth, still the data or the bins array for this one will be 5, 4, 3, 2, 1. It will not change. So only the question will change, but the bins array or the 5, 4, 3, 2, 1 will not change. Then before you enter, make sure that you click control shift, then enter. Then you will see that the frequency distribution for 5, 4, 3, 2, 1 for question 1 is already there. Now instead of typing or instead of going to step 1 for question 2, 3, and so on and so forth, you can just highlight this one and then drag up to the last question that you have. You will notice that they will have their frequency distribution as well. Next step would be finding the mean. In finding the mean for the Likert scale data, it is different from the usual mean that we use. In the usual mean, you will just add this and then divide by how many respondents. That is not the case for the Likert scale of data. So if you do that, the answer will be wrong. So this is how you find the mean for the Likert scale of data. First thing you type in equals, and then open parentheses, and click the cell for 5, and then multiply by 5 since we wanted to find out the mean for 5, 4, 3, 2, 1 for question 1. So 26, and then multiply by 5, so that's it. Next is plus, click the next cell, times 4 because we are in the 4, plus, then click this one, times 3 because we are on the 3. Next, click plus, this one, multiplied by 2 because we are on 2, then plus, click this one, or you can multiply by 1, or you can just add it because multiplied by 1 is just the same, and then close parentheses, divided by how many respondents that we have. In this case, we have 50 respondents, so we will divide it by 50, then click enter. So you will see that we have 3.72 mean for question 1. So instead of typing all the formula for question 2, 3, and so on, we can just drag it up to the last question that we have. Next step, to find the overall mean for all the questions in your data, you can just type in equals, and then add all of the mean for question 1, 2, to the last. Let's have this, and then let's add the next mean, add the next mean, add to the last mean that you have, divided by 3 because we have 3 questions here. Assuming that you have 10 questions, then you will have divided by 10. So it's divided by 3 because we only have questions 1, 2, and 3, then click enter. So we know that the mean is 3.62667, or if we rounded it off in two decimal places, we will have 3.63. Now how are we going to find out if the frequency distribution for all the data is correct? We just have to find the sum, all this, this, and this. Let's have sum, close parenthesis, open parenthesis, and then highlight this one, and then enter. If the answer is 50, which is equal to the number of respondents that you have, then the answer is correct. If it's not, then some of the data is missing. Now, how do we present this data on a table? For us to present it in a table, this is my preferred way of presenting the data in a table. Okay, so I arranged it in question 1, 2, and 3 because we only have 3 questions. So let's see, question 1, how many answered 5? So we have 26, so I will just type in 26. How many answered 4? We have 6. How many answered 3? So we have 1. How many answered 2? We have 12. And how many answered 5 is, we have 5 here, and then just copy the mean, 3.72. So you just have to fill in this table with the one that you have here. That is how you find the frequency distribution and the mean using XM. You're going to see that it's much faster and much organized, and the accuracy is 100%. Thank you, and that's all.