Create Excel formula conform data sheet

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

I have a data sheet that needs an formula to be put into Excel for statistical data.

The formula's that need to be put in are as follows:

P(n+1)=1.15xP(n)-0.006xP(n)xR(n) // For Cell B3 //where P(n) stands for Prey and R(n) stands for Predators and n stands for year

R(n+1)=0.94xR(n)+0.00006xP(n)xR(n) // For Cell C3 //the same here

The attached Excel sheet has the first seven years filled in without the formula, but basically I want the formula be put in from respective cells B3 and C3 and be able to extract the formula from any other cell until 100 years.

Data Entry Data Processing Excel Statistics Visual Basic

Project ID: #20056913

About the project

8 proposals Remote project Active 4 years ago

Awarded to:

khoddam

Hello, I just opened the Excel file and applied the equations and formula up to 100 years. So your Excel sheet is ready to be delivered

$10 USD in 1 day
(37 Reviews)
5.3

8 freelancers are bidding on average $19 for this job

Mickelson

Hi, sir. I have looked carefully at your commentary. In my view, I think I am the right person for your project. I have deep knowledge and a lot of experience. I would like to have a more specific discussion on t More

$50 USD in 1 day
(15 Reviews)
5.2
JannatunNeyeem

Hi, I read all the necessities of your assignment and I must try to abide by all the requirements that you have mentioned in the project. If hired by you I will be responsible to complete the task within the stipula More

$20 USD in 1 day
(19 Reviews)
4.1
caprateekr

Hello there, I have gone through the sheet enclosed and the formula, i will put the formula as required in the file, I am also ready to start work on this right away. Message me to further discuss. Thanks

$20 USD in 1 day
(17 Reviews)
4.2
techism

Hi, Just finsihed your file and I am ready to send you. Formulas are in placed with 2 decimal places numbers. Just take it.

$10 USD in 1 day
(14 Reviews)
3.6
salehdin1993

Hi, I am Saleh din. Very happy for bid rhis project. i'm  statistics expert i worked other site. please look my portfilo if you want, send message, then discus details.

$10 USD in 2 days
(2 Reviews)
0.3
ananiasmedina

Hi I will solve it so fast, please let me know if you can work with me.i hope you give the opportunity.

$20 USD in 2 days
(0 Reviews)
0.0
esztertakacs79

Hello, I have experience with Excel and this formula you have provided is very straightforward and only takes a couple of minutes if I understand your request correctly (i.e. you want to express the above formula in E More

$10 USD in 1 day
(0 Reviews)
0.0