In a class, there are twenty students. They had a test, the evaluation of which is mentioned in the table below. The data for the class is given below: Name Maths (out of 50) Language ( out of 50) Total Jerry 25 27 ? Tom 35 45 Chris 42 15 Sylvie 47 32 Jack 32 45 Jarrah 25 50 Michael 24 15 Michelle 40 42 Nathaniel 50 41 Joy 74 32 Rui 50 22 Greg 15 50 Tommy 10 40 Vinny 20 35 Sarah 45 42 Natalie 42 48 George 31 26 Charlie 27 45 Brandon 36 33 William 38 37 1. Create the same table in Excel workbook. 2. Save the excel workbook as Assignment 1 3. Add the total numbers for
In a class, there are twenty students. They had a test, the evaluation of which is mentioned in the table below. The data for the class is given below: Name Maths (out of 50) Language ( out of 50) Total Jerry 25 27 ? Tom 35 45 Chris 42 15 Sylvie 47 32 Jack 32 45 Jarrah 25 50 Michael 24 15 Michelle 40 42 Nathaniel 50 41 Joy 74 32 Rui 50 22 Greg 15 50 Tommy 10 40 Vinny 20 35 Sarah 45 42 Natalie 42 48 George 31 26 Charlie 27 45 Brandon 36 33 William 38 37 1. Create the same table in Excel workbook. 2. Save the excel workbook as Assignment 1 3. Add the total numbers for
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Question
In a class, there are twenty students. They had a test, the evaluation of which is mentioned in the table below. The data for the class is given below:
Name
Maths (out of 50)
Language ( out of 50)
Total
Jerry
25
27
?
Tom
35
45
Chris
42
15
Sylvie
47
32
Jack
32
45
Jarrah
25
50
Michael
24
15
Michelle
40
42
Nathaniel
50
41
Joy
74
32
Rui
50
22
Greg
15
50
Tommy
10
40
Vinny
20
35
Sarah
45
42
Natalie
42
48
George
31
26
Charlie
27
45
Brandon
36
33
William
38
37
1. Create the same table in Excel workbook.
2. Save the excel workbook as Assignment 1
3. Add the total numbers for each student and write under total tab. Using a formula will be a bonus.
4. Make a graph in excel for Maths evaluation.
5. Make a graph for Language evaluation.
6. Which subject seems to be easier for the students? Why?
7. Name the student who has the highest total marks.
8. Create a new sheet and name it Test 1
9. In Test 1, Create a new table using the same values but add some information of your choice. It can be another test scores or grades.
10. Name the type of data in the table.
Expert Solution
Step 1: Information
As per the guideline, I am supposed to solve only first three subparts of the given question.
Given that :
In a class, there are twenty students. They had a test, the evaluation of which is mentioned in the table below. The data for the class is given below: Name Maths (out of 50) Language ( out of 50) Total Jerry 25 27 ? Tom 35 45 Chris 42 15 Sylvie 47 32 Jack 32 45 Jarrah 25 50 Michael 24 15 Michelle 40 42 Nathaniel 50 41 Joy 74 32 Rui 50 22 Greg 15 50 Tommy 10 40 Vinny 20 35 Sarah 45 42 Natalie 42 48 George 31 26 Charlie 27 45 Brandon 36 33 William 38 37.
1. Create the same table in Excel workbook.
2. Save the excel workbook as Assignment 1
3. Add the total numbers for each student and write under total tab. Using a formula will be a bonus.
Step by step
Solved in 4 steps with 1 images
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
