Fermé

Updated Excel file to calculate Y value from a chart trend line

I have an Excel file which contains a simple chart (It's a picture). On the chart there is a polynomial trend-line. The equation for Y is displayed on the chart.

I need somebody to update the excel file so that if I enter a value for X into a cell and it should use the correct formula to display the value for Y. All my tests have so far failed to return suitable values which indicates I am not using the excel formula correctly.

Compétences : Excel, Mathématiques, Traitement de Données, Statistiques, Saisie de Données

en voir plus : how to add data points to a trendline in excel, how to calculate trend analysis in excel, how to add a trendline in excel 2016, excel trendline equation without chart, how to find a value on a trendline in excel, excel trend function, how to make a trendline in excel for multiple series, excel trendline equation in cell, creation excel file, convert excel file address book, program sort excel file, search excel file vbscript, save datagrid excel file, daily updated csv file excel, vbscript search value excel file, calculate lifetime value customer excel

Concernant l'employeur :
( 26 commentaires ) London, United Kingdom

Nº du projet : #27405535

40 freelances font une offre moyenne de 22 $ pour ce travail

(228 Commentaires)
7.3
suyashdhoot

Hi I am a very experienced statistician, 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 comp Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(140 Commentaires)
7.1
AnowarRatul

-----------EXCEL EXPERT------------------COMPLETE 30 MIN PLEASE AWARD ME SIR------------- Hello sir, checked description and attachment . I can calculate your Excel criteria as your requirements by maintaining 100% a Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(196 Commentaires)
6.0
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have successful experience performing similar work. These are screenshots of some of my works. [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(100 Commentaires)
6.2
(173 Commentaires)
5.8
lotusvijay

Hi Good Day,~~~~~I will start working immediately.~~~~~ Kindly ping me to discuses more on this formula "y = 3E-06x6 - 0.0006x5 + 0.0591x4 - 2.565x3 + 52.24x2 - 425.56x + 993.28 " I can do this work.I am expert in Exce Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(44 Commentaires)
4.5
mowachira77

Hi there, I have reviewed the file you have attached and am sure to deliver accurate results for the y-value. I have 5 years of experience in excel formulas and VBA. I will complete your work in one day only and deli Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(28 Commentaires)
4.4
Jatin77777

Hello, I have gone through with contents and attached files to understand the requirements. This is pretty straightforward task and I am interested to do this work and break your huddle. Please allow me to do this job. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
3.9
SIBTEHASSANBUTT

Hi there, I have read your project entitled “Updated Excel file to calculate Y value from a chart trend line ” I am a professional accountant dealing with PowerBi, well versed with data analytics, using excel and othe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(10 Commentaires)
3.7
karthik89rec

Hi, I created the formula already. Please find the results below. Y (Value £) -1.33E+18 Upper Value (£) -1.26E+18 Lower Value (£) -1.39E+18 Please leave me a message to get this delivered right away. Thank you!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
3.0
ammar3215

I am a pro in excel with 7 years of experience .. I can update the excel file so that if you enter a value for X into a cell and it should use the correct formula to display the value for Y .. please share more details Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
3.1
DebDhara

Hi, Its pretty simple task for me. I can deliver it within few mins.. I can deliver it in less than $10. I have seen the datasets and applied the formula correctly.. Lets chat to get the output.. Thanks...

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.6
Jayant222

Hi there, I am an expert in excel formulas, dashboards, macros. I have gone through the description on your project and will be able to finish in few hours. Thanks Jayant

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(10 Commentaires)
2.9
Muhammadsabeeh

Hello, I have read your Job description. I am ready for the job of updated excel file. I can complete your project within a few hours. I have over 10 years of high quality experience in List building, Word Formatting, Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.9
anangsoen

Hi, I can help you to make chart formula in Excel, so you can easily update it by entering X value I am excel + vba specialist who have +10 yrs experience.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.3
Rajonislam911

HI THERE, I am moshiul islam rajon from bangladesh. i am expert in excel and ms word. i can do completed this job with 100% successful..If you have any questions, please message me. Regards, MD Moshiul Islam Rajon

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.8
aitchbansal

I am a certified MS EXCEL USER i can make the formulation you want Lets discuss further in chat and I can do it quickly and now at this moment Thanks and Regards

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.4
(1 Évaluation)
1.0
iceman0k

Hi, I have substantial experience in leveraging VBA to make macros ranging from complex customer database and billing systems to creating user forms for efficient data input to simpler macros automating everyday mundan Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.1
Leozida

Hi There, Glad to inform you that your sheet is corrected, ready to deliver and you can play with your x, parameterers and variance Just invite you will get it right away for very low cost. I'll send you a screen shot Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.4