1 Reply Latest reply on Jul 20, 2019 9:58 PM by Hari Ankem

    Z-Scores: Comparing Groups Averages to Overall Average

    Alex  Bourdeau

      Hello Everyone

       

      Please see my attached workbook.

       

      The goal is to compare each college's average satisfaction score (on the subscale AS WELL AS item level) to the overall average satisfaction score. Additionally, I want to know if these score differ significantly. I have been using guidance from this link to calculate z-scores. However, I am not quite sure how to get beyond comparing each college to the other. I want to compare each colleges individual average scores to the overall average score for all colleges. Maybe z-scores aren't the answer?

       

      Thanks for the help!