Need MATH help with Google Sheet to constrain a range of data samples to 0-5 value
Budget: $30 – $250 USD
Looking for someone good at MATH & Google Sheets and understands working with ranges & value constraints for graphing. This should be less than 1 hour for some who knows what they are doing. You should be able to see the problem and already know what is needed.
I have a set of data that needs to be graphed. The data was sampled from a source that was not constrained in any way. The values can be from 0.1 to 70 or higher. The problem is the data needs to be represented on a 0-5 scale. See: sheet-unmodified.png
I did a frequency analysis and selected the top 250 samples. See: Sheet-sample-bracket.png
Scores 0.1 - 0.8 need to be converted a value 0.1 - 1.0
Scores 0.81 to 1.8 need to be converted a value 1.01 -2
Scores 1.81 to 3.6 need to be converted a value 2.01 -3
Scores 3.61 to 8.6 need to be converted a value 3.01-4
Scores 8.61+ need to be converted a value 4.01 -5
I am not sure what math/formulas to get modify the data to constrain to a 0-5 continuum
There are 3 sets of 8 number that need to be modified to a 0-5 scale: see sheet-mods-needed.png Once this is done, the graphs will be showing data on 0-5 continuum.
A view-only copy of the sheet is here: https://docs.google.com/spreadsheets/d/1bO1_0gdFgUqaDJ_3YSuLz5SE3aOQbCZWGv9SUm0uJ-A/edit#gid=824901007
To show that you read this, put the name of your favorite math class as the first word in your bid. This will prove to me you read my posting and did not spam me. It is worth $50 to get this done quick. Bids over that will be ignored.
I have a set of data that needs to be graphed. The data was sampled from a source that was not constrained in any way. The values can be from 0.1 to 70 or higher. The problem is the data needs to be represented on a 0-5 scale. See: sheet-unmodified.png
I did a frequency analysis and selected the top 250 samples. See: Sheet-sample-bracket.png
Scores 0.1 - 0.8 need to be converted a value 0.1 - 1.0
Scores 0.81 to 1.8 need to be converted a value 1.01 -2
Scores 1.81 to 3.6 need to be converted a value 2.01 -3
Scores 3.61 to 8.6 need to be converted a value 3.01-4
Scores 8.61+ need to be converted a value 4.01 -5
I am not sure what math/formulas to get modify the data to constrain to a 0-5 continuum
There are 3 sets of 8 number that need to be modified to a 0-5 scale: see sheet-mods-needed.png Once this is done, the graphs will be showing data on 0-5 continuum.
A view-only copy of the sheet is here: https://docs.google.com/spreadsheets/d/1bO1_0gdFgUqaDJ_3YSuLz5SE3aOQbCZWGv9SUm0uJ-A/edit#gid=824901007
To show that you read this, put the name of your favorite math class as the first word in your bid. This will prove to me you read my posting and did not spam me. It is worth $50 to get this done quick. Bids over that will be ignored.