x =
Therefore the respective values of the unknowns a,b,c and d are a=0.071, b=0.286, c=12.071 and d=-2.429
These values can then be subbed into the original equation of the cubic to form the quadratic function modelling the situation:
Using Excel, we can now take these two new functions of and and plot them on an axes along with the graph of the original data points to assess the accuracy of the functions in modelling the situation.
Green Line: Original Data Points
Red Line:
Blue Line:
In the graph above, it can clearly be seen that the function accurately models the original data points given when Leo has a rod of overall length 230cm. However, as the new function approaches the 6th, 7th and 8th guide, its values differ slightly, limiting the overall accuracy of the equation in modelling the situation. As the blue line representing the function of is not visible behind the graph of the original data points, this demonstrates the near complete accuracy of the function in modelling the situation. Using a graphics calculator, the data points of the two new functions can be found and then compared with the original data points to assess the differences between the three.
As seen in the graph and the table above, the graphs created using the quadratic and cubic fit the situation of Leo’s fishing rod, however the cubic function produces a graph and data points much closer to the original data points and therefore is the most accurate representation of the situation.
To further test the modelling of the situation, a polynomial function can be found that passes through every data point. The most accurate form of a polynomial function given the data would be an eighth order function, given there are 8 data points. However this will provide a very long and confusing function that may not be realistic. Therefore, I have chosen to model the situation using a quartic function found by matrix methods. As this is to a higher power than a quadratic or cubic equation, its accurateness and reasonableness will be increased.
Using matrix methods we can find a quartic function to model the situation from the given data points:
A quartic equation is in the form. As there are 5 unknown variables (a, b, c,d,e) we can create a 5 x 5 matrix and a 5 x 1 matrix to model the given information.
Using the 10 different data points, that represent the spread of the data, 5 equations can be formed:
The three equations can then be transformed to form a 5 x 5 and a 5 x 1 matrix with the corresponding coefficients:
We will call this first matrix - Matrix A
We will call the second matrix – Matrix B
We will now take the inverse of Matrix A and multiply it with Matrix B to get Matrix C, using the graphics calculator. Matrix C will contain the a,b,c ,d and e values of the quadratic equation in a 5x1 Matrix.
=
Therefore the respective values of the unknowns a,b,c,d and e are a= -0.005, b=0.138, c=0.033 d=12.262 and e=-2.429. These values can then be subbed into the original equation of the quartic to form the quartic function modelling the situation:
Using Excel, we can now take this new function of and plot it on an axes along with the graph of the original data points to evaluate the accuracy of the function in modelling the situation.
Green Line: Original Data Points
Red Line:
In the graph above, it can clearly be seen that the function accurately models the original data points given when Leo has a rod of overall length 230cm. As the red line representing the function of is not visible behind the graph of the original data points, this demonstrates the near complete accuracy of the function in modelling the situation. Using a graphics calculator, the data points of the function can be found and then compared with the original data points to assess the differences between them.
As seen in the table above, the values found from the function are almost identical to those of the original data. A small degree of error can be seen as the graph approaches the 7th and 8th guide, however not by a significant amount and so the equation is deemed as extremely accurate.
Using the graphics calculator, we can now find a function that models the situation to a greater degree of accuracy. I have chosen to use the method of Quartic Regression on the calculator, to provide me with a function with a very high degree of accuracy. I have chosen to use Quartic regression as a pose to quadratic or cubic, as when we raise the function to a higher power, the accuracy is increased. This function can then be compared to the quartic gained through matrix methods above.
The method using the graphics calculator is as follows:
Quartic function:
- Press STAT button
- Press EDIT
-
In L1 column – enter x values {1,2,3,4,5,6,7,8}
-
In L2 column – enter y values {10,23,38,55,74,96,120,149}
- Press STAT
-
Press → arrow and select CALC
- Press 7 – QuartReg
- Press Enter
GRAPHICS CALULATOR SCREEN
a = .0123106061
b = -.158459596
c = 1.730113636
d = 8.638979077
e = -.1964285714
R2 = .9999865758
Therefore, by rounding the values of a,b,c,d and e given above to 4sf we can find the values of the unknowns:
Using Excel, we can now take this new function of and plot it on an axes along with the graph of the original data points to assess the accuracy of the function in modelling the situation:
Green Line = Original Data Points
Red Line =
In the graph above, it can clearly be seen that the function accurately models the original data points given when Leo has a rod of overall length 230cm.As the green line is barely visible, the correlation between the two is almost identical, although varying slightly at the 7th and 8th guide and this can be seen by obtaining the data points of the function using a graphics calculator and comparing them with the original data points.
Now that we have found four functions to model the situation, it is relevant to assess which function most accurately models the situation. Using the four functions we can calculate the percentage error per equation to show the degree of accuracy in which the data points found using the function, correlate with the original data points. The lower the percentage error, the closer the function’s points are to the original, and similarly with a higher percentage error the accuracy declines.
Using an excel spreadsheet, the average percentage error can be found:
The spread sheet was set up as below
For each Y column (Y1,Y2,Y3,Y4) the values were found by entering the function into a Graphics Calculator and finding the corresponding points using the 2ND – TABLE function.
To calculate the percentage error using excel:
= ABS((Y (1,2,3,4) value – Y(O) value)/Y(O) value) x 100
Example multiplication: % error for Y3 when X = 2
To calculate the average percentage error using excel:
Highlight values in % error column
Select Formulas
Select AutoSum – Average
Once the average percentage errors are calculated, by comparing the respective values it is clear which function most accurately represents the situation. As the smaller the % error, the more accurate the function, for this reason it is clear that the quartic regression function of best models the situation, with a percentage error of 0.29%. The quadratic function least accurately models the situation, with a percentage error of 0.84%.
To further test the applicability of the functions to the real life situation of Leo’s fishing Rod, we can use the quadratic model of to find a ninth guide. By finding the placement of the 9th guide (in cm) from the tip, the fishing rod may be more effective in ensuring that the line does not tangle and that it casts easily and efficiently.
To find the distance of the ninth guide from the tip
It can therefore be seen that the distance of the ninth guide from the tip of the fishing rod is 170cm. However, before a ninth guide can be added we must assess the implications upon the rod and ensure that its addition does not limit the functionality of the rod. As the overall rod is of length 230cm, by adding a ninth guide at distance 170cm, this will allow only 60cm for the reel and placement of hands for fishing. This may limit the ability to hold the rod and cast the reel easily and limit the fisherman’s ability. Similarly if a ninth guide where added, instead of increasing the effectiveness of the line cast, it may have an opposite effect and make it more difficult to cats the line. Therefore before adding a ninth guide testing would need to be carried out on a realistic model to assess if the implications where negative or positive in their nature.
As this is a model of a real life situation, to test the applicability of the functions, we must apply it to a new set of data and assess if the function is applicable to further real life situations. Mark has a fishing rod with overall length 300cm. The table shown below gives the distances for each of the line guides from the tip of the fishing rod.
Using excel we can generate a graph of the data points of Marks’s fishing rod and those found using the quadratic function of to assess the degree to which the function models the new data.
Green Line: Mark’s Fishing Lin Data Points
Red Line: Quadratic Function
As seen above, the quadratic model fits the data for the first two guide points, however beyond this point, the graphs separate significantly and the function does not fit the new data accurately. This can also be seen in the table below, which shows the data points of mark’s fishing rod and the data points found using the quadratic equation:
As see on the previous page, as the guide numbers increase, the data points of the quadratic become more inaccurate and by guide 8, differ by around 20cm. So it can be seen that the limitations of our quadratic model is that it is limited by the size of the fishing rod, as well as being only applicable to the original set of data provided by Leo’s fishing rod. As the data points of mark’s fishing rod are significantly different from those of Leo’s, the model found of Leo’s fishing rod will be limited in its applicability to the distance of the guide’s of Mark’s fishing rod. The quadratic function was found using Leo’s data points and to model these points. As the Y values of Mark’s points vary greatly from these, it would be near impossible for the quadratic model found for Leo’s fishing rod to match that of Mark’s. Therefore it would be necessary to significant changes to the quadratic function to fit the new data, as when the size of the fishing rod is altered, the function is no longer applicable.
In order to obtain a function that models this new data accurately, by using the QuadReg function on the graphics calculator, we can find a quadratic equation that is altered to fit the model of Mark’s fishing rod.
Using the QuadReg function and entering in the respective Y values into the L1 column we find the function:
A Quadratic function:
- Press STAT button
- Press EDIT
-
In L1 column – enter x values {1,2,3,4,5,6,7,8}
-
In L2 column – enter y values {10,22,34,48,64,81,102,124}
- Press STAT
-
Press → arrow and select CALC
- Press 5 – QuadReg
- Press Enter
Graphics Calculator screen:
a = 0.9345238095
b = 7.720238095
c = 2.053571429
We can then compare this to the original quadratic function of and it is evident that significant changes must be made to the values of a a,b and c to model this new data. By adjusting the quadratic value of a =1 slightly to around 0.935 the model will be improved. With the values of b and c however, significant changes would be required, lowering the b value of the quadratic (10) to 7.72 and changing the quadratic c value of -1 to +2.054. These changes would formulate a function which would better fit the data points and more accurately model the data. This can be seen in the graph generated by excel modelling the data points of mark’s Fishing rod and the new equation of .
Orange Line: Marks Fishing Rod
Purple Line:
The accuracy of the data can also be seen in the table of the data below:
As seen above, as the purple line of the new function is not visible behind the graph of mark’s fishing rod, the newly adapted function accurately models the situation of Mark’s fishing rod. By finding this new function, it is clear that the quadratic function found for Leo’s fishing rod is not applicable to that of Mark’s and the two situations cannot be compared due to the differing size of the fishing rods.
Throughout this investigation, we have assessed various models of quadratic, cubic and quartic function, found through both matrix methods and technology to model the situation’s of both Leo and Marks fishing Rods. From the different values we have found for each equation, it is possible to determine that the most accurate graph that could be found is that of an eighth order function given we were given 8 data points. However, as this was not possible with a graphics calculator, by determining the values of quadratic, cubic and quartic functions, we were able to assess that the function found using technology, and with the highest power, the quartic regression equation, was the most accurate.
As the investigation requires an application to a real life situation, our method carried out allows for various conclusions to be drawn as the placement of guides on a fishing rod. For Leo’s rod of 230cm, our quadratic functions found modelled the situation, but with a degree of error that meant it could not be deemed totally accurate in relation to the data points given. As our next functions, the cubic and quartic modelled the situation with a lesser degree or error we can conclude that as the power of the polynomial increases, the accuracy of the function increases. Secondly, it can also be seen that by adding a ninth guide, the implications could be positive in nature, easier cast and less tangle, or negative, decreased ability to cast and increased difficulty for the fisherman in the use of the rod. Our final conclusion is drawn from our inability to apply the quadratic function of Leo’s rod to fit the data of Mark’s. This shows that when the length of the fishing rod is changed, so too must the equation be changed.