# Thread: Excel Graph, Table Help

1. ## 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.

2. Originally Posted by Sailee316
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