Average Rating | Community
Skip to main content
Answered

Average Rating

L

I have short post-training evaluation that gathers some information at the end of each week of training in the form of 

  • 2 questions that gather a Rating (0-5)
  • 3 questions that get General feedback 

I have set up the integration with Excel and need to do a couple things: 

  • Calculate the average of the ratings for each individual week
  • Accumulate all of the data gathered (all weeks) to find an overall average

Here is a copy of the typeform if you would like to take a look: 

 

 

Best answer by john.desborough

​@Liz  ​@LMc_Omaha  - that stuff that is pure excel calculation

  • define a look up table to use to establish data ranges for ‘weeks’ 
  • run a macro that looks up the submissions in a specific week and write it into an answer table
  • divide the total score (sum) by the count of records in that week. 

that should be simple enough to do in excel.. 

des

View original

5 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 14984 replies
  • March 21, 2025

Tagging ​@john.desborough in case he has any handy ideas on figuring out the average!

Life is a series of awkward moments separated by snacks.
john.desborough
Forum|alt.badge.img+6
  • john.desboroughCertified Partner
  • Certified Partner & Champion
  • 5304 replies
  • Answer
  • March 21, 2025

​@Liz  ​@LMc_Omaha  - that stuff that is pure excel calculation

  • define a look up table to use to establish data ranges for ‘weeks’ 
  • run a macro that looks up the submissions in a specific week and write it into an answer table
  • divide the total score (sum) by the count of records in that week. 

that should be simple enough to do in excel.. 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
L
1 person likes this
  • L
    LMc_Omaha
L
  • LMc_Omaha
  • Author
  • Explorer
  • 1 reply
  • March 21, 2025
john.desborough wrote:

​@Liz  ​@LMc_Omaha  - that stuff that is pure excel calculation

  • define a look up table to use to establish data ranges for ‘weeks’ 
  • run a macro that looks up the submissions in a specific week and write it into an answer table
  • divide the total score (sum) by the count of records in that week. 

that should be simple enough to do in excel.. 

des

Thank you ​@john.desborough 

So, if I’m understanding you, the average that I’m trying to find will take place in the exported Excel file and not within Typeform, itself? 

If so, I’m all set. Sounds like I was overcomplicating it. 

Liz
1 person likes this
  • Liz
    Liz
john.desborough
Forum|alt.badge.img+6
  • john.desboroughCertified Partner
  • Certified Partner & Champion
  • 5304 replies
  • March 21, 2025

​@LMc_Omaha - you could calculate the average for a single form by using logic rules, but if you are not showing it to the user in an ending or elsewhere in the form, you should do it in the excel sheet. 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Liz
1 person likes this
  • Liz
    Liz
Grace
Community Team
Forum|alt.badge.img+5
  • Grace
  • Community Advocate
  • 2673 replies
  • April 7, 2025

Hey ​@LMc_Omaha let us know if you were able to get all your calculations sorted, hopefully ​@john.desborough’s suggestions helped 😊

If cauliflower can become pizza, you my friend can do anything

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs