Purchase Solution

Best Fit Curve in Excel

Not what you're looking for?

Ask Custom Question

*** Please see attached file. ***

a. Find the best fit of the data to the curve.

y x
0 5.1
1 10.9
2 21.2
3 34.7
4 53.5
5 76.0

b. Comment on the goodness of fit you achieved.

Attachments
Purchase this Solution
Solution Summary

The best fit curve in Excel is examined. The goodness of fit for data is determined.

Solution Preview

First, I made a scatterplot: x is the independent variable, and y is the dependent variable (this is ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Enzyme Kinetics: Hydrolysis Rate Data

    A straight line fitted to this data has a gradient of Km/vmax and an intercept of 1/vmax Solution can be found in two ways: plot v against [S] and fit a curve to it using Excel Solver or make the data fit a straight line.

  • The following plasma concentrations (in ug/ml) of a new drug

    The parameters in the double-exponential fit were found to be: A= 0.06373 B = -0.07580 C = 0.83030 D = -1.56689 So you can now graph the fit function in excel. And as you can see, they fit extremely well.

  • Adding Two Sixth Order Polynomial Regression Equations

    I have 2 data sets that determine a y-value based on known x-values (the x-values are given as temp degrees C) ---- each of those actual line graphs have been fitted with an approximate "best fit" line determined by Excel with 2 separate 6th order line

  • Functions and Graphs

    If you want to predict the number of death in 2005, you plug in X=2005, then we will get Y=2+X=2+2005=2007 So, from above, you can get the best line to fit the data and do some prediction.

  • MATLAB polyfit find P50 in mmHg

    49831 MATLAB polyfit find P50 in mmHg How do I convert back to find P50 in mmHg and n given the best-fit?

  • Non Linear Regression: exponential trend curve

    279998 Non Linear Regression: exponential trend curve 1. For each company, fit an exponential trend curve to their sales data. 2. For which company does exponential growth have the best fit to revenue growth? 3.

  • Bivariate regression model and caveats

    Why is it best to ignore earlier years in this data set? Airplanes U.S.

  • Statistics Problem: Merger Trends

    b) From the scatter plot, it appears that an exponential trend would best fit to this series. c) The equation of the regression curve is y = 16.376e^0.15666x.

  • Regression Equation

    True False Answer: True The method of least squares assumes that the best-fit curve of a given type is the curve that has the minimal sum of the deviations squared (least square error) from a given set of data.

View More Related Solutions