Comprehensive Excel Data Analysis
Budget: $10 – $30 USD
Excel sheet with the data.
Calculate the maximum and minimum of the datahe range of the data.The mean of the data.
4. The median of the data.
5. The mode of the data.
6. The standard deviation of the data.
7. The first quartile (Q1), the second quartile/median (Q2), the third quartile (Q3), and the interquartile range
of the data (IQR
Sketch the box-plot/box-and-whisker plot for the data and comment on the distribution of the data.
26, 46, 45, 93, 95, 5, 2, 91, 94, 37,
16, 99, 21, 18, 19, 35, 73, 86, 96, 25,
53, 10, 38, 89, 31, 28, 9, 69, 17, 33,
7, 4, 14, 55, 100, 29, 50, 90, 61, 63,
51, 57, 60, 11, 3, 72, 6, 68, 92, 74,
49, 20, 82, 66, 71, 98, 22, 41, 76, 42,
97, 13, 39, 75, 48, 59, 1, 32, 83, 52,
47, 64, 78, 77, 81, 40, 15, 36, 85, 65,
70, 27, 79, 43, 44, 87, 54, 30, 23, 67,
24, 56, 12, 8, 84, 80, 62, 34, 58, 88.
Given the data below, find:
1. Sketch the histogram and frequency polygon of the data.
For questions 2.2. – 2.4 use:
2. The mean of the data.
3. The median of the data.
4. The modal class of the data.
5. Sketch the ogive of the data.
6. From the ogive, find the first quartile (Q1), the second quartile (Q2), the third quartile (Q3), and the
interquartile range.
Class Boundaries/Intervals frequency
150 – 155 155 – 160 9
160 – 165 165 – 170 170 – 175 5
12
14
10
Calculate the maximum and minimum of the datahe range of the data.The mean of the data.
4. The median of the data.
5. The mode of the data.
6. The standard deviation of the data.
7. The first quartile (Q1), the second quartile/median (Q2), the third quartile (Q3), and the interquartile range
of the data (IQR
Sketch the box-plot/box-and-whisker plot for the data and comment on the distribution of the data.
26, 46, 45, 93, 95, 5, 2, 91, 94, 37,
16, 99, 21, 18, 19, 35, 73, 86, 96, 25,
53, 10, 38, 89, 31, 28, 9, 69, 17, 33,
7, 4, 14, 55, 100, 29, 50, 90, 61, 63,
51, 57, 60, 11, 3, 72, 6, 68, 92, 74,
49, 20, 82, 66, 71, 98, 22, 41, 76, 42,
97, 13, 39, 75, 48, 59, 1, 32, 83, 52,
47, 64, 78, 77, 81, 40, 15, 36, 85, 65,
70, 27, 79, 43, 44, 87, 54, 30, 23, 67,
24, 56, 12, 8, 84, 80, 62, 34, 58, 88.
Given the data below, find:
1. Sketch the histogram and frequency polygon of the data.
For questions 2.2. – 2.4 use:
2. The mean of the data.
3. The median of the data.
4. The modal class of the data.
5. Sketch the ogive of the data.
6. From the ogive, find the first quartile (Q1), the second quartile (Q2), the third quartile (Q3), and the
interquartile range.
Class Boundaries/Intervals frequency
150 – 155 155 – 160 9
160 – 165 165 – 170 170 – 175 5
12
14
10