In MatLab The excel file contains the grade for 3 homeworks

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]

Solution

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