How do you match elements in two matrices and call on the rest of the elements in the second matrix after matching?

2 views (last 30 days)
I have a survey with data that is entered on Excel. The data is entered on a scale of 1 through 5. There are 20 questions. The code is supposed to calculate the score of each person's survey by adding up all the numerical answers from the questions. There is a scoring guide with total scores ranging from 20 through 100. It also includes a measured value and a percentile value. After calculating the total scores of each survey, I want to match the scores from the calculations to the scoring guide. Some of the scores may not match because they are too low, so I want to enter a '0' for those scores. For the scores that do match with a value on the scoring guide, I want to display the score along with the measured value and percentile. This is my code so far:
Data = xlsread('OPUSFunctionalStatusData.xlsx');
TotalScore = zeros(39,1);
for i = 1:39
TotalScore(i) = sum(Data(i,5:end));
end
%Match resulting scores from loop to the scoring guide.
Guide = xlsread('OPUSFunctionalStatusScoringGuide.xlsx');
Match = find(ismember(Score,Guide(:,1)))
%Finds which scores match with a value on the scoring guide.
The data file has 24 columns. The first 4 columns are for identification purposes. Columns 5 through 24 contain the actual data from the survey which is what is needed to calculate the scores. The resulting scores are displayed in a one column vector. The scoring guide contains scores from 20 through 100 with 3 columns (Total score, Measured value, and Percentile). How do I match the calculated scores to the scoring guide and call on the Measured value and Percentiles to display them all together? Any help is appreciated. Thank you!

Answers (0)

Categories

Find more on Migrate GUIDE Apps in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!