Hello everyone!
First, apologies for the 'Descriptive title'... I had difficulty summarizing what I was going for...
Basically, I'm trying to generate a single value using results given on a survey, which asked participants to rate five items on a scale of 1-5. The survey also asked for an alias, which I am using as a reference between the 'Summary' page (where I want my single value to appear) and the 'Raw Data' tab, where the survey results are kept. To make things a bit more complicated, I have also decided to give each of the scaled-items (originally a value out of 5), a different weight. I think I have a solid equation figured out for this, but I'm having issues getting the correct data to populate the formula from the 'Raw Data' sheet. The equation, simplified, is as follows:
z = 1/9*(xa+xb) + 1/2*((xc/20)+xd+xe)
Where:
z = generated value using alias's as a reference to pull data into the equation below
and
xa-e = values given on the survey, stored on the 'Raw Data' tab. Feel free to get rid of the x/superscript and instead just use a-e to simplify things.
Thanks in advance for all of your help, everyone, please let me know if you could use any more info.
Bookmarks