Question
At the end of the semester, the instructors for a Statics course compile their final grades into a single spreadsheet to determine the general performance
At the end of the semester, the instructors for a Statics course compile their final grades into a single spreadsheet to determine the general performance of students for their course. These instructors are responsible for ten sections of the course in total.
It is assumed that each section contains 49 students. The attached Excel spreadsheet contains data arranged in 10 columns where each column represents each section. As there are 49 students in each section, each column will also have 49 rows. Each number in each cell represents the final grade that a student has earned for the course.
Write a MATLAB script to do the following:
Import the entire Excel spreadsheet data into MATLAB
Compute the average final grade for each section
Compute the standard deviation of the final grade for each section
Compute the global average final grade (that is the average final grade of all 490 students)
Compute the global standard deviation of the final grade
Your MATLAB script must also complete the following tasks:
Display the average and standard deviation of the final grades for each section in the form of a table
Display the maximum and minimum final grades for each section on the same table
Plot a histogram of the data using the histogram function on MATLAB
Note 1: Ensure that you follow MATLAB naming rules for variable and file names
Note 2: Insert comments wherever appropriate for clarity of your program
Note 3: Your script must have no syntax errors; if it fails to run then no points will be given.
72 92 13 54 95 66 22 18 88 68 89 5 28 95 88 86 8 91 93 14 64 3 75 90 32 7 40 7 5 27 65 84 37 63 44 26 71 63 13 93 82 2 74 47 44 25 9 41 6 77 60 75 67 76 7 25 49 14 68 28 7 100 85 83 42 51 67 21 18 70 82 88 21 74 34 90 60 23 85 27 33 11 32 56 31 11 23 88 76 53 96 76 47 75 78 19 66 79 6 45 24 4 0 78 45 29 13 9 4 20 36 79 10 4 43 80 7 90 97 74 43 62 82 81 31 69 78 90 24 34 63 84 33 23 56 71 55 71 11 82 96 42 85 81 40 62 91 22 31 68 60 79 95 56 69 96 16 65 88 87 71 86 31 92 19 76 38 57 88 55 7 82 31 15 59 11 100 95 70 82 16 26 15 24 36 2 3 9 47 74 66 35 42 71 5 21 94 94 88 5 76 97 35 48 71 42 95 47 10 93 55 53 55 9 71 57 49 83 41 89 57 17 63 91 85 51 98 69 34 10 73 83 99 29 59 93 27 49 13 37 83 60 69 99 27 7 3 78 85 75 26 39 95 86 6 96 24 94 90 7 13 1 54 36 41 29 64 32 70 38 52 79 40 20 32 34 67 99 14 31 83 33 60 31 98 62 93 31 34 7 15 90 32 62 20 78 42 55 77 26 100 17 100 34 28 86 59 64 10 78 83 2 20 83 17 55 50 75 32 48 52 28 79 99 47 37 66 40 16 54 46 12 20 98 15 58 92 8 79 17 21 80 59 64 19 13 97 25 47 74 75 68 18 34 83 38 93 67 26 48 51 96 57 18 87 53 58 13 90 54 18 40 7 32 94 14 15 14 80 67 2 77 21 16 14 36 21 55 87 2 90 32 57 18 88 36 76 45 65 54 61 94 87 52 40 22 54 81 2 5 49 29 58 11 95 33 19 35 43 55 28 24 59 87 96 42 100 54 21 67 60 63 89 41 23 20 36 54 74 43 44 4 48 0 1 82 59 69 74 85 49 94 69 77 25 81 54 45 1 61 28 20 96 54 3 79 76 83 80 59 45 28 53Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started