find a mathematic formula

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

We are measuring a sugar value with a refractometer during fermentation.

Due to the fact that alcohol is decreasing it influence the refractometer value and we do not get the right sugar content.

To compensate that we made measurements with other instruments to find a correction factor.

Of course depending on the start sugar value, the correction factor is different at each stage.

We need somebody who is able to find a formula to calculate the right correction factor for each start value and each step during fermentation.

We put the data from different start values into an excel sheet to see if it could be possible to find a formula. We are not mathematician so we need somebody who can find the formula for us.

Attached you can find a picture from the graphs with different start values and the measurements during the fermentation. To find the right formula you will get the whole excel sheet.

Please check the screenshots and if you think that you it is possible respectively you are able to generate a formula, contact me.

PS: If necessary we are able to provide further measurement sheets from other start values.

Data Processing Excel Mathematics Statistical Analysis Statistics

Project ID: #18031842

About the project

36 proposals Remote project Active 5 years ago

36 freelancers are bidding on average €168 for this job

schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid More

€250 EUR in 4 days
(428 Reviews)
8.3
sandroshubladze

Hello, I am Math Geek and Data Science Expert Please provide data you have to analyze and build desirable formulation in Excel for you If you will be interested, contact me Thanks & Regards

€294 EUR in 4 days
(151 Reviews)
8.2
Vlzinch

Hello, I'm sure I can help you. I have a Master degree in Math. You will be more than satisfied with my work. Pls contact me to discuss project details. Look forward to hearing from you! Kind regards, Vlad

€247 EUR in 2 days
(70 Reviews)
7.8
zekovicm

Hi there, I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and form More

€235 EUR in 3 days
(158 Reviews)
7.7
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m More

€60 EUR in 3 days
(279 Reviews)
7.2
dgled

Hi, I develop modules in Microsoft Excel by VBA. I built modules which enable you to manage transactions in a spreadsheet and to get immediate reports and info. The modules can upload external databases. There is a se More

€250 EUR in 3 days
(94 Reviews)
7.3
dvcontact

Hi, You won’t make the right candidate selection without knowing what your project on building a formula to calculate the right correction factor for each start value and each step during fermentation will look like. More

€250 EUR in 3 days
(65 Reviews)
6.8
jkaranm

Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Matt More

€294 EUR in 5 days
(45 Reviews)
6.9
suyashdhoot

Hi I am a very experienced biostatistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several c More

€500 EUR in 3 days
(150 Reviews)
7.2
dataexplorer

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor More

€60 EUR in 3 days
(20 Reviews)
4.8
Galata16

As an: - Bachelor of Applied Mathematics - Engineer in Statistics and Applied Economics - Microsoft Office Technician (Microsoft Graduate: MOS Diploma), - I have skills in programming language R, Python, SPSS and More

€50 EUR in 3 days
(19 Reviews)
4.1
abdulrahmanfci

I'm a software developer who uses mathematics and doing data analysis for around 5 years now. I used it in developing models for machine learning specifically, but also other problems generally. (check reviews on profi More

€50 EUR in 0 days
(9 Reviews)
4.2
Quantumarcel

Hi there, I saw the project that you posted and it looks quite interesting. I am sure that we could numerically find correction factors for this problem. In order for me to complete the task, could you specify wh More

€166 EUR in 3 days
(14 Reviews)
4.0
imrancae

Dear Employer I am an aerospace engineer and have PhD and postdoc in Applied Maths from Virginia Tech USA I have my research group working on modeling & simulation We can talk more on the requirement Looking More

€277 EUR in 15 days
(4 Reviews)
2.9
cheemaseerat

Being an Electrical Engineer, I have used several mathematical approaches and I can definitely look for the suitable formula / approach given the excel sheet.

€88 EUR in 3 days
(3 Reviews)
2.6
billpinder82

Good afternoon, my name is William. I am an Excel programmer with 10 years of professional experience. I have read your project and I think I can come up with a formula to solve the problem. I am currently on my mobil More

€150 EUR in 2 days
(3 Reviews)
2.6
samiahmetjunaid

Maybe we can do it. We speak German.

€250 EUR in 20 days
(1 Review)
2.3
dvdalon

Hello. I am a chemist with extensive work in industry. If your sugar content is in the range of 0-8% and alcohol 10-15 vol%, then from the specific gravity reading, I can readily tell you the combinations of sugar and More

€100 EUR in 10 days
(1 Review)
1.6
webscraper24

"Greetings! According to your stated project description you need an excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your More

€40 EUR in 3 days
(2 Reviews)
0.0
raihan257

Hi.. I saw your ad for an excel expert.. I want to work with you on this if you will accept my proposal. Of course I cannot convince you to but I can give an assurance of a good job from me..

€34 EUR in 3 days
(0 Reviews)
0.0