1
00:00:05,640 --> 00:00:06,130
Yeah.

2
00:00:06,170 --> 00:00:12,480
Even so in the last video we have done two basic analyses in the first one.

3
00:00:12,490 --> 00:00:17,730
We had the number of schools involved per state like California has the maximum there.

4
00:00:17,830 --> 00:00:24,370
Then we have done a small analyses in which we found that each state has maximum number of funding spa

5
00:00:24,370 --> 00:00:30,690
projects like if any state have ten project then how many fundings the projects are getting like when

6
00:00:30,700 --> 00:00:31,600
is getting under.

7
00:00:31,600 --> 00:00:36,460
Second is getting two hundred then which has the maximum number of funding but project.

8
00:00:36,460 --> 00:00:43,210
And we found that this bombing has 130 funding spark project in that state.

9
00:00:43,210 --> 00:00:46,800
The number of projects have a level there is something different from that one.

10
00:00:47,020 --> 00:00:54,040
Now in this video we are going to do some mathematical analyses like finding the maximum minimum mean

11
00:00:54,040 --> 00:00:59,530
median and the twenty five point seventy five percent days of donations.

12
00:00:59,530 --> 00:01:03,980
So this time we just need the donation amount which is present in the data for.

13
00:01:04,330 --> 00:01:08,010
You can also just use donations but I'm going to prefer data for here.

14
00:01:09,190 --> 00:01:12,300
So first for me this one is very easy for you.

15
00:01:12,300 --> 00:01:22,150
I believe you have to just use the name P methods like and or mean and hear positive values like data

16
00:01:22,150 --> 00:01:26,040
for and then pass the index there.

17
00:01:26,050 --> 00:01:34,660
That is donation amount in form of string because this one is a just element and after that here we

18
00:01:34,660 --> 00:01:40,240
have this one mean value but one more thing that we are going to do here that is if you do this thing

19
00:01:40,270 --> 00:01:45,640
and print the mean shifted then you will get this thing.

20
00:01:46,000 --> 00:01:49,320
But in some cases we have some empty values there.

21
00:01:49,510 --> 00:01:54,550
So we will use drop and the matter to drop the old null values at that value.

22
00:01:56,120 --> 00:02:01,040
So if you shifted on this thing this time we have the same output but in some cases like we have some

23
00:02:01,910 --> 00:02:04,440
empty values and that will also be counted.

24
00:02:04,460 --> 00:02:13,010
So to prevent that one use drop any matter it just use a one statement but provide you from us.

25
00:02:13,580 --> 00:02:20,840
After that we will use and be the median for counting the median that is NPD median

26
00:02:23,830 --> 00:02:33,060
and then again plus this complete statement it is here we have this one.

27
00:02:33,060 --> 00:02:35,040
After that we require percentiles

28
00:02:38,120 --> 00:02:43,340
and we will use and B don't fuss and die and B is also a plus in diameter.

29
00:02:43,340 --> 00:02:54,620
That is just NPD with percent percentile then pass the same values to that one also including the percentiles.

30
00:02:54,620 --> 00:02:58,460
You need to calculate like if I need to calculate quantified then just twenty five.

31
00:02:58,670 --> 00:03:00,440
But here I need to calculate two.

32
00:03:01,100 --> 00:03:06,020
So I will pass a list containing those two like twenty five point seventy five.

33
00:03:07,400 --> 00:03:12,930
After that we have minimum and maximum values that is mini mum.

34
00:03:13,280 --> 00:03:15,610
And that will be first.

35
00:03:15,620 --> 00:03:20,070
I will use data for and notified any method here.

36
00:03:20,150 --> 00:03:33,080
We can just simply do donation amount and then don't group any here just past don't mean and Max for

37
00:03:33,080 --> 00:03:34,640
D like for minimum.

38
00:03:34,640 --> 00:03:37,970
We have mean and full maximum.

39
00:03:37,970 --> 00:03:46,720
Just copy this one pasted here and choose this one into Max so that we can have a maximum value.

40
00:03:46,880 --> 00:03:48,590
Also the sum maximum

41
00:03:50,800 --> 00:03:53,740
maximum allotment.

42
00:03:53,770 --> 00:03:54,390
There we go.

43
00:03:55,120 --> 00:04:00,810
After that we will print all these values in the space here and then print the values.

44
00:04:01,360 --> 00:04:06,550
First one is like mean donation

45
00:04:09,060 --> 00:04:15,940
amount is and then this dot and then here just pass that one.

46
00:04:16,200 --> 00:04:21,830
Now we will not simply pass the mean because if you notice this one is very precise.

47
00:04:21,840 --> 00:04:28,310
We can see we can just download this one food here we have only two values around this one for up to

48
00:04:28,560 --> 00:04:36,390
only two values so NPD round for rounding the figures rounding means we can just if we have this particular

49
00:04:36,390 --> 00:04:42,960
value 9 the following value previous to this one if it is greater than 5 then develop will be documented

50
00:04:42,960 --> 00:04:43,800
by 1.

51
00:04:43,800 --> 00:04:48,390
Otherwise it will be missing like if I have 4 5 4 6 here.

52
00:04:48,530 --> 00:04:56,620
Then if I round this one up to only one figure then this will become 5 because 6 is greater than 5.

53
00:04:57,540 --> 00:05:06,720
If it is less than 5 like 3 or 4 against it 4 or 2 then the value on one round of vitamin C and if it

54
00:05:06,720 --> 00:05:14,000
is actually 5 then we see the first value if it is all then it will increment by 1.

55
00:05:14,250 --> 00:05:22,080
If it is even it will remain C so that's the little light over the round of is so that we can just have

56
00:05:22,620 --> 00:05:26,040
only these two or only these 4 5 values.

57
00:05:26,040 --> 00:05:32,510
We do not have this large numeric value so we ruled out of the sun and we can just easily download by

58
00:05:32,630 --> 00:05:36,040
seeing the last figure like before 6 sorry one.

59
00:05:36,040 --> 00:05:37,400
We have this one zero.

60
00:05:37,430 --> 00:05:40,480
So there is no case that it will became greater than five.

61
00:05:40,490 --> 00:05:45,970
It would just increment by one if the previous value is greater than five so it will remain to one.

62
00:05:46,310 --> 00:05:50,030
So we will just round this one up to only two figures.

63
00:05:50,360 --> 00:05:52,130
So here we will pass panties.

64
00:05:52,130 --> 00:05:58,310
The main value that we have to round off and to up to how many figures you want go round of like two.

65
00:05:58,670 --> 00:06:00,010
Then I just pass two here.

66
00:06:01,710 --> 00:06:09,720
Copy this one paste this one ham and cheese this one into median median donation amounts and then we

67
00:06:09,720 --> 00:06:12,020
have this one we can again.

68
00:06:12,140 --> 00:06:13,560
Jeez this one.

69
00:06:13,810 --> 00:06:21,150
Median and this time we did not require a pound off here we have median.

70
00:06:21,150 --> 00:06:26,400
After that we have this one again this time we will print the percentiles

71
00:06:29,210 --> 00:06:37,420
25 percent and we have used 25 first so twenty five percent and then seventy five percent.

72
00:06:37,730 --> 00:06:43,210
No nation amount is and then this one just so there we go with that one.

73
00:06:44,470 --> 00:06:49,370
Now we also need to change this one into percentile.

74
00:06:52,100 --> 00:07:01,650
We had this one as well so after that we have just minimum and maximum this one into minimum cheese

75
00:07:01,750 --> 00:07:05,730
this running to minimum.

76
00:07:05,910 --> 00:07:06,720
We have the sun

77
00:07:09,400 --> 00:07:11,920
and after that we have the maximum

78
00:07:14,910 --> 00:07:21,320
this one indoor maximum and this Sun also a two maximum.

79
00:07:21,380 --> 00:07:26,340
There we go shift it on we got the arrows here have more fences.

80
00:07:26,400 --> 00:07:29,450
That is from that phone I have no people shifted on.

81
00:07:29,450 --> 00:07:30,670
David go with that.

82
00:07:31,110 --> 00:07:34,030
Here mean donation amount is sixty one point zero three.

83
00:07:34,230 --> 00:07:38,420
If you have noticed that one only two values after the point we have.

84
00:07:38,820 --> 00:07:42,570
So this one is maybe four after the points round.

85
00:07:43,050 --> 00:07:49,060
I suppose this one is for Main fingers but it's round round table of the values up to the decimal points.

86
00:07:49,230 --> 00:07:52,310
So two values up to the decimal point zero point three.

87
00:07:52,410 --> 00:07:56,730
Then we have the median that is twenty five already rounded off.

88
00:07:57,240 --> 00:08:02,040
After that we have twenty five and seventy five percent that are fifteen and fifty.

89
00:08:02,040 --> 00:08:08,110
After that we have the minimum donation amount that is zero point zero one and then we have maximum

90
00:08:08,110 --> 00:08:10,520
donation that is sixty thousand.

91
00:08:10,640 --> 00:08:13,270
That is very large amount I believe.

92
00:08:14,470 --> 00:08:18,320
So this is about some simple mathematical analyses.

93
00:08:18,340 --> 00:08:19,230
Thanks for watching.

94
00:08:19,230 --> 00:08:21,180
We will continue with more in the next video.