|
Post by AussieMeg on Jun 14, 2017 5:54:31 GMT
This is so confusing, please bear with me! We have been given 3 choices for our new office location (I am going to make up fake names for these places): Harford Ridley Dorset We had to number them from 1 (most preferred) to 3 (least preferred]. 120 people voted in total 48% chose Harford (therefore 58 people) 52% chose Ridley or Dorset as their #1 preferred location (62 people) ** The breakdown was not provided ** 55% did not want to move to Dorset 66% are in favour of moving to Ridley if their first choice (I guess this means Harford or Dorset) does not eventuate Those who chose Harford as their preferred choice (58 people), 91% (53 people) chose Ridley ahead of Dorset as their alternate preference Those who chose Dorset as their preferred location (unknown number), 91% chose Ridley ahead of Harford as their alternate preference 12% of people chose Ridley as their least preferred location (ie. their 3rd choice) Based on these figures  the decision has been made that we will be moving to Ridley. I think that they’ve fudged the figures to make it look like the majority of people want to move to Ridley. Why didn’t they give us the % of people who chose Ridley and Dorset as their first choice, instead just saying 52% collectively? Is anyone able to work out from the information given the following: What percentage of people chose Ridley as their first choice? What percentage of people chose Dorset as their first choice? How do they work out that Ridley is the preferred overall choice, when the majority voted for Harford? Or is it not possible to answer based on the info given?
|
|
|
Post by katlady on Jun 14, 2017 6:12:43 GMT
It is late and I don't want to try to run numbers  , but it does seem like Ridley came in second to Hartford. Why else would they combine the numbers for Ridley and Dorset? ETA - I don't think you can get actual numbers from all this. It says 55% did not want to move to Dorset but you can't tell if that includes people who voted for Harford. I think they went with the city that most people would not mind moving to, even if harford got the most votes for #1. Ridley seemed to be the most popular alternative choice of the three since 91% of those who voted for harford and Dorset picked Ridley as their second choice.
|
|
|
Post by gar on Jun 14, 2017 7:12:12 GMT
I shouldn't have bothered opening this thread 
|
|
|
Post by lesley on Jun 14, 2017 7:13:58 GMT
Isn't the answer 42? 
|
|
craftykitten
Pearl Clutcher
Posts: 4,304
Jun 26, 2014 7:39:32 GMT
|
Post by craftykitten on Jun 14, 2017 7:19:20 GMT
I can't work out the actual numbers, but if they weighted the results (e.g. 3 pts for most preferred, 2 pts for 2nd etc) then perhaps the second most preferred choice came out on top because the votes for first were split? I have a headache so I'm not sure I'm making sense. Other than that, I can't get past the fact you had a vote! I can't imagine any business here doing that 
|
|
|
Post by KiwiJo on Jun 14, 2017 9:08:21 GMT
Here's how I see it......
We know 58 chose Harford 1st. We know 80 chose Ridley 2nd (66% of 120 chose it if their 1st choice didn't eventuate, so they would have put it 2nd) We know 66 chose Dorset 3rd (55% of 120 didn't want to go to Dorset, so they would have put it 3rd)
We know that of the 58 people who put Harford 1st, 53 put Ridley 2nd. So that means 27 people put Dorset 1st. That's because we know 80 people overall put Ridley 2nd, and 53 of them put Harford 1st. Obviously We know that no-one who put Ridley 2nd also put it 1st, so the remaining 27 must have put Dorset 1st.
So now we have: 1st. 2nd. 3rd Harford. 58. Ridley. 80 Dorset. 27 66
Each of the rows and columns must add up to 120, so looking at the lines, 27 put Dorset 1st, 66 put it 3rd, so 27 put it 2nd. So now we have: 1st. 2nd. 3rd Harford. 58. Ridley. 80 Dorset. 27 27 66
From here it's just a matter at looking at a row or column that had 2 numbers and working out the 3rd (remember they must all add up to 120) so: 1st. 2nd 3rd Harford. 58. 13 49 Ridley. 35 80. 5 Dorset. 27 27. 66
So yes, more people voted for Harford as first choice, but far more voted for Ridley as 2nd choice. Where you are asked to rank choices rather than just selecting one of them, then there is usually a weighting amount given to each choice, as CraftyKitten said. And that is no doubt how Ridley comes out on top.
if it is 3 points for 1st, 2 points for 2nd, 1 point for 3rd, then the result would be; Ridley 270 points Harford 259 points Dorset. 201 points
(Man I hope this posts with the format intact, or I have some serious editing to do!)
ETA:- phew, it did keep the formatting!
Edit 2: Bugger. I just re-read the OP, and it says 12% chose Ridley as their 3rd option. That is 14 people, and my result shows only 5. well, it's bed-time now, and I have spent quite long enough on this, so I am going to bed, and let someone else correct my mistake(s). If I have nightmares about moving to Harford, Ridley or Dorset, it's all AussieMeg's fault!! 😜
|
|
|
Post by AussieMeg on Jun 14, 2017 9:26:12 GMT
OMG KiwiJo, you're either a freaking genius (compared to me anyway haha!) or you just wrote a big old pile of hogwash! Thank you so much for taking the time to do this. It still looks like mumbo jumbo to my poor little brain, but I will take your word for it, you sound like you know what you're talking about! I'm just pissed off, because I wanted to stay in Harford. If we move to Ridley I will have to catch a train instead of being able to drive, and that means an extra hour or more away from home every day. I guess work/life balance isn't really important to the powers-that-be.
|
|
|
Post by jennyap on Jun 14, 2017 9:26:37 GMT
I thought it could be done, but as I work through it some of the information seems to be contradictory. Either some of it is wrong, or some people didn't rank all three choices (is that what they mean by 55% did not want to move to Dorset?)
If I ignore this bit of info, which is the one bit I can't reconcile to everything else:
and I assume that all the votes were used, I get this (all in numbers of people) -
Ridley 1st 27; 2nd 79; 3rd 14 Harford 1st 58; 2nd 22; 3rd 40 Dorset 1st 35; 2nd 19; 3rd 66
If you use a simple weighted ranking where 1st place is worth 3 'points, 2nd is 2 and 3rd is 1, the ranked scores would be Harford 258, Ridley 253 and Dorset 209 each, so that can't be what they've used.
On the other hand, if you ignore the 3rd choices and look at just the top two, Ridley comes out top either on a weighted basis or even just on straight numbers (106 people picked Ridley as one of their top two versus only 80 people for Harford)
No guarantees any of that is correct of course, given the discrepancy I mentioned.
ETA corrected for some people I lost!
|
|
|
Post by AussieMeg on Jun 14, 2017 9:27:54 GMT
well, it's bed-time now, and I have spent quite long enough on this, so I am going to bed It's not even 9:30pm there!!
|
|
|
Post by KiwiJo on Jun 14, 2017 9:31:40 GMT
Very true, but it's been my first day back at work after being off sick, and I am exhausted! 
|
|
|
Post by AussieMeg on Jun 14, 2017 9:31:41 GMT
jennyap, my boss thinks that they calculated it this way: 48% of people chose Hartford (which is where our office currently is located) 52% of people chose Ridley or Dorset Therefore the majority of people wanted to move away from Hartford! I just think that they had already made up their mind that they wanted to move to Ridley (rents would be cheaper) so they fidaddled the numbers to show their desired outcome.
|
|
|
Post by jennyap on Jun 14, 2017 9:54:41 GMT
I followed much the same logic as KiwiJo , but in a slightly different order. Things we know: We know 58 chose Harford 1st. We know 66 chose Dorset 3rd (55% of 120 didn't want to go to Dorset, so they would have put it 3rd) We know 14 people chose Ridley 3rd (12% of 120) We know 79 people chose Ridley 2nd (66% of 120) So now we have:
| 1st | 2nd | 3rd | Harford | 58 |
|
| Ridley |
| 79 | 14 | Dorset |
| | 66 |
Each of the rows and columns must add up to 120, so looking at the columns, 14 put Ridley 3rd, 66 put Dorset 3rd, so 40 must have put Harford 3rd. So now we have:
| 1st | 2nd | 3rd | Harford | 58 |
| 40 | Ridley |
| 79 | 14 | Dorset |
| | 66 |
Then we can see that 58 people put Harford 1st and 40 people put it 3rd, so 22 people must have put it 2nd:
| 1st | 2nd | 3rd | Harford | 58 | 22 | 40 | Ridley |
| 79 | 14 | Dorset |
| | 66 |
Then we know that 79 people put Ridley 2nd and 14 people put it 3rd, so 27 people must have put it 1st.
| 1st | 2nd | 3rd | Harford | 58 | 22 | 40 | Ridley | 27 | 79 | 14 | Dorset |
| | 66 |
From here it's just a matter at looking at the remaining columns with 2 numbers and working out the 3rd (remember they must all add up to 120)
| 1st | 2nd | 3rd | Harford | 58 | 22 | 40 | Ridley | 27 | 79 | 14 | Dorset | 35 | 19 | 66 |
(Totally plagiarised from KiwiJo - couldn't be bothered to type it all out before!!) The fact that we come out with different results I think pretty much proves that the original info is incorrect in some respect.
|
|
|
Post by jennyap on Jun 14, 2017 9:56:51 GMT
AussieMeg it does seem that way based on how they've presented the numbers. But I also think it's the right decision - just looking at the 3rd place choices, moving to Ridley will piss off the least number of people!
|
|
AllieC
Pearl Clutcher
Posts: 3,129
Jul 4, 2014 6:57:02 GMT
|
Post by AllieC on Jun 14, 2017 10:09:15 GMT
My brain hurts just looking at that LOL. I have no idea of the numbers but I'm really sorry you are going to have to move and have a much longer commute.
|
|
|
Post by KiwiJo on Jun 14, 2017 11:22:02 GMT
I thought it could be done, but as I work through it some of the information seems to be contradictory. Either some of it is wrong, or some people didn't rank all three choices (is that what they mean by 55% did not want to move to Dorset?) If I ignore this bit of info, which is the one bit I can't reconcile to everything else: and I assume that all the votes were used, I get this (all in numbers of people) - Ridley 1st 27; 2nd 79; 3rd 14 Harford 1st 58; 2nd 22; 3rd 40 Dorset 1st 35; 2nd 19; 3rd 66 If you use a simple weighted ranking where 1st place is worth 3 'points, 2nd is 2 and 3rd is 1, the ranked scores would be Harford 258, Ridley 253 and Dorset 209 each, so that can't be what they've used. On the other hand, if you ignore the 3rd choices and look at just the top two, Ridley comes out top either on a weighted basis or even just on straight numbers (106 people picked Ridley as one of their top two versus only 80 people for Harford) No guarantees any of that is correct of course, given the discrepancy I mentioned. ETA corrected for some people I lost! I think you have it right. Why do you think that bit about about 91% of people who put Dorset first, doesn't fit? I think it could could be right with your figures. 91% is 32; so of the 79/80 people who put Ridley 2nd, 32 of them had put Dorset first. And I have realised my mistake - it was where I calculated that 27 people had put Dorset first. Yes, at least 27 people had put Dorset first, but I wasn't taking into account that some people who voted Dorset first had put Harford second. I really do think your calculations are correct.
|
|
|
Post by jennyap on Jun 14, 2017 11:59:17 GMT
KiwiJo if my numbers are correct 35 people put Dorset 1st. If 91% of them had Ridley second, that would be 32 as you say. We already know that 53 other people put Ridley second (the ones that had Harford first) which would be a total of 85 with Ridley second. That's too many - however you round it it's more than 66%, and would throw the rest off too.
|
|
seaexplore
Prolific Pea
 
Posts: 9,366
Apr 25, 2015 23:57:30 GMT
|
Post by seaexplore on Jun 14, 2017 14:38:23 GMT
Here's how I see it...... We know 58 chose Harford 1st. We know 80 chose Ridley 2nd (66% of 120 chose it if their 1st choice didn't eventuate, so they would have put it 2nd) We know 66 chose Dorset 3rd (55% of 120 didn't want to go to Dorset, so they would have put it 3rd) We know that of the 58 people who put Harford 1st, 53 put Ridley 2nd. So that means 27 people put Dorset 1st. That's because we know 80 people overall put Ridley 2nd, and 53 of them put Harford 1st. Obviously We know that no-one who put Ridley 2nd also put it 1st, so the remaining 27 must have put Dorset 1st. So now we have: 1st. 2nd. 3rd Harford. 58. Ridley. 80 Dorset. 27 66 Each of the rows and columns must add up to 120, so looking at the lines, 27 put Dorset 1st, 66 put it 3rd, so 27 put it 2nd. So now we have: 1st. 2nd. 3rd Harford. 58. Ridley. 80 Dorset. 27 27 66 From here it's just a matter at looking at a row or column that had 2 numbers and working out the 3rd (remember they must all add up to 120) so: 1st. 2nd 3rd Harford. 58. 13 49 Ridley. 35 80. 5 Dorset. 27 27. 66 So yes, more people voted for Harford as first choice, but far more voted for Ridley as 2nd choice. Where you are asked to rank choices rather than just selecting one of them, then there is usually a weighting amount given to each choice, as CraftyKitten said. And that is no doubt how Ridley comes out on top. if it is 3 points for 1st, 2 points for 2nd, 1 point for 3rd, then the result would be; Ridley 270 points Harford 259 points Dorset. 201 points (Man I hope this posts with the format intact, or I have some serious editing to do!) ETA:- phew, it did keep the formatting! Edit 2: Bugger. I just re-read the OP, and it says 12% chose Ridley as their 3rd option. That is 14 people, and my result shows only 5. well, it's bed-time now, and I have spent quite long enough on this, so I am going to bed, and let someone else correct my mistake(s). If I have nightmares about moving to Harford, Ridley or Dorset, it's all AussieMeg's fault!! 😜 Yep, 2 way logic tables was where my mind went. I have only taught it once so I wasn't sure how to get it all laid out.
|
|
seaexplore
Prolific Pea
 
Posts: 9,366
Apr 25, 2015 23:57:30 GMT
|
Post by seaexplore on Jun 14, 2017 14:40:11 GMT
I followed much the same logic as KiwiJo , but in a slightly different order. Things we know: We know 58 chose Harford 1st. We know 66 chose Dorset 3rd (55% of 120 didn't want to go to Dorset, so they would have put it 3rd) We know 14 people chose Ridley 3rd (12% of 120) We know 79 people chose Ridley 2nd (66% of 120) So now we have:
| 1st | 2nd | 3rd | Harford | 58 |
|
| Ridley |
| 79 | 14 | Dorset |
| | 66 |
Each of the rows and columns must add up to 120, so looking at the columns, 14 put Ridley 3rd, 66 put Dorset 3rd, so 40 must have put Harford 3rd. So now we have:
| 1st | 2nd | 3rd | Harford | 58 |
| 40 | Ridley |
| 79 | 14 | Dorset |
| | 66 |
Then we can see that 58 people put Harford 1st and 40 people put it 3rd, so 22 people must have put it 2nd:
| 1st | 2nd | 3rd | Harford | 58 | 22 | 40 | Ridley |
| 79 | 14 | Dorset |
| | 66 |
Then we know that 79 people put Ridley 2nd and 14 people put it 3rd, so 27 people must have put it 1st.
| 1st | 2nd | 3rd | Harford | 58 | 22 | 40 | Ridley | 27 | 79 | 14 | Dorset |
| | 66 |
From here it's just a matter at looking at the remaining columns with 2 numbers and working out the 3rd (remember they must all add up to 120)
| 1st | 2nd | 3rd | Harford | 58 | 22 | 40 | Ridley | 27 | 79 | 14 | Dorset | 35 | 19 | 66 |
(Totally plagiarised from KiwiJo - couldn't be bothered to type it all out before!!) The fact that we come out with different results I think pretty much proves that the original info is incorrect in some respect. Yes! Another 2 way (or is it 3 way? - LOL) table! I might have to steal this for my students next year. Won't need it until third Trimester tho so we won't be able to help ya out on this one.
|
|
|
Post by scrapmaven on Jun 14, 2017 15:22:12 GMT
I'm not the person you want to do your math problems. Trust me. It sucks that they are planning to move farther away from your house. Is this set in stone or is it still up in the air?
|
|
|
Post by AussieMeg on Jun 15, 2017 4:18:39 GMT
Thanks to all you smart people who have given this a crack for me - I'm seriously impressed! I'm not the person you want to do your math problems. Trust me. It sucks that they are planning to move farther away from your house. Is this set in stone or is it still up in the air? We are definitely moving, the building has been sold and we have to be out by next June. They need to start looking for a new office now because they can't leave it too late, and I assume we'll move quite a bit earlier than June. Funnily enough, it's not really that much further from home. We are currently in 'Harford' and 'Ridley' is the very next suburb, But there won't be any parking in the building or in the nearby streets (it's all 2 hour parking) so I will have to catch a train. That's what is going to cause me the extra hour+ in travel time.
|
|
|
Post by scrapmaven on Jun 15, 2017 4:21:12 GMT
That really irks me that they aren't moving to a place w/parking. It doesn't even make sense. I'm annoyed for you.
|
|
|
Post by katlady on Jun 15, 2017 4:54:04 GMT
No parking for 120 employees?? WTH?? 
|
|
|
Post by anniefb on Jun 15, 2017 6:10:10 GMT
No parking for 120 employees?? WTH?? That's very common here as well. Well it is available if you want to pay $25 per day  I prefer to catch the bus - $7 per day.
|
|