using excel to determine equation.


by denian
Tags: determine, equation, excel
denian
denian is offline
#1
Jul18-05, 08:58 AM
P: 160
i already enter the data, and then obtain the curve graph for the data.
how can i obtain the equation of the curve from excel?
Phys.Org News Partner Science news on Phys.org
NASA's space station Robonaut finally getting legs
Free the seed: OSSI nurtures growing plants without patent barriers
Going nuts? Turkey looks to pistachios to heat new eco-city
denian
denian is offline
#2
Jul18-05, 09:00 AM
P: 160
and another question, i have data from day 1 to day 21. how can i get the extimated value for day 30 with excel?
any help will be appreciated.
Integral
Integral is offline
#3
Jul18-05, 02:44 PM
Mentor
Integral's Avatar
P: 7,291
After charting your data select the "add trend" line option. You are given the choice of several different line fits, choose the one that is defined by the under lying math of your data... Or chose the one that is a close match to the trend in your data. In the trendlines options there is a check box for displaying the equation on the chart.

If your data is linear, you can also use the LINEST command to compute the slope and intercept of the best fit line. This is the same as choosing a linear fit trend line, except the slope and intercept are more easily used to extrapolate (this the official name of extending a trend line beyond your data set.

You can also extrapolate by selecting your data and "drag fill" the column until you get beyond the x value you need. For this to work you need a constant [itex] \Delta [/itex]x in your data.

denian
denian is offline
#4
Jul19-05, 03:45 AM
P: 160

using excel to determine equation.


thank you.


Register to reply

Related Discussions
determine the locus equation Precalculus Mathematics Homework 17
bragg equation to determine the lattice constants Advanced Physics Homework 1
how to determine the equation of a parabola Calculus 1
Determine Equation by Graph Introductory Physics Homework 3
How to determine whether two complex trig equation is identical. Calculus 4