Question

that's the question

These two pictures is what the professor wants

fig 3.8(a)

4) Solve Problem 5.16 on Worksheet 4. Then, on the same worksheet solve Problem 5.19 and compare its results with the line graph created in Problem 5.16 using the same data. 5.16 Reconstruct the worksheet shown in Fig. 3.8(a) containing student exam scores. Construct a line graph of the overall scores for the individual students. Do not include the overall class average in the graph. Add a chart title and a title along each of the axes. 5.19 Reconstruct the worksheet shown in Fig. 3.8(a) containing student exam scores. Construct a bar graph of the overall scores for the individual students. Do not include the overall class average in the graph. Construct the graph in such a manner that the individual vertical bars touch one another. Add a chart title and a title along each of the axes. Compare with the line graph created for Prob. 5.16, using the same data. A2 f Davis 8 1 2 Davis 3 Graham 4 Jones 5 Meyers 6 Richardson 7 Thomas 8 Williams 1 Student Exam 1 Exam 2 Final Exam Overall Score 82 95 47 80 74 57 80 100 62 58 81 62 94 75 97 78 73 85 67 84.3 73.7 97.3 62.3 70.3 80 62 10 AVERAGE 71.6 74.3 81.3 75.7 15 Average: 79 Count: 10 Sum: 632E 100s Figure 3.8(a) - Preparing to insert two new rows above row 2

Answer 1

5.16

OVERALL SCORE 97.3 84.3 80 3.7 70.3 62.3 62 Davis Graham Jones Meyers Richardson Thomas Williams

5.19

TiHi au 80 60 40 20 Davis Graham Jones Meyers Richardson Thomas Williams Student names