MATLAB programming language**** At the end of the semester, the instructors for

Question

MATLAB programming language****
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 The Excel spreadsheet named HW22Data.xlsx which contains the simulated final grade data can be downloaded from Blackboard. MATLAB programming language****
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 The Excel spreadsheet named HW22Data.xlsx which contains the simulated final grade data can be downloaded from Blackboard.
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 The Excel spreadsheet named HW22Data.xlsx which contains the simulated final grade data can be downloaded from Blackboard.
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 The Excel spreadsheet named HW22Data.xlsx which contains the simulated final grade data can be downloaded from Blackboard.

Explanation / Answer

xl=xlsread("file.xlsx")
average=[]
mini=[]
maxi=[]
for i=1:10
average(i)=mean(xl.data(:,i)) % average of each section i.e column
Sc=std(xl,:,i)
mini(i)=min(x.data(:,i))
maxi(i)=max(x.data(:,i))
end
S = std(xl,0,2) %Calculates standard deviation of each row
g_average=mean(average) %Calculate average of all grades in excelsheet

%printing average,std deviation, maximum and minimum in table format
fprintf("Average Standard Deviation Maximum Minimum ")
for i=1:10

fprintf("%d %d %d %d ",average(i),Sc(i),maxi(i),mini(i))
end

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.