Mathmatic relationship (Linear,Quadratic,Exponential)

  • Thread starter Thread starter Ltpenguin
  • Start date Start date
  • Tags Tags
    Relationship
Click For Summary

Homework Help Overview

The discussion revolves around identifying the mathematical relationship (Linear, Quadratic, Exponential) from a given set of data points and determining the corresponding regression equation. Participants are analyzing a dataset with specific X and Y values to ascertain the type of relationship present.

Discussion Character

  • Exploratory, Assumption checking, Problem interpretation

Approaches and Questions Raised

  • Participants are attempting to input data into calculators for regression analysis but encounter errors, particularly with specific Y values. There are discussions about the characteristics of different types of graphs and how they relate to the data. Some participants suggest removing certain data points to achieve a better fit.

Discussion Status

There is ongoing exploration of the data and its implications, with some participants suggesting that the relationship appears to be quadratic. Various regression results are being shared, and there is a focus on the impact of specific data points on the regression analysis. No consensus has been reached, but multiple interpretations and methods are being discussed.

Contextual Notes

Participants are considering the implications of specific data points on the regression analysis, particularly the point at x=11, which seems to cause errors in calculations. There is also mention of constraints related to the nature of output variables, such as non-negativity.

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: 615
  • Like
Likes   Reactions: 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: 518
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.
 

Similar threads

Replies
4
Views
3K
  • · Replies 14 ·
Replies
14
Views
2K
  • · Replies 11 ·
Replies
11
Views
2K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 4 ·
Replies
4
Views
4K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 9 ·
Replies
9
Views
2K
Replies
12
Views
3K
  • · Replies 9 ·
Replies
9
Views
2K