Right now im trying to make average grades on matlab from a chart on excel. How do I say on matlab the hw row is 15% of my final grade and the test is 30%.

1 次查看（过去 30 天）
Collin Kerr
Collin Kerr 2016-3-8
评论： Jonathan Azarani 2016-3-23
clc A = xlsread('Joke.xlsx')
B = mean(A(1:42,1))
C = mean(A(1:16,2))
D = mean(A(1:3,3))
E = mean(A(1:1,4))
F = mean(A(1:1,5))
G = mean(A(1:1,6))
M = mean(A)
Z = mean(M)
prompt = 'What is your name?';
N = input(prompt,'s');
X = sprintf('%s your current grade in the class is %0.0f.',N,Z);
disp(X)
I need to some how say E which is tests taken are 30 percent of the total grade, and D which is hw is 10, etc.. for the others

请先登录，再回答此问题。

采纳的回答

Chad Greene
Chad Greene 2016-3-8
If E is worth 30% of the final grade and D is worth 10% of the final grade,
FinalGrade = A*Aweight + ... + D*0.1 + E*0.3 + ...
for a total of 100%

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by