If I am creating a survey with ranking questions (i.e. Rate how much you liked this class from 1-5), can I export the data in a way that ONLY shows the average of all student responses? I don’t need to see individual answers. Thank you for your help.
If you don’t need to see the individual responses, you can create a report that shows the aggregated results. This report could then be exported as an Excel file.
The purpose of the EXPORT function is to create a data file containing the individual responses so they can be analyzed in an external program such as MS Excel. There is no export option that will replace each individual’s response with the average of all responses.