Find Jobs
Hire Freelancers

Need MATH help with Google Sheet to constrain a range of data samples to 0-5 value

$30-250 USD

Completed
Posted over 2 years ago

$30-250 USD

Paid on delivery
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: [login to view URL] I did a frequency analysis and selected the top 250 samples. See: [login to view URL] 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 [login to view URL] 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.
Project ID: 31247281

About the project

24 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Number theory. Hi there, I might be able to help. I have a PhD in mathematics from an American university and extensive experience with teaching/tutoring and research. I think i can do the task.
$50 USD in 1 day
5.0 (5 reviews)
3.2
3.2
24 freelancers are bidding on average $88 USD for this job
User Avatar
Geometry "Sir, I am Google Sheets, MAths, Excel VBA and Coding Advance Level Expert. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 4 years of experience from worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks and Sage expert. It is my my fifth month here and i have 100+ 5 stars reviews here here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, excel, QuickBooks and auditing related work with quality, efficiency and on reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar"
$50 USD in 1 day
4.8 (94 reviews)
5.7
5.7
User Avatar
Statistics hello sir i'd love to get involved if you need an expert in maths/google sheets you should contact me i am sure i can do this work on time please contact me.
$50 USD in 1 day
4.8 (50 reviews)
5.3
5.3
User Avatar
Hi , I am a mathematician , I understand how to work with ranges and value constraints for graphing, Contact me !
$100 USD in 7 days
4.6 (34 reviews)
4.7
4.7
User Avatar
Hello dear, We are group of professional expert and can do your task perfectly just text me so we can help you out with your task Kind regards
$30 USD in 1 day
4.9 (27 reviews)
4.4
4.4
User Avatar
permutation and combination! Hi, I can provide you with the formula which will be a nested ifs. Can further discuss on that. Even can create a custom function that will solve it automatically. Thanks and Regards, Sanjay.
$50 USD in 1 day
4.9 (3 reviews)
3.2
3.2
User Avatar
Hello, I just discovered about your project Need MATH help with Google Sheet to constrain a range of data samples to 0-5 value and I am ready to start immediately ! I am an expert in Mathematics, Excel and Google Sheets, so I am totally sure I can deliver Your project ! Please send a message so we can discuss more regarding this project. Thanks & regards
$250 USD in 3 days
5.0 (2 reviews)
2.9
2.9
User Avatar
Don't worry! I think here you are looking for someone to organized daily with new pdfs your google drive every day. I understand your project description. But I want to know more about your project. So, can we discuss more? I have great experience similar kind of this project so please come inbox. I am really confident that, I can do this with 100% accuracy and ready to start now! So, please take your time to discuss more on your project with me. Thank you.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
*Favourite maths class was of grade 11* Hi, I've read your project description and I'm confident about your project I can do perfectly. Please leave me a message on my chat so we can discuss the budget and deadline of the project. Thanks and regards, Fawad
$50 USD in 7 days
3.6 (1 review)
0.0
0.0
User Avatar
Hi, I have read the project and my favorite math teacher name is Suganthi.I have several years of experience in HR Analytics and have worked on many complex excel sheets. I would be able to deliver the requirement in a short span of time.
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Algebra was my favourite math class I checked the view only copy and I think I can qork on the values and finish in the next couple of hours Regards
$45 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Statistics & Probability! Hi there I checked the Google sheet, I can scale the dataset as you mentioned in detail. I'm an electrical engineer and have a good background in Mathematics and I can work with Excel and Google sheets very well. Hoping to hear from you in chat. Best regards.
$80 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Calculate mathematics Hi Dear! I already check your description with carefully and very interesting your project. I have a development experience of project like your project. I have more than 10 years of experience in software development, particularly around Excel VBA. If you give this project for me then you can get wonderful result on time. Hope to meet in chat box for will discuss more about project. Looking forward to hearing your reply. Thanks. Zhe X.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I am Saliya. I am interested in your job. I am expert in this field. So I think I can do this job very well & I can provide a good & Quality service to you. Thank you. Best regard,
$50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam, I am a Mathematic teacher with 10 years experience. I am interested in this project and proficient enough to complete it as per your requirement. Kindly share more details, I am willing to submit the sample work as well. Thanks Kanchana.
$40 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a professional data entry with great experience. I would be very happy to work on your document immediately. I always complete my work in a given time.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Oconomowoc, United States
4.9
251
Payment method verified
Member since Feb 16, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.