1 Reply Latest reply on Nov 1, 2017 1:52 PM by Amber Loranger

    Hot to calculate the standard deviation for a distribution?

    Tony Fahd

      Hello, i am attaching a workbook that has list of my customers and their cost. i have a category filter. i like to get the standard deviation for the list of my customers by category.

       

      sheet 2 has each customer and their cost. I like to get the standard deviation for that list by category.

       

      sheet 3 has my category only and average cost by category. how can i get the standard deviation for each category?

       

      what is the best way to do this? thanks!