As per the spreadsheet located at: https://drive.google.com/file/d/1B9s5sQucM8EWZpDNDWx9t4TSCRNvGa8Q/view?usp=sharing
I want to give each user the utmost suited film or genre (I think genre might be easier?) to them as a recommendation in the ratings tab, I have been trying to analyse the data and then use the analysis toolpak to perform a pairwise comparison to achieve this but have been struggling to do it generally, I keep getting stuck or can't quite figure out for example what I am meant to be putting in the options for 't-test: paired two sample for means' is this even the right way to be going about this?
Any help or clarification to achieve my aim here would be of much help.
More specifically my aim is to literally recommend films or genres or both if possible to each of the 26 users (just noticed on that version I have shared there is only 10 users on the ratings tab there should be 26) based on the data generated/provided by each user for each of the 100 films in the nonrandomdata tab.
I want to give each user the utmost suited film or genre (I think genre might be easier?) to them as a recommendation in the ratings tab, I have been trying to analyse the data and then use the analysis toolpak to perform a pairwise comparison to achieve this but have been struggling to do it generally, I keep getting stuck or can't quite figure out for example what I am meant to be putting in the options for 't-test: paired two sample for means' is this even the right way to be going about this?
Any help or clarification to achieve my aim here would be of much help.
More specifically my aim is to literally recommend films or genres or both if possible to each of the 26 users (just noticed on that version I have shared there is only 10 users on the ratings tab there should be 26) based on the data generated/provided by each user for each of the 100 films in the nonrandomdata tab.
