1. Evaluate:
a) -2 x 7
b) 6 x -3
c) -2 x -5
d) [2+5-1]x[8-2+3]
2. Evaluate:
a) (1/6)/(5/6)
b) 2/(1/4)
c) ½ x (1/3)/(1/6)
3. Evaluate:
a) 161/2
b) 93/2
c) 82/3
4. Plot the following points in the x-y plane and label them:
a) (-1.5, -3.5)
b) (2.2, 0
c) (1.2, -2.6)
d) (-0.4, 0.4)
5. An advertising agency classified goods into five categories of quality: A (highest), B, C, D and E (lowest). The percentages of heavily advertised brands and moderately advertised brands within each quality grade are shown in the following table.
| Quality grade |
Percentage of heavily advertised brands |
Percentage of moderately advertised brands |
| A |
22.3 |
18.3 |
| B |
19.7 |
21.1 |
| C |
41.2 |
39.4 |
| D |
10.3 |
12.4 |
| E |
6.5 |
8.8 |
| Total |
100 |
100 |
a) Illustrate the data using two pie chart of equal size.
b) Illustrate the data using a multiple bar chart.
6. The length (in meters) of the speeches of 10 politicians in parliament on a certain day were:
20 2 15 7 43 10 27 36 9 22
a) Find the mean length.
b) Find the median length.
c) Find the range of the lengths.
d) Find the mean deviation of the lengths.
e) Finds the standard deviation of the lengths.
f) Find the coefficient of variation of the lengths.
7. For each of 8 weeks, a restaurateur recorded how many customers ordered her special dish of lobster tails. The results were:
12 10 8 16 5 9 13 7
For these data, calculate:
a) the range
b) the mean deviation
c) the standard deviation
Student Comments: I have attached a file called Mean, Mean Deviation, Standard Deviation showing how to use Excel both using an Excel function and not using the Excel function. The main purpose is to show you how to use Excel to calculate the mean deviation. I repeat the requirements. Entering the answer on a spreadsheet is not using Excel software. You must use appropriate functions or formulas and that is what I am looking for.
Attachment:- Mean, Mean Deviation, Stand Dev.rar