Results 1 to 2 of 2

Math Help - Excel Graph, Table Help

  1. #1
    Junior Member
    Joined
    Apr 2009
    Posts
    31

    Excel Graph, Table Help

    Hi.

    I have a few questions that I need to answer and don't really know what to do. Here is the question. Looks quite interesting.

    4.The funding (F) that a school receives is based upon a fixed allowance (B) and an allowance calculated on the number (N) students it enrols each year. Each student is reckoned at a standard cost of P, and the formula used is
    F = PN + B
    If the standard student cost (P) is 120 and the basic allowance is 250k


    (a)Set up a spreadsheet table of the funding against the number of students from 0 to 5000 students in steps of 500

    (b)Plot an XY Scatter graph of funding (y-axis) against student numbers (x-axis) for up to 6000 students

    (c)Print out the graph and use it to read off the number of students needed to attract funds of 500k

    (d)Extrapolate the graph and deduce the funding allowed for 5750 students

    (e)Add a column to your spreadsheet recording the funding for 0 to 5000 students if the basic allowance is adjusted to 400k and the standard student cost is adjusted to 85

    (f)Plot a double graph showing the old and new figures. Print off a hard copy and use the graph to deduce the number of students (to the nearest 100) which would attract the same overall funding under both sets of calculations. Indicate what value of funding this would be (to the nearest 10k)

    (g)Check and confirm your answers to (f) by solving the simultaneous equations related to the graphs algebraically


    Ive never been good at using Excel so if you would not mind could anyone looking at this do the graph and table in Excel and answer the other questions and send the files to my email address at Sailee316@googlemail.com My teacher said this would not take long but no one taught me how to do this.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by Sailee316 View Post
    Hi.

    I have a few questions that I need to answer and don't really know what to do. Here is the question. Looks quite interesting.

    4.The funding (F) that a school receives is based upon a fixed allowance (B) and an allowance calculated on the number (N) students it enrols each year. Each student is reckoned at a standard cost of P, and the formula used is

    F = PN + B


    If the standard student cost (P) is 120 and the basic allowance is 250k


    (a)Set up a spreadsheet table of the funding against the number of students from 0 to 5000 students in steps of 500
    In the first column first cell (A1) type "Stud. Nos", then below that fill the column (A2 .. A12) with 0, 500, 1000, 1500, ..., 5000.

    In the next column first cell (B1) type "Funding()". In the cell below that (B2) type =120*A2+250000. Copy this cell and paste it down the rest of the column opposite the numbers in column A.

    Now select the area of the sheet with data in it and use the graphing tool scatter plot function.

    CB
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 1
    Last Post: March 13th 2010, 05:38 PM
  2. Help me graph an equation in excel?
    Posted in the Algebra Forum
    Replies: 1
    Last Post: March 5th 2010, 04:07 AM
  3. Replies: 2
    Last Post: December 3rd 2009, 02:24 PM
  4. Replies: 0
    Last Post: October 14th 2008, 09:00 PM
  5. graph with excel
    Posted in the Pre-Calculus Forum
    Replies: 1
    Last Post: October 6th 2007, 10:43 PM

Search Tags


/mathhelpforum @mathhelpforum