You are given an data file(project data.xls), which contains the grades for the past fours terms: 2016fall(sheet 1), 2016summer(sheet 2), 2016winter(sheet 3) and 2015fall(sheet 4). The first column is the student ID, then follows three assignments, midterm and final.

GRADE GRADE POINT PER CENT RANGE DESCRIPTION A+ 9 90-100 Exceptional A 8 80-89 Excellent B+ 7 75-79 Very Good B 6 70-74 Good C+ 5 65-69 Competent C 4 60-64 Fairly Competent D+ 3 55-59 Passing D 2 50-54 Marginally Passing E 1 (marginally below 50%) Marginally Failing F 0 (below 50%) Failing

a) The final mark for each student is calculated according to the following rules: Each assignment is worth 5%, midterm is worth 40% and final is worth 45%, and the final letter grade is calculated above.

(b) Report standard deviation based on the final marks for each term, and compare them for all four terms graphically.

(c) Report the grade distribution based on the letter grade, i.e., the groups based on the letter grade, and make comparison for all four term graphically.

(d) Can you find a curve/math function can best fit the grade distribution for each term? if so, plot the curves/math functions for all the terms and illustrate them in one figure.

(f) Write a menu driven program to illustrate above analysis on grades for four terms.

project data.xlsx below

UPDATE

=====================================

Write the answer using matlab and please show your work. Thank You. Last column final isnt the average of the marks but the exam mark. Thus the final mark in the questions are the average of the 5 marks(A1 A2 A3 Mid and final).

Term 1

=========================================================

Student ID	A1	A2	A3	Midterm	Final
208940146	79.61	66.88	82.28	97.63	90
211751425	57.36	44.15	76.89	58.56	74.16
217552682	76.62	97.9	52.18	51.85	70.58
209382010	68.83	84.21	82.63	78.2	77
208748369	85.88	70.86	87.28	70	84.4
214923698	33.73	92.78	75.42	65	52.06
209358209	75.09	53.3	62.1	79.06	65
217216546	35.66	89.58	61.76	68.4	56.25
209330240	40.77	14.47	71.96	51.13	47.58
209962089	53.08	36.84	61.52	69.84	45
209748613	79.01	69.27	70.77	47.81	46.5
204589375	78.2	58.41	76.56	88.86	87.93
201711045	93.51	83.35	53.1	44.54	73.36
201347666	69.16	84.62	67.19	56.24	52.33
217767818	58.92	55.18	71.68	57.76	58.05
204663353	74.71	96.45	69.92	62.55	93.46
217231914	99.37	75.69	83.47	76.06	84.68
214234701	78.05	63.69	70.47	45.89	57.28
217456259	72.97	37.54	84.64	86.89	78.5
218760039	64.81	49.52	81.22	57.47	58.86
202793785	71.97	80.78	80.77	68.99	66.15
207878003	45.52	45.99	57.82	18.26	10.33
219611256	68.55	90.94	71.2	60.25	62.16
212895880	48.71	40.48	79.44	69.37	88.9
217928195	44.05	72.44	89.3	49.78	53.26
209644608	70.59	84.64	64.22	58.24	54.99
200281861	96.13	69.03	55.58	72.22	59.63
212457606	85.86	95.15	96.92	88.42	90.81
204621907	46.8	67.71	35.71	92.58	62.54
210548679	64.01	38.86	77.04	57.21	58.13
214499839	46.85	59	67.49	35.54	57.45
212148315	82.31	67.09	57.64	74.12	89.53
211767328	61.07	65.2	41.41	35.67	77.15
208668696	67.73	91.06	87.74	76.27	81.17
204883458	81.54	83.95	72.06	77.73	69.38
208579207	76.52	51.66	83.3	74.68	64.5
200203549	76.03	75.5	72.51	64.74	85.24
212176428	68.19	19.54	62.3	70.88	85.99
219159503	97.61	55.23	89.74	72.14	56.79
201908930	70.49	74.41	76.09	72.13	75.21
200711811	49.1	55.28	68.17	37.27	47.15
217724701	98.43	53.39	77.54	86.45	78.54
204938827	74.55	70.26	51.75	67.85	55.58
200178301	73.8	71.36	72.69	66.62	77.93
216298405	71.5	98.59	72.27	62.07	78.08
202809989	57.69	91.14	74.91	65.71	69.25
217597328	41.6	84.98	41.16	65.35	85.73
201907536	77.02	56.68	64.24	72.69	67.5
207051202	35.77	49.68	34	52.83	18.97
211868411	84.04	53.89	48.66	40.42	61.07
211703632	59.19	92.22	74.22	64.41	79.78
213353635	57.34	83.25	53.68	69.47	75.3
212960542	54.81	82.31	57.65	55.19	45.51
208667381	85.43	57.77	73.39	84.64	93.44
202795175	51.46	71.43	62.62	61.57	71.24

Term 2

========================

Student ID A1 A2 A3 Midterm Final 234448771 61.58 79.01 86.49 78.6 59.98 235838553 71.97 97.68 56.69 73.69 81.67 232896759 78.79 74.77 89.12 81.42 89.41 231338061 85.84 90.79 74.08 70.22 79.34 238406615 57.63 74.15 56.1 76.79 69.94 233314484 70.88 76.18 68.59 74.13 75.9 237697850 46.11 76.97 54.12 89.19 77.37 234621311 70.48 68.27 64.29 49.77 23.68 248186204 90.31 91.74 98.4 89 93.86 248170432 52.64 63.71 85.61 85.51 73.81 239535273 75.87 33.67 66.62 76.11 86.46 249845042 84.42 83.15 61.45 64.14 68.1 247654543 89.51 77.39 71.49 75.66 55.22 231476596 60.19 68.62 58.94 53.99 55.31 241121650 58.45 59.55 78.95 51.21 55.49 244971589 85.57 62.58 69.89 72.41 80.07 247998427 65.68 71.14 70.53 72.67 71.02 242208619 69.19 64.61 64.14 57.96 53.13 234131309 81.41 66.03 77.01 72.76 94.6 243264625 48.42 64.13 65.89 57.8 49.43 233153533 77.52 63.37 66.67 65.39 43.01 245870311 77.87 67.57 84.57 54.27 65.53 235446947 96.48 86.69 87.36 84.7 84.13 236641715 87.32 65.9 77.66 81.17 61.46 246481102 61.94 60 81.66 55.6 66.85 224569445 61.38 72.48 79.11 50.65 58.57 235391203 83.29 85.12 87.89 85.49 91.86 234687255 94.25 89.91 76.9 81.02 81.92 247539559 59.08 34.2 62.27 62.1 45.51 246922232 84.2 51.69 64.43 79.45 65.76 249311335 81.94 65.05 81.68 60.92 55.85 243485063 71.89 78.68 57.37 63.19 70.11 243455190 80.42 99.64 76.54 89.72 94 232948972 72.18 77.22 79.47 71.74 71.87 234746186 74.36 56.31 52.61 74.9 68.23 237657934 51.51 72.71 84.45 71.62 89.48 245812895 97.42 51.48 51.45 78.98 64.05 241016464 54.05 89.1 49.2 67.72 68.97 232023185 80.33 72.69 87.15 71.34 42.61 242119681 87.29 92.61 89.51 96.62 95.03 236601571 56.06 88.04 61.04 59.83 64.94 231854372 71.79 55.29 68.06 61.28 65.5 228756877 71.45 31.08 38.07 66.43 52.64 248949016 87.14 79.14 63.76 62.97 78.87 236891613 73.95 75.38 82.76 73.21 76.36 247164381 70.56 94.01 90.13 76.09 90.99 241885869 81.94 80.47 63.96 79.75 84.63 230015009 58.76 85.57 80.14 65.66 78.92 236840257 48.42 35.87 48.18 38.38 44.61 244891223 51.31 65.03 56.88 62.26 71.59 239270724 60.07 68.69 52.57 59.78 65.61 243422394 86.57 57.54 53.49 67.89 70.59 248455137 62.46 77.34 69.26 61.8 73.34 242341943 86.61 91.36 79.11 78.21 85.53 249053281 72.12 65.75 67.31 52.35 66.81 242639284 44.45 53.03 40.19 57.41 46.86 232556809 67.79 97.3 72.64 73.69 77.75

Term 3

Student ID A1 A2 A3 Midterm Final 222067648 78.37 74.65 80.43 82.12 81.64 224569445 53.7 50.2 43.19 32.48 42.78 223450985 75.43 69.06 64.2 64.23 63.77 224747052 41.61 94.21 59.86 53.95 61.97 229353346 84.54 61.22 57.07 69.84 46.22 229747141 55.24 50 72.96 79 87.34 226427522 65.53 74.67 72.08 53.2 68.52 224129934 62.12 57.69 47.39 63.48 52.98 222648669 60.96 76.79 75.98 70.41 84.01 223776329 62.88 70.28 60.47 70.22 73.09 229031509 48.44 60.44 88.7 43.3 53.5 229406653 86.47 73.46 53.31 77.07 68.02 228210608 99.57 85.23 68.71 46.76 95.23 228377486 89.18 96.47 89.16 89.87 92.74 229087379 63.7 89.21 85.22 73.95 70.4 222251397 91.37 95.64 95.09 85.92 92.51 222976002 45.47 15.01 54.27 45.11 64.26 223364653 25.32 42.11 49.95 41.12 59.46 225797643 67.33 57.4 68.71 61.09 77.73 220161781 94.1 80.86 58.74 84.28 91.46 222326091 93.42 88.96 76.88 79.67 86.64 223494983 85.52 96.9 92.98 84.63 90.34 226138203 76.83 97.03 75.4 67.18 64.22 220520869 35.91 33.7 85 43.28 56.5 221437999 61.22 67.31 70.04 68.24 71.94 226890754 53.7 67.34 63.72 37.6 59.17 225328154 96.45 73.16 89.7 82.49 87.55 224433835 67.91 89.95 85.23 73.55 72.6 228574178 69.02 83.96 61.55 54.62 68.67 224953168 60.79 68.71 47.76 70.55 60.02 221519371 56.22 59.41 49.19 63.96 60.15 224417109 82.33 63.46 71.88 83.32 91.48 228426396 84.74 79.09 52.86 70.97 75.36 207878003 58.99 54.1 45.94 67.15 50.11 228474396 86.46 89.22 78.72 88.22 72.7 226384591 42.58 49.45 57.66 47.17 41.46 228968307 56.86 72.6 66.03 61.8 65.03 228756877 62.42 88.21 68.11 38.6 22.38 207051202 60.64 55.73 61.5 76.38 45.67 225610713 81.7 93.9 79.18 84.47 78.99 229103496 77.34 68.89 92.18 78.03 85.96 221787017 84.2 89.37 81.54 63.86 62.4 227062556 57.61 52.11 70.22 51.54 51.11 222519718 71.56 65.28 66.83 67.26 72.8 220055803 93.44 78.49 93.82 41.95 63.06 224252014 89.57 85.04 85.38 61.67 77.19 227815881 75.83 83.57 79.59 66.67 62.61 228973128 81.39 70.55 35.89 57.59 42.77 223670705 91.87 73.94 70.62 86.1 84.21 221680232 73.76 56.43 75.74 69.02 51.02 228228118 61.57 86.79 89.9 70.28 61.96 220361892 77.47 99.7 59.66 75.72 75.11

Term 4

Student ID A1 A2 A3 Midterm Final 208940146 79.61 66.88 82.28 97.63 90 211751425 57.36 44.15 76.89 58.56 74.16 217552682 76.62 97.9 52.18 51.85 70.58 209382010 68.83 84.21 82.63 78.2 77 208748369 85.88 70.86 87.28 70 84.4 214923698 33.73 92.78 75.42 65 52.06 209358209 75.09 53.3 62.1 79.06 65 217216546 35.66 89.58 61.76 68.4 56.25 209330240 40.77 14.47 71.96 51.13 47.58 209962089 53.08 36.84 61.52 69.84 45 209748613 79.01 69.27 70.77 47.81 46.5 204589375 78.2 58.41 76.56 88.86 87.93 201711045 93.51 83.35 53.1 44.54 73.36 201347666 69.16 84.62 67.19 56.24 52.33 217767818 58.92 55.18 71.68 57.76 58.05 204663353 74.71 96.45 69.92 62.55 93.46 217231914 99.37 75.69 83.47 76.06 84.68 214234701 78.05 63.69 70.47 45.89 57.28 217456259 72.97 37.54 84.64 86.89 78.5 218760039 64.81 49.52 81.22 57.47 58.86 202793785 71.97 80.78 80.77 68.99 66.15 207878003 45.52 45.99 57.82 18.26 10.33 219611256 68.55 90.94 71.2 60.25 62.16 212895880 48.71 40.48 79.44 69.37 88.9 217928195 44.05 72.44 89.3 49.78 53.26 209644608 70.59 84.64 64.22 58.24 54.99 200281861 96.13 69.03 55.58 72.22 59.63 212457606 85.86 95.15 96.92 88.42 90.81 204621907 46.8 67.71 35.71 92.58 62.54 210548679 64.01 38.86 77.04 57.21 58.13 214499839 46.85 59 67.49 35.54 57.45 212148315 82.31 67.09 57.64 74.12 89.53 211767328 61.07 65.2 41.41 35.67 77.15 208668696 67.73 91.06 87.74 76.27 81.17 204883458 81.54 83.95 72.06 77.73 69.38 208579207 76.52 51.66 83.3 74.68 64.5 200203549 76.03 75.5 72.51 64.74 85.24 212176428 68.19 19.54 62.3 70.88 85.99 219159503 97.61 55.23 89.74 72.14 56.79 201908930 70.49 74.41 76.09 72.13 75.21 200711811 49.1 55.28 68.17 37.27 47.15 217724701 98.43 53.39 77.54 86.45 78.54 204938827 74.55 70.26 51.75 67.85 55.58 200178301 73.8 71.36 72.69 66.62 77.93 216298405 71.5 98.59 72.27 62.07 78.08 202809989 57.69 91.14 74.91 65.71 69.25 217597328 41.6 84.98 41.16 65.35 85.73 201907536 77.02 56.68 64.24 72.69 67.5 207051202 35.77 49.68 34 52.83 18.97 211868411 84.04 53.89 48.66 40.42 61.07 211703632 59.19 92.22 74.22 64.41 79.78 213353635 57.34 83.25 53.68 69.47 75.3 212960542 54.81 82.31 57.65 55.19 45.51 208667381 85.43 57.77 73.39 84.64 93.44 202795175 51.46 71.43 62.62 61.57 71.24