In this post you will take that data and have the spreadsheet do the work for you.
I decided to use numerical data in my example. I used 1 for yes and 0 for no. This could then be calculated in a numerical form later on using the average function.
In the 1 minute and 47 second video embedded below you will see how to take the spreadsheet that the Google Forms collects and then select a cell (somewhere you feel appropriate). In this example I used averages for the data collection.
- In the sheet select Insert > Function > Average
- Make sure to select the cells you want to include
- Even include future dates as the sheet will collect your data for you