Convert Excel Optimization Model to R

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I have a price elasticity optimization model in Excel, I would like converted to R, perhaps using the LpSolveAPI package. I have calculated the elasticity in R, but need help organizing the data to maximize revenue. Steps will include the following.

1. Read data into R from .csv

2. Calculate price elasticity demand

3. Solve for optimal volume to maximize revenue

See attached for the model to be converted to R.

Excel Linear Programming Mathematics Statistical Analysis Statistics

Project ID: #11443406

About the project

19 proposals Remote project Active 7 years ago

Awarded to:

mohamedrdait

Hello sir I am en engineer In operational research I mastered R and PL and I have a solide skills in statistics contact me for more information (I can achieve the project using R or with Excel by vb.net please check More

$250 USD in 3 days
(3 Reviews)
1.5

19 freelancers are bidding on average $337 for this job

cugamelover

I am expert in math and statistics with a PhD degree. I've done many projects in econometrics and financial math. I know exactly what you need and how do that. I'm also an expert in R and Excel. It would be my pleasure More

$250 USD in 3 days
(211 Reviews)
7.0
sumbali

A proposal has not yet been provided

$250 USD in 6 days
(89 Reviews)
5.9
kjgroup197318

-----------------------------Professional R Developer! Best Result in Time!------------------------------ Dear, sir. I read your project description very carefully. Your project is very interesting to me, because I More

$300 USD in 10 days
(103 Reviews)
6.2
katilinas

Hello. 40 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$250 USD in 10 days
(46 Reviews)
4.9
axiomswb

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..

$300 USD in 7 days
(8 Reviews)
4.0
emokaya32

I am a PhD student pursuing doctoral studies in statistics. Previously, I graduated with a M.Sc. (Statistics) and earlier on I had finished my B.Ed. (Sciences) majoring in Double Mathematics from university. Among the More

$333 USD in 10 days
(5 Reviews)
3.3
tiaratechies

Hello, our team has a chartered accountant and an experienced excel person. If given an opportunity will deliver the best in given time frame. I am confidently telling that we can do this work as for your requirements. More

$250 USD in 21 days
(9 Reviews)
2.5
smartresearch1

I am an expert in data mining, predictive modeling and optimization. I have a PhD in physics with extensive experience in machine learning, statistics and coding. I use R and Excel.

$300 USD in 6 days
(1 Review)
1.7
shoibsoomro

AAooooooooo I cannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn very eaily and perfectly and perfectly your task

$252 USD in 10 days
(0 Reviews)
0.0
moneypower12

Dear sir I have very interested in your job and can complete as you need PERFECTLY. I'd like to work with you. I am ready to start just now. But i have full experiences of outsourcing and have been developed as More

$277 USD in 3 days
(0 Reviews)
0.0
Joe156

Hi, I am familiar with optimization in R. I have done a similar project on converting Excel Macro to other code. I will be happy to work on this project with you. Your project will be complete quickly and with hig More

$250 USD in 10 days
(0 Reviews)
0.0
dasdk56

25 years of service experience. A postgraduate in Statistics, can comfortably and confidently complete the job within stipulated time.

$277 USD in 20 days
(0 Reviews)
0.0
Webgood77

Hi, I'm using RStudio Desktop and I've created before some solutions. So I create some mockup for you to be sure that I understand that you want and you see my experience. Thanks, Denis

$300 USD in 10 days
(0 Reviews)
0.0
ashish2345

A proposal has not yet been provided

$555 USD in 10 days
(0 Reviews)
0.0
amyee

Let me have a look at the sample first please

$450 USD in 3 days
(0 Reviews)
0.0