필터 지우기
필터 지우기

Letters from Answer Key to Percentage?

조회 수: 2 (최근 30일)
Anne Nguyen
Anne Nguyen 2019년 10월 27일
답변: David Hill 2019년 10월 27일
The answer key is:
D B C B A C B D D B B A B B A D C % this from G2:W2 in an Excel Spreadsheet
While (for example), Student 1's answers are:
A A B C C B A B A B B A B B A B B % this is from G3:W3 in an Excel Spreadsheet
How do I convert the student's answers to a percentage based on their answers vs the answer key?
What I have so far is:
multAns = cell2mat(txt4); % txt4 was the student's answer
ansKey = cell2mat(txt1); % txt1 was the answer key
multipleChoiceScore = scoreMult./ansKey;
Any help would be appreciated. Thank you very much!

채택된 답변

David Hill
David Hill 2019년 10월 27일
percentCorrect = 100*sum((multAns-ansKey)==0)/length(ansKey);%assumes every question was answered

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

제품

Community Treasure Hunt

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

Start Hunting!

Translated by