NotSoBright95
New member
- Joined
- Aug 24, 2022
- Messages
- 2
*****HI! Please note, you don't see my table w/ the data because I had to leave it as a comment bc it was too large to post in the thread! The comment is awaiting mod approval***and I was unable to figure out how to attach an excel file so had to post it as a comment. Sorry, per my user I'm truly not so bright - but always trying to learn 
Hi,
I have a data set I'm trying to analyze. I put it into a pivot table in excel so what we see below are the responses from 68 customers based on if they were "Unsatisfied" with services or "Satisfied".
I'm showing how many times each customer was Unsatisfied or Satisfied by both percentage and volume, all numbers are being show as "% of row total".
Now, I want to analyze this data and see what story it's telling, namely by trying to ID the customers who have "Unsatisfied" percentages that are much higher than the average by stating the SD in relation to the mean. But I want to look at it from the perspective of taking into account those whose overall volume is high (I still haven't considered what should be deemed high...I may take the average for this but, for example, I wouldn't likely care about someone like customer 33 who has an unsatisfied % of 88.9 because their overall volume is only 9. I would care more about someone like customer 6 whose unsatisfied % is 44.19% with an overall volume of 43).
Can someone please confirm if my logic is correct?
I believe I should do the following:
1. Find Standard Deviation of the % of Unsatisfied Column (which is ~ 21%)
2. Find Average of the % of Unsatisfied Column (which is ~35%)
3.Then...idk what to do next
I think I need to look at it from the perspective of which customers have Unsatisfied percentages that are the furthest from the mean...but how would I do that by taking into account SD?? I'm trying to state the SD in relation to the mean??
Idk, I'm just trying to be as statistically accurate as possible.
Hi,
I have a data set I'm trying to analyze. I put it into a pivot table in excel so what we see below are the responses from 68 customers based on if they were "Unsatisfied" with services or "Satisfied".
I'm showing how many times each customer was Unsatisfied or Satisfied by both percentage and volume, all numbers are being show as "% of row total".
Now, I want to analyze this data and see what story it's telling, namely by trying to ID the customers who have "Unsatisfied" percentages that are much higher than the average by stating the SD in relation to the mean. But I want to look at it from the perspective of taking into account those whose overall volume is high (I still haven't considered what should be deemed high...I may take the average for this but, for example, I wouldn't likely care about someone like customer 33 who has an unsatisfied % of 88.9 because their overall volume is only 9. I would care more about someone like customer 6 whose unsatisfied % is 44.19% with an overall volume of 43).
Can someone please confirm if my logic is correct?
I believe I should do the following:
1. Find Standard Deviation of the % of Unsatisfied Column (which is ~ 21%)
2. Find Average of the % of Unsatisfied Column (which is ~35%)
3.Then...idk what to do next
I think I need to look at it from the perspective of which customers have Unsatisfied percentages that are the furthest from the mean...but how would I do that by taking into account SD?? I'm trying to state the SD in relation to the mean??
Idk, I'm just trying to be as statistically accurate as possible.