Hi all,
Firstly, it is not a homework. I am working for a hotel booking company in
Thailand but I don't want to explain a complex equation and concept here so
I keep it simple and closely related to what I am trying to solve.I apology
if my question is not clear enough.
I am new to R and previously this problem can be solved easily in Excel
using the "Goal Seek" tool. An example related to my question is when we
use the PMT formula (in Excel) to find the loan payment amount for the
given values of parameters i.e. interest rate, total number of payments,
and principal amount of the loan.
loan_payment_amt_of_each_period =
PMT(interest_rate,total_number_of_payments,principal_amt)
The question is when you know exactly on a monthly basis that you can
afford only X amount of money to pay and you want to know how many months
you have to do the payment given your monthly affordable money, the fixed
interest rate, and the principal amount of loan. Using Goal Seek tool in
Excel, it is like a backward solving for X given Y by not having to
transform anything from the original equation. Simply put the
loan_payment_amt_of_each_period you want and let the software calculate the
total_number_of_payments for you.
Thanks arun. But that was you solved the original equation and put it as a
new formula to R to calculate the result which is easy as long as the
original equation is not complex.
Thanks you,
Prakasit Singkateera
On Mon, Feb 18, 2013 at 1:18 AM, Bert Gunter wrote:
> Homework? We don't do homework here.
>
> -- Bert
>
> On Sun, Feb 17, 2013 at 5:10 AM, Prakasit Singkateera
> wrote:
> > Hi Experts,
> >
> > I have a dataset of 3 columns:
> >
> > customer.name product cost
> > John Toothpaste 30
> > Mike Toothpaste 45
> > Peter Toothpaste 40
> >
> > And I have a function of cost whereby
> >
> > cost = 3.40 + (1.20 * no.of.orders^2)
> >
> > I want to do a backward calculation for each records (each customer) to
> > find his no.of.orders and create a new column named "no.of.orders" in
> that
> > dataset but I don't know how to do.
> >
> > Please help me.
> >
> > Thank you everyone,
> > Prakasit
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help@r-project.org mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
>
>
>
> --
>
> Bert Gunter
> Genentech Nonclinical Biostatistics
>
> Internal Contact Info:
> Phone: 467-7374
> Website:
>
> http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm
>
[[alternative HTML version deleted]]