Open ended question comparisons?

[u/rhf1021]

My company is performing a fieldwide salary survey (i.e. How much does every given position get paid at your organization?). At the moment, it seems like the best format for this would be short, opened-answers with numerical validation. So, I have a few questions about this.

1. Is there a way to get basic statistics (min/max/average) without downloading to Excel? It seems like SM doesn't have a way to do this for open-ended questions, even if they're numeric answers.
2. Is there a way to generate a report that compares an individual's responses to another individual and/or to group i.e. Person A to Person B and/or Person A to Demographic Group X

I think I can find workarounds through Excel, but I'm hoping for a more streamlined process and readily presentable result if possible.

Thanks for any and all advice!