Standard Deviation or Percentile?

[Julia Gold]

Hi,

I have a big data set of restaurant data with a few different categories (food, labor, M&R) and I want to great a table that has the categories down one side, percentages going across (25, 50, 75, 95%). The calc I am trying to do would be "25% of all restaurants labor are $X away from the average of labor." Then "50% of restaurants labor are $x from the labor." Etc.

Thank you so much in advance! I have be trying to do this for over an hr now.

Best,
Julia

 

[Aladin Akyurek]

Hi,

I have a big data set of restaurant data with a few different categories (food, labor, M&R) and I want to great a table that has the categories down one side, percentages going across (25, 50, 75, 95%). The calc I am trying to do would be "25% of all restaurants labor are $X away from the average of labor." Then "50% of restaurants labor are $x from the labor." Etc.

Thank you so much in advance! I have be trying to do this for over an hr now.

Best,
Julia

Would you post a tiny sample (no more than rows) of data, perhaps along with the expected results?