• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14

Coding and Modelling - The tools used in my spreadsheets.

Extracts from this document...


Coding and Modellingimage00.pngimage01.png

The tools used in my spreadsheets:

  • Cell outline - to make my grid standout from the page

  • Different font styles – to make the column headings standout from the rest of the text
  • A centre justification tool – in order to make my spreadsheets look professional
  • The graphing feature – enabling me to draw up graphs from my data
  • Various mathematical calculations such as multiplying cells and the what if function – allowing me to save time and fully investigate my project

This is seen as an inappropriate graph because it only shows how the height affects the volume of the box when the question asks you how the cutout size affects the volume of a square of side 24cm:



For a square of size 24cm, the largest volume of box that can be made is 1024cm3, using a square cutout of 4cm.

For a square of size 120cm, the largest volume of box that can be made is 128000cm3, using a square cutout of 20 cm.

Final Conclusion

In both cases, it would appear that a trend emerges.

In each case the optimum cutout size is 1/6 of the size of the square sheet


...read more.


                15 cm                                                         (15 cm – 2x)

                                       x cmimage11.png

                                        (23 cm –2x)

Question 2b)Similarly for a rectangle with a length of 23cm, a width of 15cm and a cutout size of x cm, a box can be formed of volume (y):

= Length * Width * Height

= (23 – 2x) * (15 – 2x) * x

= 345x – 76x2 + 4x3

Essentially differentiating is done by taking an equation:

xn and applying the principle nx(n-1)

Therefore if: y = 345x – 76x2 + 4x3                =>dy= 345 – 152x + 12x2


resulting in a quadratic equation, which can be solved by:

x =  -b + or -        √b2 – 4ac             hence x = - (-152) + or - √ (152)2 – 4 (345)(12)

               2a                                                     2(12)  

x = 152 + or - √ 23104 - 16560


x = 9.704cm (4s.f) and 2.963cm (4s.f)

Clearly the cutout size cannot be 9.704cm (4s.f) since the rectangular box is only 15cm wide. The only other possible cutout dimension would be 2.963cm (4s.f).

Instead of creating a new spreadsheet, I can change values within an old spreadsheet to suit the new condition I want.


For example in the above spreadsheet, I predict that if I change cell B2 to 23 cell B5 and the rest of the column going downwards will change subtracting 1 each time from the value because of the formula =B2-2*A5.

...read more.


2 – 4ac             hence x = - (-140) + or - √ (140)2 – 4 (300)(12)

               2a                                                     2(12)  

x = 140 + or - √ 19600 - 14400


x = 8.838(4s.f) and 2.829cm (4s.f)

I have investigated five different rectangles, the results of which can be seen on the spreadsheet below:


Final Conclusion:

As you can see from the graph and the spreadsheet, my final prediction was right. As the length and width values get closer together, the optimum cutout size gets smaller because the volume size decreases.

I feel that my results have been very accurate because not only did I solve various formulae using differentiation but I also checked the results by constructing charts and graphs which showed me the optimum values. This has led to valid conclusions especially for the square Max Box where I achieved a general formula. I know that my other conclusion is valid because I have tested out the theory by doing lots of examples.

I feel that my results were also relevant because once I had found out that the cutout size affects the volume of the box, I was able to continue further in order to see whether a pattern emerged when investigating how the size of the length affected the cutout size when the width of the box remained constantly at 15cm. Unfortunately, I was unable to find a general formula for the rectangle Max Boxes.

...read more.

This student written piece of work is one of many that can be found in our AS and A Level Core & Pure Mathematics section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Core & Pure Mathematics essays

  1. Marked by a teacher

    The Gradient Function

    5 star(s)

    nx^n-1 works for fractional powers, and not just when x = 1/2. y=x1/4 x y Second point x second point y gradient 3 1.316074 3.1 1.326906811 0.143409 3 1.316074 3.01 1.317169373 0.14528 3 1.316074 3.001 1.316183672 0.145471 4 1.414214 4.1 1.422970721 0.123786 4 1.414214 4.01 1.415096618 0.125045 4 1.414214 4.001

  2. Numerical integration can be described as set of algorithms for calculating the numerical value ...

    0.0000793527354329 0.2500998786936790 M32 0.9328793957832550 0.0000198461095058 0.2500000000000000 M64 0.9328595496737490 0.0000049615273764 0.2500000000000000 "M128" 0.9328545881463730 0.0000012403818441 0.2500000000000000 "M256" 0.9328533477645280 0.0000003100954610 0.2500000000000000 "M512" 0.9328530376690670 0.0000000775238653 0.2500000000000000 "M1024" 0.9328529601452020 0.0000000193809663 0.2500000000000000 "M2048" 0.9328529407642360 0.0000000048452416 0.2500000000000000 * Note that "Mn" indicates an extrapolated estimate Referring to the use of polynomials on page 4, the gap between

  1. The Gradient Fraction

    This method is much more accurate than the 'triangle method'. Here is an example of how to use the Increment Method: The first thing you need to do is to draw the tangent across the point you want to calculate.

  2. Functions Coursework - A2 Maths

    Therefore taking x1=3, the following iteration is constructed: x1 3.00000000 x2 2.90000000 x3 2.89511794 x4 2.89510652 x5 2.89510652 x6 2.89510652 x7 2.89510652 x8 2.89510652 x9 2.89510652 x10 2.89510652 Each value is done to eight decimal places by Microsoft Excel. As one can see, the iteration has appeared to converge to 2.89510652 in three steps.

  1. Numerical Differentiation

    x y -4 -143 -3 -65.5 -2 -17 -1 8.5 0 17 1 14.5 2 7 3 0.5 4 1 5 14.5 To show another limitation I have used the equation: y=x�-4.6x+5.29 Decimal search does not work with repeated roots because the integer values either side of the root are the same sign.

  2. Estimate a consumption function for the UK economy explaining the economic theory and statistical ...

    The function now looks as follows: ct = 0.7273 + 0.9403yt As mentioned earlier, consumers look to their expected lifetime income when deciding expenditure. This theory has been explored and modelled by a number of economists most notably Friedman with his Permanent Income Hypothesis (PIH).

  1. Mathematical Investigation

    and y=sin(x) The blue graph y=sin (-x) is the exact x-axis reflection of the red graph y=sin(x) with the same period and amplitude. The observation shows when a negative sign is placed in front of the angle, x, the resulting graph is the reflection of the original function (in this case, y=sin(x))

  2. Sequences and series investigation

    I will now attempt to find values c and d by substituting in the two values I now possess. So we will now sub. in the values to the equation If we take sequence 2 for our value of n with our present values we will get: _(8) - 2(4)

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work