Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.image text in transcribed

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 53

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions