# Letters from Answer Key to Percentage?

조회 수: 2 (최근 30일)
Anne Nguyen 2019년 10월 27일
답변: David Hill 2019년 10월 27일
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 2019년 10월 27일
percentCorrect = 100*sum((multAns-ansKey)==0)/length(ansKey);%assumes every question was answered

댓글을 달려면 로그인하십시오.

### 카테고리

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