In MatLab The excel file contains the grade for 3 homeworks and 3 exams for sect
ID: 3011669 • Letter: I
Question
In MatLab
The excel file contains the grade for 3 homeworks and 3 exams for section-102. The maximum grade for each HW is 20 and the maximum grade for each Exam is 100. This is how you should calculate the total grade Read the excel file named 'samplegrades.xlsx' with xlsread function, save it in a matrix variable. Calculate the total grade for each student. Write an additional column in the same excel file (in the same sheet) with the total grade. HOMEWORK Calculate the average and standard deviation of total-grades Plot a histogram of total-grades. The range should be 0 to 10, with binsize=10. Calculate the grade of each student and place another column to the right. [A: greaterthanorequalto equal to 90; B: greaterthanorequalto equal to 80; C: greaterthanorequalto equal to 70; D: greaterthanorequalto equal to 60; E: greaterthanorequalto equal to 50; F greaterthanorequalto equal to 50]Explanation / Answer
ID
Name
HW1
Exam1
HW2
Exam2
HW3
Exam3
Total
Grade
1000101
Student01
15
67
16
72
13
63
67.8
D
72.805
-5.005
25.05003
1000102
Student02
20
88
15
96
18
68
83.05
B
72.805
10.245
104.96
1000103
Student03
8
77
8
65
10
52
60.2
D
72.805
-12.605
158.886
1000104
Student04
15
78
13
68
19
81
76.6
C
72.805
3.795
14.40202
1000105
Student05
7
66
16
95
18
77
77.45
C
72.805
4.645
21.57603
1000106
Student06
9
74
14
89
18
67
74.45
C
72.805
1.645
2.706025
1000107
Student07
15
94
13
88
12
99
90.15
A
72.805
17.345
300.849
1000108
Student08
9
93
18
72
16
52
70.2
C
72.805
-2.605
6.786025
1000109
Student09
7
53
14
56
16
89
70.8
C
72.805
-2.005
4.020025
1000110
Student10
5
63
14
69
8
93
72.3
C
72.805
-0.505
0.255025
1000111
Student11
11
91
17
76
16
74
78.65
C
72.805
5.845
34.16403
1000112
Student12
13
76
10
54
16
87
72.7
C
72.805
-0.105
0.011025
1000113
Student13
7
74
7
50
14
64
60.4
D
72.805
-12.405
153.884
1000114
Student14
16
60
10
78
13
63
66.3
D
72.805
-6.505
42.31503
1000115
Student15
16
56
15
62
10
59
60.4
D
72.805
-12.405
153.884
1000116
Student16
6
88
16
89
20
69
78.9
C
72.805
6.095
37.14903
1000117
Student17
9
75
12
63
19
90
76
C
72.805
3.195
10.20803
1000118
Student18
12
69
7
98
20
52
69.7
D
72.805
-3.105
9.641025
1000119
Student19
8
64
14
72
16
90
75
C
72.805
2.195
4.818025
1000120
Student20
15
62
6
88
13
83
75.05
C
72.805
2.245
5.040025
1456.1
1090.605
The average grade of the total grades is
72.805
C
Standard deviation of the toal grade is
7.38446
ID
Name
HW1
Exam1
HW2
Exam2
HW3
Exam3
Total
Grade
1000101
Student01
15
67
16
72
13
63
67.8
D
72.805
-5.005
25.05003
1000102
Student02
20
88
15
96
18
68
83.05
B
72.805
10.245
104.96
1000103
Student03
8
77
8
65
10
52
60.2
D
72.805
-12.605
158.886
1000104
Student04
15
78
13
68
19
81
76.6
C
72.805
3.795
14.40202
1000105
Student05
7
66
16
95
18
77
77.45
C
72.805
4.645
21.57603
1000106
Student06
9
74
14
89
18
67
74.45
C
72.805
1.645
2.706025
1000107
Student07
15
94
13
88
12
99
90.15
A
72.805
17.345
300.849
1000108
Student08
9
93
18
72
16
52
70.2
C
72.805
-2.605
6.786025
1000109
Student09
7
53
14
56
16
89
70.8
C
72.805
-2.005
4.020025
1000110
Student10
5
63
14
69
8
93
72.3
C
72.805
-0.505
0.255025
1000111
Student11
11
91
17
76
16
74
78.65
C
72.805
5.845
34.16403
1000112
Student12
13
76
10
54
16
87
72.7
C
72.805
-0.105
0.011025
1000113
Student13
7
74
7
50
14
64
60.4
D
72.805
-12.405
153.884
1000114
Student14
16
60
10
78
13
63
66.3
D
72.805
-6.505
42.31503
1000115
Student15
16
56
15
62
10
59
60.4
D
72.805
-12.405
153.884
1000116
Student16
6
88
16
89
20
69
78.9
C
72.805
6.095
37.14903
1000117
Student17
9
75
12
63
19
90
76
C
72.805
3.195
10.20803
1000118
Student18
12
69
7
98
20
52
69.7
D
72.805
-3.105
9.641025
1000119
Student19
8
64
14
72
16
90
75
C
72.805
2.195
4.818025
1000120
Student20
15
62
6
88
13
83
75.05
C
72.805
2.245
5.040025
1456.1
1090.605
The average grade of the total grades is
72.805
C
Standard deviation of the toal grade is
7.38446
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.