0:00
Hello everyone.
00:01
So we have been given in this particular occasion we have to use a tool or technology of our choice to answer this question.
00:08
I will be using excel.
00:10
You can use excel or minutap or some other technology as for your convenience.
00:15
So for this particular location we have to download our dataset from the web.
00:19
It's been given indication.
00:21
I have downloaded the same.
00:22
So we have given a particular column type and different values in this particular type column.
00:29
The number of rows, are more than 5 ,000 now firstly we have to see for different unique values this particular type column has to calculate to calculate that particular thing we will go to data advanced copy to different another location so list range would be from a to the last row criteria range would also be the same we want to copy to c2 let's say we just want the unique records again so we got the unique records here and pc is repeating.
01:13
Okay, that might be written before.
01:17
Now we have to calculate the frequency of these particular types that we have here.
01:22
We'll use the counter function.
01:28
We have to select the rules from which we want to search.
01:32
Then we have to mention which value we want to search.
01:36
It would be this one.
01:44
So we have total of 2 ,919 npc types here, the counts.
01:51
Similarly we will calculate the count of other columns as well and the total sum of these counts.
02:01
It's 57747.
02:03
Let's see if that matches.
02:06
Yes, 5 and 4 .8 minus 1 that 51747 rows we have here.
02:11
The sum matches so we have calculated correctly...