Results 1 to 2 of 2

Thread: Draw a curve with defined variables

  1. #1
    Jun 2008

    Draw a curve with defined variables

    Hi everyone,

    I warn you already, I'm french and there might be some english math vocabulary I don't know, so I'll try and be as clear as possible in my explanation, and call each variable something.

    I work for a construction insurance company and I need to draw a curve either on Excel 2007 or Grapher on Mac OS X (preferably on excel) that would represent the premium for constructions with an amount from 10,000 € till 1,000,000.00 € (with a step of 10,000 between each points, so a total of 100 points: e.g.: what's the premium for a 10,000 € construction, then for a 20,000 € one, then 30,000 €, etc). Let's call the total construction amount "x", and the premium for it "y" (or f(x))

    For each 100,000, an intermediate premium "p" is set (not proportionally).
    For instance:

    from 100,001€ till 200,000€, the intermediate premium is 10,200;
    from 200,001€ till 300,000€, the intermediate premium is 10,400;
    from 300,001€ till 400,000€, the intermediate premium is 10,500;
    from 400,001€ till 450,000€, the intermediate premium is 11,800;
    from 450,001€ till 500,000€, the intermediate premium is 12,500;

    The premium is calculated with the sum of many percentages, and percentages on THESE percentages... But basically, it's the sum of 3 main objects:

    A: the premium before commissions
    B: the company's commissions
    C: the broker's commission

    Is there a way to define many variables to begin with, and then name stages of the equation for later use to simplify things (for instance, the intermediate premium "p" + 5% becomes "P", so then when i need to use it to add or multiply with another percentage i can just use "P")? Or maybe there is a sort of math terms or odd greek sign (dont know if matrixes are of any use here) that could simplify things a lot (Grapher is quite a complete program so i could use all these terms in it)?
    As you can see, this is actually more about how to use either Grapher or Excel 2007.

    If you need more details or infos, I'll check the forum daily.

    Thanks in advance to whoever can help
    Last edited by UVKutt; Jun 25th 2008 at 03:40 AM.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Aug 2007
    1) I think this requires a better definition.

    2) Perhaps...

    Total Premium = 10,200 = T

    Company Commission = 3% = C

    Broker Commission = 1% = B

    Premium Before Commission = P

    Thus P(1+B)(1+C) = T or $\displaystyle P\;=\;\frac{T}{(1+B)(1+C)}$
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. draw a curve
    Posted in the Pre-Calculus Forum
    Replies: 6
    Last Post: Jan 28th 2011, 02:52 AM
  2. draw curve
    Posted in the Geometry Forum
    Replies: 8
    Last Post: Jan 26th 2011, 09:22 AM
  3. calculate line integral and draw curve C
    Posted in the Calculus Forum
    Replies: 4
    Last Post: Dec 8th 2009, 01:00 PM
  4. draw curve
    Posted in the Calculus Forum
    Replies: 3
    Last Post: Apr 23rd 2008, 09:39 PM
  5. how do i draw the normal curve
    Posted in the Advanced Statistics Forum
    Replies: 1
    Last Post: Dec 6th 2007, 06:45 AM

Search Tags

/mathhelpforum @mathhelpforum