Hi!
I have a project similar to the attached spreadsheet that I made up as an example..
Basically, I am putting together a project to show the best brain health out of about 20 different groups.. I am using over 50 factors to determine. In the example spreadsheet, I have a few factors listed on the spreadsheet.
I have indexed each weighted factor (Sleep, Fruits/Veg, Mental Distress, etc.) for each group. Next, I want to index each Category (Diet, Physical, Mental, Social) based on their weighted value. What would be the best way to go about indexing each category?
Would it be best to divide the Factor weight value by the Category weight value (to equal 100%) and then multiply each index by that and then add them up?
Attached is an example.. Please let me know which is correct if you know.
Moderator Note: The attached .XLXS file (zipped spreadsheet) passed security scan at virustotal.com
I have a project similar to the attached spreadsheet that I made up as an example..
Basically, I am putting together a project to show the best brain health out of about 20 different groups.. I am using over 50 factors to determine. In the example spreadsheet, I have a few factors listed on the spreadsheet.
I have indexed each weighted factor (Sleep, Fruits/Veg, Mental Distress, etc.) for each group. Next, I want to index each Category (Diet, Physical, Mental, Social) based on their weighted value. What would be the best way to go about indexing each category?
Would it be best to divide the Factor weight value by the Category weight value (to equal 100%) and then multiply each index by that and then add them up?
Attached is an example.. Please let me know which is correct if you know.
Moderator Note: The attached .XLXS file (zipped spreadsheet) passed security scan at virustotal.com
Last edited by a moderator: