Problem 44960. Rescale Scores

Created by Pooja Lalan

Solve Later

{"relationships":[{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/document","targetMode":"","relationshipId":"rId1","target":"/matlab/document.xml"},{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/output","targetMode":"","relationshipId":"rId2","target":"/matlab/output.xml"}],"parts":[{"partUri":"/matlab/document.xml","relationship":[],"contentType":"application/vnd.mathworks.matlab.code.document+xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<w:document xmlns:w=\"http://schemas.openxmlformats.org/wordprocessingml/2006/main\"><w:body><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Each column (except last) of matrix</w:t></w:r><w:r><w:t> </w:t></w:r><w:r><w:rPr><w:rFonts w:cs=\"monospace\"/></w:rPr><w:t>X</w:t></w:r><w:r><w:t> contains students' scores in a course assignment or a test. The last column has a weighted combination of scores across all the assignments and tests.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Replace the elements in the last column of this matrix with a GPA calculated based on the following scale:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[ Score      GPA    \n90 - 100   3 - 4      \n80 - 90    2 - 3      \n70 - 80    1 - 2      \n60 - 70    0 - 1      \nBelow 60     0]]></w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Assume that no student in this class has scored below 60. Also note that the mapping in the range [60, 100] is linear.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>See</w:t></w:r><w:r><w:t> </w:t></w:r><w:hyperlink w:docLocation=\"https://www.mathworks.com/help/matlab/ref/rescale.html\"><w:r><w:t>&lt;https://www.mathworks.com/help/matlab/ref/rescale.html</w:t></w:r></w:hyperlink><w:r><w:t>&gt;</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Example</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Input:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[   100  90  95  95\n    70  50  60  60\n    80  70  90  80]]></w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Output:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[   100  90  95  3.5\n    70  50  60  0.0\n    80  70  90  2.0]]></w:t></w:r></w:p></w:body></w:document>"},{"partUri":"/matlab/output.xml","contentType":"text/xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\" ?><embeddedOutputs><metaData><evaluationState>manual</evaluationState><layoutState>code</layoutState><outputStatus>ready</outputStatus></metaData><outputArray type=\"array\"/><regionArray type=\"array\"/></embeddedOutputs>"}]}

Solve

Solution Stats

8218 Solutions
1977 Solvers

Last Solution submitted on Feb 27, 2021

Last 200 Solutions

Problem Comments

8 Comments

8 Comments

Show 5 older comments

Kingfall on 11 Nov 2019

It appears the last column of the output from the problem statement should be 3.5; 0.0; 2.0 instead of 3.5; 0.0; 3.0, but the first test suite does have it correct.

Ansgar Elles on 28 Mar 2020

yes true, thank you

Pooja Lalan on 30 Mar 2020

Thank you! Modified the problem statement.

Nayuan Lian on 30 Jun 2020

Why doesn't it work?
function X = rescale_scores(X)
X = [X(1:end,1:end-1) (X(1:end,end).-60)./4]
end

东升李 on 23 Aug 2020

n = size(X,1);
for c = 1:n
X(c,end) = (X(c,end)-60)/10;
end

Li Ding on 12 Oct 2020

A little bit of math work will make your program much simpler. Grade 60-100 for GPA 0 - 4, this is a straight line! The equation for this straight line is GPA = 0.1*(grade-60). Don't forget to take care of negative GPAs.

Andres Felipe Villalba Cortes on 27 Dec 2020

function X = rescale_scores(X)
Y = X(:,end)
[m,n] = size(X)
a = 1
B = []
for p = 1:m
if 60 <= Y(a) < 70
c = (Y(a)-60)./10
B = [B;c]
a = a+1
elseif 70 <= Y(a) < 80
c = ((Y(a)-70)./10).*2
B = [B;c]
a = a+1
elseif 80 <= Y(a) < 90
c = ((Y(a)-80)./10).*3
B = [B;c]
a = a+1
elseif 90 <= Y(a) < 100
c = ((Y(a)-90)./10).*4
B = [B;c]
a = a+1
end
end
X = [X(:,1:end-1),B]
end

Jesús Martínez Santana on 16 Feb 2021 at 23:57

X(:,end)=mean(rescale(X(:,end-1),-6,4,'InputMin',0,'InputMax',100),2);

Don't forget the negative numbers.
Score GPA
90 - 100 3 - 4
80 - 90 2 - 3
70 - 80 1 - 2
60 - 70 0 - 1
50 - 60 -1 - 0
40 - 50 -2 - -1
30 - 40 -3 - -2
20 - 30 -4 - -3
10 - 20 -5 - -4
0 - 10 -6 - -5

Solution Comments

Solution 3184861

2 Comments

2 Comments

Amir Ebrahimi on 13 Oct 2020

Easy!

Sarker Ashraful Islam on 2 Jan 2021

X(:,end)=rescale(X(:,end),0,4,'InputMin',60,'InputMax',100);

Solution 2997286

Solution 2997271

Solution 2714379

1 Comment

1 Comment

Mrikwood on 20 Jul 2020

Although my method is stupid and complicated,it still works.
function X = rescale_scores(X)
rown=length(X(1,:));
cn=length(X(:,1));
for c=1:cn
if X(c,rown)>=90
A=rescale([90,X(c,rown),100],3,4);
X(c,rown)=A(2);
elseif X(c,rown)>=80
A=rescale([80,X(c,rown),90],2,3);
X(c,rown)=A(2);
elseif X(c,rown)>=70
A=rescale([70,X(c,rown),80],1,2);
X(c,rown)=A(2);
else
A=rescale([60,X(c,rown),70],0,1);
X(c,rown)=A(2);
end
end
end

Solution 2627062

1 Comment

1 Comment

Umur Ulas Harman on 29 Jun 2020

it is ridiculous but still, it works. feel free to improve it.

function X = rescale_scores(X)
t=zeros(size(X,1)+2,size(X,2));
adjustment=[60;100];
t(1:end-2,1:end)=X;
t(end-1:end,end)=adjustment;
initial_finals=rescale(t(:,end),0,4);
X(:,end)=initial_finals(1:end-2,:);

end

Solution 2585002

1 Comment

1 Comment

Piero Cimule on 19 Jun 2020

A= 60:0.1:100;
A_reescale= rescale(A,0,4);

for c=1:size(X,1);
for d=1:size(A,2);
if X(c,(size(X,2)))==A(d);
X(c,(size(X,2)))=A_reescale(d);
end
end
end

Solution 2232582

3 Comments

3 Comments

Saad on 24 Apr 2020

Please, what is wrong with the following answer
X = (X-60)/10;
thank u

SOUMYADEEP SENGUPTA on 25 Apr 2020

This would operate on the entire matrix X. However we want the GPA to appear only in the last column of X. So try by declaring another variable which would calculate the GPA and then replace the last column of X with this column vector.

Kanchan Gorde on 9 May 2020

We have to modify only last column of matrix X not an entire matrix so find GPA for that column only.

Problem Recent Solvers1977

Problem Tags

Community Treasure Hunt

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

Start Hunting!

Problem 44960. Rescale Scores

Solution Stats

Last 200 Solutions

Problem Comments

Solution Comments

Problem Recent Solvers1977

Suggested Problems

More from this Author13

Problem Tags

Community Treasure Hunt

Problem 44960. Rescale Scores

Solution Stats

Last 200 Solutions

Problem Comments

Solution Comments

Problem Recent Solvers1977

Suggested Problems

More from this Author13

Problem Tags

Community Treasure Hunt

Players