Explore BrainMass
Share

Explore BrainMass

    Please create Excel Document Separately Please Include any References

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Background:
    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.

    Tasks:

    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.

    Many different kinds of data can be modeled using exponential and logarithmic functions. For example, exponential functions have been used by Thomas Malthus to describe the growth of human populations. Exponential growth has also been used to indicate how property values grow in strong real estate markets.

    Create a set of data that can be modeled as y = exp(x); provide a reference to the data. Plot the data using Excel, including the equation for the fit. Do the same for data that can be modeled using y = log(x) .

    © BrainMass Inc. brainmass.com October 9, 2019, 10:07 pm ad1c9bdddf
    https://brainmass.com/math/basic-algebra/please-create-excel-document-separately-please-include-any-references-208783
    $2.19