Results 1 to 4 of 4

Math Help - PIECEWISE FUNCTION IN EXCEL

  1. #1
    Newbie
    Joined
    Sep 2005
    Posts
    3

    PIECEWISE FUNCTION IN EXCEL!!!!!!! (im stupid)

    anyone know how to do this

    (a) Use excel to create table of C(t) for the period of 12 years starting at 1990.

    (b) The cost of the 30 seconds ad increase to 0.5t for t greater or equal to 11. Use excel to create table of C(t) for the period of 15 years starting at 1990.


    The cost in millions of dollars of a 30 second television ad during the super bowl from 1990-2001 can be approximated by the following piecewise linear function t=0 (represents 1990)

    C(T){0.08t + 0.6 if 0<=t<8
    {0.355t-1.6 if 8<=t<=11

    Any help??
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Sep 2005
    Posts
    3
    the first answer is

    x f(x)
    0
    1 0.6
    2 0.68
    3 0.76
    4 0.84
    5 0.92
    6 1
    7 1.08
    8 1.16
    9 1.24
    10 1.595
    11 1.95
    2.305


    the equation in excel is =IF(A2<8,0.008*A1+0.6,0.355*a2-1.6
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Site Founder MathGuru's Avatar
    Joined
    Mar 2005
    From
    San Diego
    Posts
    478
    Awards
    1

    Embedded if then statements excel

    Use embeded If statements like this

    =IF(t>11,0.5*t,IF(t<=8,0.08*t+0.06,0.355*t-1.6))
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Newbie
    Joined
    Sep 2005
    Posts
    3
    thanks man appreciate it alot
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 14
    Last Post: October 7th 2011, 09:45 PM
  2. Replies: 3
    Last Post: June 4th 2010, 10:40 PM
  3. Piecewise function
    Posted in the Pre-Calculus Forum
    Replies: 0
    Last Post: September 11th 2009, 10:19 PM
  4. Excel Ln and Exp function-Urgent help
    Posted in the Business Math Forum
    Replies: 4
    Last Post: July 12th 2009, 01:41 PM
  5. excel piecewise functions
    Posted in the Statistics Forum
    Replies: 2
    Last Post: June 29th 2009, 01:48 PM

Search Tags


/mathhelpforum @mathhelpforum