Purchase Solution

Modeling data with polynomial functions and rational functions

Not what you're looking for?

Ask Custom Question

(1) Create a set of data that can be modeled as a polynomial function. Please provide a reference to the data. Plot the data using Microsoft Excel including the equation for the fit. Discuss how closely the data seem to match to the best fit line.

(2) Do the same for data that can be modeled using a rational function. Include in your answer how this can be used in a real-life application.

Purchase this Solution
Solution Summary

The solution includes definitions of the terms "function", "polynomial function", and "rational function". It explains through examples how to use Excel to model data using polynomial and rational functions.

Solution Preview

Many different kinds of data can be modeled using polynomial functions. An example of a polynomial function would be gas mileage for an automobile. If we compare gas mileage at two different speeds, V1 and V2, the gas required varies as (V1/V2), raised to the third power, (V1/V2)3.

Rational functions are also useful. For example, a cubic/cubic model can be used to explain the thermal expansion of metals with temperature. Rational functions have been used to describe problems as diverse as the movement of blood through the body to how to produce items at the lowest possible cost.

For this Discussion Board, create a set of data that can be modeled as a polynomial function. Please provide a reference to the data. Plot the data using Microsoft Excel including the equation for the fit. Discuss how closely the data seem to match to the best fit line. Do the same for data that can be modeled using a rational function. Include in your answer how this can be used in a real-life application.

First things first ... a function is an equation relating two variables (usually called x and y) so that when you pick a value for x, there's only one possible value for y to make the equation true.

A polynomial function is a function where all the terms with x in them have coefficients that are real numbers and exponents that are whole numbers. (Some more definitions: a coefficient is the number that the variable is multiplied by, and an exponent is the power that the variable is raised to. Whole numbers are 0, 1, 2, 3, ...) Some examples of polynomials are:
y = x
y = -3x + 5
y = 3
y = 3x2 - 8x + 1
y = 8x95 + ...

Purchase this Solution
Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

View More Free Quizzes
Related BrainMass Solutions

  • Modeling with Polynomial Functions

    130302 Modeling with Polynomial Functions Many different kinds of data can be modeled using polynomial functions. An example of a polynomial function would be gas mileage for an automobile.

  • Polynomial and Rational Functions

    150429 Modeling Data: Polynomial and Rational Functions * Create a set of data that can be modeled as a polynomial function. * Please provide a reference to the data. Plot the data using Microsoft Excel including the equation for the fit.

  • Modelling Data with Polynomial and Rational Functions

    147680 Modelling Data with Polynomial and Rational Functions Many different kinds of data can be modeled using polynomial functions. An example of a polynomial function would be gas mileage for an automobile.

  • Set of data that can be modeled as a polynomial function

    If we compare gas mileage at two different speeds, V1 and V2, the gas required varies as (V1/V2), raised to the third power, (V1/V2)3. Rational functions are also useful.

  • Create a set of data that can be modeled as a polynomial function.

    If we compare gas mileage at two different speeds, V1 and V2, the gas required varies as (V1/V2), raised to the third power, (V1/V2)3. Rational functions are also useful.

  • Please create Excel Document Separately Please Include any References

    If we compare gas mileage at two different speeds, V1 and V2, the gas required varies as (V1/V2), raised to the third power, (V1/V2)3. Rational functions are also useful.

  • Modeling using Second and Third Order Polynomials

    169872 Modeling using Second and Third Order Polynomials One of the advantages of rational functions is that even rational functions with low-order polynomials can provide excellent fits to complex experimental data.

  • Asymptotes and exponential functions

    Explain why that data or situation fits an exponential function. ? Solve linear equations. ? Create graphs of functions. ? Use polynomial, rational, exponential and logarithmic functions. Thank you very much.

  • Algebra - Polynomial and Rational Functions

    200721 Algebra - Polynomial and Rational Functions One of the advantages of rational functions is that even rational functions with low-order polynomials can provide excellent fits to complex experimental data.

View More Related Solutions