Mathmatic relationship (Linear,Quadratic,Exponential)

  • Thread starter Thread starter Ltpenguin
  • Start date Start date
  • Tags Tags
    Relationship
AI Thread Summary
The discussion centers on identifying the mathematical relationship of a given dataset and determining the regression equation. Participants conclude that the relationship is quadratic, as the data points form a parabola, while linear and exponential models do not fit the data. Issues with calculator errors, particularly with the point (11, 50), lead to suggestions to remove this outlier for accurate regression analysis. Various regression coefficients are provided, with some discrepancies noted among users' calculations. The conversation emphasizes the importance of considering data context and potential outliers when performing regression analysis.
Ltpenguin
Messages
15
Reaction score
0

Homework Statement



State the mathematical relationship (Linear,Quadratic,Exponential) and determine the regression equation for this relationship.

Homework Equations


xX3KXds.png

X| 1 | 3 | 5 | 7 | 9 | 11 | 13 | 15 |
Y| 50 | 14 | 2 | 14 | 50| 50 |194|302|

The Attempt at a Solution


?.? i input the information into my TI-83 Plus and i get an error when trying to make a regression equation and i cannot figure out the type of relationship it is(linear,quadratic, or exponential)

anyone know how to do a table? i did the difference thing.
 
Physics news on Phys.org
Ltpenguin said:
State the mathematical relationship (Linear,Quadratic,Exponential) and determine the regression equation for this relationship.

Look carefully at the graph.
How does a quadratic graph normally look like?
How does an exponential graph normally look like?
And how does a linear graph normally look like?
If you know all these, then you can answer your question. :wink:
 
Last edited:
adjacent said:
Look carefully at the graph.
How does a quadratic graph normally look like?
How does an exponential graph normally look like?
And how does a linear graph normally look like?
If you know all these, then you can answer your question.

It would appear to be a quadratic but when i try to make the formula on my TI-83 it doesn't make the equation it gives and error.
 
Ltpenguin said:
It would appear to be a quadratic but when i try to make the formula on my TI-83 it doesn't make the equation it gives and error.

The ##y## value for ##x=11## seems to be giving the error. Try removing that.
Obviously this is not a linear graph -Linear graphs should be a straight line.
This is also not a exponential graph. Do you know why?
 
Last edited:
adjacent said:
The ##y## value for ##x=11## seems to be giving the error. Try removing that.
Obviously this is not a linear graph -Linear graphs should be a straight line.
This is also not a exponential graph. Do you know why?
It is a Quadratic because it forms a parabola and not an exponential graph because an exponential graph would not lower at any point it would continune to go on a sharp incline. Also i still got an error when i removed x=11 / y=50

Got another calculator my seems to malfunction when doing the calc. y=ax^2+bx+c A=3.267857 B= -35.357214 c=89.589285
 
Last edited:
Ltpenguin said:
Got another calculator my seems to malfunction when doing the calc. y=ax^2+bx+c A=3.267857 B= -35.357214 c=89.589285
Then your calculator is broken(Or reached some limit?)
My calculator does that without malfunctioning. See:
attachment.php?attachmentid=71004&stc=1&d=1404139720.png
 

Attachments

  • graph.PNG
    graph.PNG
    8.5 KB · Views: 588
  • Like
Likes 1 person
Ltpenguin said:
...

Got another calculator my seems to malfunction when doing the calc. y=ax^2+bx+c A=3.267857 B= -35.357214 c=89.589285

That agrees with adjacent's recent posted value.

If you discard the point with x = 11, the rest of the points lie exactly on a parabola. For this parabola, A, B, and C are all integers.
 
If there is a context to the problem, you may want to consider that. Sometimes output variables are non-negative. Examples would be height, age, test grades. If that is a constraint on this data set, it may be better to drop the point (11, 50) before running the regression.
 
Just for confirmation, using all the given points, Maple gives exact fractions:$$
a=\frac {183}{56},~b=-\frac{495}{14},~c=\frac{5013}{56}$$which agrees with the other solutions given as decimals.
 

Attachments

  • regression.jpg
    regression.jpg
    7.3 KB · Views: 492
Last edited:
  • #10
LCKurtz said:
Just for confirmation, using all the given points, Maple gives exact fractions:$$
a=\frac {183}{56},~b=-\frac{495}{14},~c=\frac{5013}{56}$$which agrees with the other solutions given as decimals.
Isn't that the parabola of best fit including that ##x=11## point?
None of the points in the table lies in that(Your) parabola
 
  • #11
LCKurtz said:
Just for confirmation, using all the given points, Maple gives exact fractions:$$
a=\frac {183}{56},~b=-\frac{495}{14},~c=\frac{5013}{56}$$which agrees with the other solutions given as decimals.

adjacent said:
Isn't that the parabola of best fit including that ##x=11## point?

Isn't that what I said above?

None of the points in the table lies in that(Your) parabola

You wouldn't expect them to be exactly on the best least squares fit.
 
  • #12
LCKurtz said:
Isn't that what I said above?



You wouldn't expect them to be exactly on the best least squares fit.

When I do it in Maple I get ##a = 183/56, b = -495/15, c = 5017/56##, so my ##c## is a bit different from what you wrote.

If, instead of a least-squares solution we minimize the absolute error solution
\sum_{i=1}^8 |Y_i - a - b X_i - c X_i^2|
we obtain ##a = 77, b = -30,\, c = 3##. The errors are all zero except at the point x = 11, where the absolute error is 60. Basically, the mean absolute-deviation method automatically de-emphasizes the point x = 11 and gives an exact fit to the rest of the data.

For the benefit of the OP: the least-absolute solution can be obtained by solving a so-called linear programming problem:
\text{minimize } \sum_{i=1}^8 z_i\\<br /> \text{subject to the constraints}\\<br /> z_i \geq Y_i - a - b X_i - c X_i^2, \: i=1, \ldots, 8\\<br /> z_i \geq a + b X_i + cX_i^2 - Y_i, \: i = 1, \ldots, 8
Here, the variables are ##a,b,c, z_1, z_2, \ldots, z_8##. Such problems can be solved using the EXCEL Solver tool, or using the (free) trial version of LINGO (from LINDO Systems, Inc.) plus numerous free "linear programming solution" tools available from the web.
 
  • #13
Ray Vickson said:
When I do it in Maple I get ##a = 183/56, b = -495/15, c = 5017/56##, so my ##c## is a bit different from what you wrote.

I just ran it again. Apparently I mistyped the numerator for ##c## because I do get ##5017/56## as you do. But for ##b## I still get ##-495/14##.
 
  • #14
LCKurtz said:
I just ran it again. Apparently I mistyped the numerator for ##c## because I do get ##5017/56## as you do. But for ##b## I still get ##-495/14##.

I mis-typed ##b##; it should have been as you state.
 
Back
Top