Question

a) fill out the blank cells in the table using functions sum, average, max and min.
b) make a plot which is similar to the 3 - d column bar. dont copy the existing one.
(how to make the plot: in the table, select data -> click insert tab -> choose 3 - d column)
student grades
name math history english average sum max min
jack 75 87 89
dan 79 79 84
john 80 69 68
mary 86 96 87
rob 89 88 80
sam 68 73 77
average
sum
max
min

Explanation:

Step1: Calculate each student's average

For Jack: \((75 + 87+89)\div3=\frac{75 + 87+89}{3}=\frac{251}{3}\approx83.67\)
For Dan: \((79 + 79+84)\div3=\frac{79 + 79+84}{3}=\frac{242}{3}\approx80.67\)
For John: \((80 + 69+68)\div3=\frac{80 + 69+68}{3}=\frac{217}{3}\approx72.33\)
For Mary: \((86 + 96+87)\div3=\frac{86 + 96+87}{3}=\frac{269}{3}\approx89.67\)
For Rob: \((89 + 88+80)\div3=\frac{89 + 88+80}{3}=\frac{257}{3}\approx85.67\)
For Sam: \((68 + 73+77)\div3=\frac{68 + 73+77}{3}=\frac{218}{3}\approx72.67\)

Step2: Calculate each subject's average

Math average: \((75 + 79+80+86+89+68)\div6=\frac{75 + 79+80+86+89+68}{6}=\frac{467}{6}\approx77.83\)
History average: \((87 + 79+69+96+88+73)\div6=\frac{87 + 79+69+96+88+73}{6}=\frac{492}{6} = 82\)
English average: \((89 + 84+68+87+80+77)\div6=\frac{89 + 84+68+87+80+77}{6}=\frac{485}{6}\approx80.83\)

Step3: Calculate each student's sum

For Jack: \(75 + 87+89=251\)
For Dan: \(79 + 79+84=242\)
For John: \(80 + 69+68=217\)
For Mary: \(86 + 96+87=269\)
For Rob: \(89 + 88+80=257\)
For Sam: \(68 + 73+77=218\)

Step4: Calculate each subject's sum

Math sum: \(75 + 79+80+86+89+68=467\)
History sum: \(87 + 79+69+96+88+73=492\)
English sum: \(89 + 84+68+87+80+77=485\)

Step5: Calculate each subject's max

Math max: \(89\)
History max: \(96\)
English max: \(89\)

Step6: Calculate each subject's min

Math min: \(68\)
History min: \(69\)
English min: \(68\)

Answer:

Name	Math	History	English	Average	Sum	Max	Min
Dan	79	79	84	80.67	242	89	68
John	80	69	68	72.33	217	89	68
Mary	86	96	87	89.67	269	89	68
Rob	89	88	80	85.67	257	89	68
Sam	68	73	77	72.67	218	89	68
Average	77.83	82	80.83	-	-	-	-
Sum	467	492	485	-	-	-	-
Max	89	96	89	-	-	-	-
Min	68	69	68	-	-	-	-