How do I use a ranking variable in Excel ? | Community
Skip to main content
Answered

How do I use a ranking variable in Excel ?

  • January 19, 2022
  • 3 replies
  • 108 views
V

Hello !

I’m getting difficulties to use the results of my ranking question in Excel :/

I don’t know how can I recreate the results shown in the summary (I need to for a school project).

Here’s how it looks in Excel

Should I divide it in several columns, separated by “,” ?

But then again it doesn’t work because I need to take into account two things:

  • The fact that every text will be replaced by a number 1-2-3-4-5 (that I can manage)
  • The fact that every number is also an order of importance (the fact that the response 4 is in the first column makes it the first most important one : 1).

I have zero idea of how can I code or replace the latter, or even combine it with the first series of number.

I’m also using SPSS as a way to calculate averages, etc. for the project.

Any (quick) help for a student in need please ? :)

Thanks !

Best answer by Liz

Hi @vicsalazar123 Yes, thank you! I think the easiest setup would be to connect the form to Google Sheets and use Document Studio to display this information how you would like. 

 

@kellywonder also just created this really cool custom option with her form, and while it shows a scoreboard, I think the setup could be similar to something you’d want to do!

 

 

View original

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • January 20, 2022

Hi @vicsalazar123 Thanks for stopping by the community! Could you provide a bit more information on how you’re trying to display the data? Are you looking to create a chart/graph/etc with all the ranking options? 

I’m not terribly familiar with Excel, but @john.desborough or @Paulo might be!

Life is a series of awkward moments separated by snacks.
V

Yes, a chart/graph/etc with all the ranking options, that would be ideal !

I would like to display :

  1. What’s the top feature (the one with the most #1 ndlr, the top grade)
  2. What’s inside each feature, what’s the detail of the grade (how many people graded 1-2-3-4-5 a feature)

Hope this helps :)

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • January 21, 2022

Hi @vicsalazar123 Yes, thank you! I think the easiest setup would be to connect the form to Google Sheets and use Document Studio to display this information how you would like. 

 

https://community.typeform.com/tips-inspiration-45/create-semi-automated-reports-with-typeform-and-google-data-studio-429

@kellywonder also just created this really cool custom option with her form, and while it shows a scoreboard, I think the setup could be similar to something you’d want to do!

 

 

Life is a series of awkward moments separated by snacks.
Gabi Amaral
1 person likes this
  • Gabi Amaral
    Gabi Amaral

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs