James bolton
Member
Hi,
Probably more a maths question but any help would be appreciated - racking my brain with this.
I have attached a spreadsheet because I feel this is quite complicated to explain.
Basically I have a list of area numbers and associated costs. For Area the Min is 3 and the Max is 2658
I have split it into 10, based on steps of 266 ((2658 - 3) / 10) but - it doesn't give me an even count. The data is heavily weighted towards the 2nd point ( 3 & 266 ) - this makes up 45% of the full data - the 2nd half of the table (points 5-10) account for only 20% of the full data - and I would like to create a way that it (dynamically adjusts) to create an even count for each 10 datapoints.
There is also a chart in here to visualize this - the ideal chart will have a straight line for count - for each step in the 10 steps there should be an even number of datasets in that category.
Please let know if I have explained this badly.
Probably more a maths question but any help would be appreciated - racking my brain with this.
I have attached a spreadsheet because I feel this is quite complicated to explain.
Basically I have a list of area numbers and associated costs. For Area the Min is 3 and the Max is 2658
I have split it into 10, based on steps of 266 ((2658 - 3) / 10) but - it doesn't give me an even count. The data is heavily weighted towards the 2nd point ( 3 & 266 ) - this makes up 45% of the full data - the 2nd half of the table (points 5-10) account for only 20% of the full data - and I would like to create a way that it (dynamically adjusts) to create an even count for each 10 datapoints.
There is also a chart in here to visualize this - the ideal chart will have a straight line for count - for each step in the 10 steps there should be an even number of datasets in that category.
Please let know if I have explained this badly.
