UID Gender Age (18 - 25) Marks (1 - 100)

21MBA5001 Male 21 3
21MBA5002 Male 23 74
21MBA5003 Female 20 82
21MBA5004 Male 23 6
21MBA5005 Male 24 83
21MBA5006 Male 23 85
21MBA5007 Male 22 3
21MBA5008 Female 24 77
21MBA5009 Female 19 2
21MBA50010 Female 24 35
21MBA50011 Female 19 38
21MBA50012 Female 23 97
21MBA50013 Female 22 34
21MBA50014 Male 25 39
21MBA50015 Male 24 6
21MBA50016 Female 25 22
21MBA50017 Male 18 63
21MBA50018 Male 23 1
21MBA50019 Male 22 68
21MBA50020 Male 23 5
21MBA50021 Female 23 27
21MBA50022 Female 20 32
21MBA50023 Female 23 93
21MBA50024 Female 23 56
21MBA50025 Female 21 79
21MBA50026 Female 20 68
21MBA50027 Male 25 56
21MBA50028 Male 20 38
21MBA50029 Female 20 32
21MBA50030 Male 21 77
21MBA50031 Male 24 72
21MBA50032 Male 22 90
21MBA50033 Male 25 37
21MBA50034 Female 22 13
21MBA50035 Female 19 35
21MBA50036 Female 18 16
21MBA50037 Female 20 13
21MBA50038 Female 20 16
21MBA50039 Female 19 19
21MBA50040 Male 23 68
21MBA50041 Male 24 15
21MBA50042 Female 18 12
21MBA50043 Male 21 97
21MBA50044 Male 18 23
21MBA50045 Male 21 97
21MBA50046 Male 24 74
21MBA50047 Female 24 59
21MBA50048 Female 24 30
21MBA50049 Female 21 67
21MBA50050 Female 23 15
21MBA50051 Female 18 66
21MBA50052 Female 18 21
21MBA50053 Male 21 98
21MBA50054 Male 19 60
21MBA50055 Female 23 77
21MBA50056 Male 22 47
21MBA50057 Male 18 70
21MBA50058 Male 21 52
21MBA50059 Male 22 10
21MBA50060 Female 21 66
21MBA50061 Female 18 69
21MBA50062 Female 22 25
21MBA50063 Female 22 7
21MBA50064 Female 24 60
21MBA50065 Female 23 29
21MBA50066 Male 22 26
21MBA50067 Male 21 80
21MBA50068 Female 18 14
21MBA50069 Male 20 13
21MBA50070 Male 25 94
21MBA50071 Male 22 5
21MBA50072 Male 25 74
21MBA50073 Female 25 62
21MBA50074 Female 23 65
21MBA50075 Female 22 96
21MBA50076 Female 20 74
21MBA50077 Female 24 84
21MBA50078 Female 24 29
21MBA50079 Male 25 48
21MBA50080 Male 18 24
21MBA50081 Female 23 8
21MBA50082 Male 25 74
21MBA50083 Male 25 96
21MBA50084 Male 18 68
21MBA50085 Male 20 36
21MBA50086 Female 24 99
21MBA50087 Female 23 84
21MBA50088 Female 21 44
21MBA50089 Female 19 31
21MBA50090 Female 23 34
21MBA50091 Female 21 85
21MBA50092 Male 20 21
21MBA50093 Male 18 51
21MBA50094 Female 22 67
21MBA50095 Male 23 10
21MBA50096 Male 18 5
21MBA50097 Male 18 65
21MBA50098 Male 20 6
21MBA50099 Female 18 4
21MBA500100 Female 21 42
21MBA500101 Female 22 99
21MBA500102 Female 20 60
21MBA500103 Female 18 68
21MBA500104 Female 23 32
21MBA500105 Male 25 87
21MBA500106 Male 20 92
21MBA500107 Female 21 76
21MBA500108 Male 23 90
21MBA500109 Male 20 31
21MBA500110 Male 18 36
21MBA500111 Male 24 63
21MBA500112 Female 21 66
21MBA500113 Female 18 7
21MBA500114 Female 20 97
21MBA500115 Female 21 16
21MBA500116 Female 24 96
21MBA500117 Female 20 71
21MBA500118 Male 25 78
21MBA500119 Male 25 69
21MBA500120 Female 19 38
21MBA500121 Male 21 33
21MBA500122 Male 22 10
21MBA500123 Male 20 16
21MBA500124 Male 24 68
21MBA500125 Female 25 39
21MBA500126 Female 22 75
21MBA500127 Female 18 94
21MBA500128 Female 19 81
21MBA500129 Female 25 66
21MBA500130 Female 21 89
21MBA500131 Male 21 75
21MBA500132 Male 25 35
21MBA500133 Female 24 9
21MBA500134 Male 25 18
21MBA500135 Male 21 56
21MBA500136 Male 19 20
21MBA500137 Male 18 32
21MBA500138 Female 21 38
21MBA500139 Female 19 64
21MBA500140 Female 18 81
21MBA500141 Female 22 22
21MBA500142 Female 22 67
21MBA500143 Female 18 99
21MBA500144 Male 20 91
21MBA500145 Male 18 26
21MBA500146 Female 22 53
21MBA500147 Male 20 21
21MBA500148 Male 23 78
21MBA500149 Male 19 92
21MBA500150 Male 25 45
21MBA500151 Female 18 50
21MBA500152 Female 22 54
21MBA500153 Female 22 61
21MBA500154 Female 20 52
21MBA500155 Female 19 70
21MBA500156 Female 19 32
21MBA500157 Male 21 66
21MBA500158 Male 19 14
21MBA500159 Female 24 80
21MBA500160 Male 22 41
21MBA500161 Male 22 69
21MBA500162 Male 22 61
21MBA500163 Male 20 83
21MBA500164 Female 24 91
21MBA500165 Female 18 100
21MBA500166 Female 18 44
21MBA500167 Female 20 80
21MBA500168 Female 22 92
21MBA500169 Female 24 88
21MBA500170 Male 23 10
21MBA500171 Male 23 23
21MBA500172 Female 21 3
21MBA500173 Male 18 89
21MBA500174 Male 20 1
21MBA500175 Male 24 71
21MBA500176 Male 18 42
21MBA500177 Female 24 74
21MBA500178 Female 24 35
21MBA500179 Female 23 39
21MBA500180 Female 21 100
21MBA500181 Female 19 15
21MBA500182 Female 25 39
21MBA500183 Male 25 33
21MBA500184 Male 24 21
21MBA500185 Female 20 17
21MBA500186 Male 18 95
21MBA500187 Male 19 83
21MBA500188 Male 23 83
21MBA500189 Male 19 40
21MBA500190 Female 20 70
21MBA500191 Female 22 62
21MBA500192 Female 18 90
21MBA500193 Female 20 16
21MBA500194 Female 22 55
21MBA500195 Female 24 40
21MBA500196 Male 25 33
21MBA500197 Male 23 53
21MBA500198 Male 19 83
21MBA500199 Male 21 54
21MBA500200 Male 22 10
Complete the data set using RANDBETWEEN() function.
Age ranges from 18 to 25 years.
Marks range from 1 to 100.
Freeze these numbers that are generated under column name "Age (18 - 25) and Marks
(1 - 100)".

Question 1: With the help of the data set created by the student, prove that when can the
calculation done through PERCENTILE.INC(), QUARTILE.INC() and MIN() formulas will
give same result. Use the "Marks (1 - 100)" column only.

Explain the reason for having same result.

PERCENTILE 1
QUARTILE 1
MIN 1
AVERAGE- 40 MIN
SD 10 MIN
LOWER LIMIT 25 MIN
UPEER LIMIT 35 MIN

1) 25 TO 35 MIN UPPER LIMIT 30.85%

Percentage of time that

2) EXACT 25 MIN UPPER LIMIT 3.52%

Percentage of time that

Calculate:
1. Percentage of time that Ram will complete the lunch between 25 minutes
and 35 minutes.
2. Percentage of time that Ram will complete the lunch in exactly 25
minutes.
Marks (1 - 100)
3 Instruction:
74 Use the Marks (1 - 100) column
82 by the student in worksheet "Qu
6
Question 3:
83 Chart 1: Draw a line chart and
85 Deviation).
3 Chart 2: Replicate the chart 1 m
77
2
35 CHART 1
38
97 Chart Title
34 120
39
100
6
22
80
63
1 60
68
5 40

27
20
32
93 0
1 10 19 28 37 46 55 64 73 82 91 100 109 118 127 136 145 154 163 172 181 190 199
56
79
68
56
38
32
77
72
90
37
13
35
16
13
16
19
68
15
12
97
23
97
74
59
30
67
15
66
21
98
60
77
47
70
52
10
66
69
25
7
60
29
26
80
14
13
94
5
74
62
65
96
74
84
29
48
24
8
74
96
68
36
99
84
44
31
34
85
21
51
67
10
5
65
6
4
42
99
60
68
32
87
92
76
90
31
36
63
66
7
97
16
96
71
78
69
38
33
10
16
68
39
75
94
81
 66
89
75
35
9
18
56
20
32
38
64
81
22
67
99
91
26
53
21
78
92
45
50
54
61
52
70
32
66
14
80
41
69
61
83
91
100
44
80
92
88
10
23
 3
89
1
71
42
74
35
39
100
15
39
33
21
17
95
83
83
40
70
62
90
16
55
40
33
53
83
54
10
Instruction:
Use the Marks (1 - 100) column only from the data set created
by the student in worksheet "Question 1".

Question 3:
Chart 1: Draw a line chart and add error bars (Standard
Deviation).
Chart 2: Replicate the chart 1 manually as discussed in class.

Chart 2

Chart Title
120

100

80

60

40

20

0
118 127 136 145 154 163 172 181 190 199 1 10 19 28 37 46 55 64 73 82 91 100 109 118 127 136 145 154 163 172 181 190 199
5 154 163 172 181 190 199