racookpe1978
Nuclear
Excel defaults to a "standard" way of producing graphs -> simple x,y plots of the numbers in a table. You produce a table of numbers in columns, it produces any variety of "plots of dots"
But, I want to "test" the output of equations (in my case, the data is for temperature, wet-bulb temperature, wind speed, and pressure over several years for data taken every hour each day) themselves.
What I'd like to do is estimate equations approximating these different values, "test" then against the data by plotting the equations and their data at various resolutions of time and years (sometimes plotting all the years over top of one another by day-of-year, some times looking at min-max and average data for the month, etc. Then, re-edit the equations and try again.
Frankly, I'm not sure what I'm going to find, so I don't know what I'll need to do - but I don't want to just look at or re-plot 32,000 data points every time..
Is there an Excel "equation editor" or add-on program that lets you display and plot equations themselves (4th order, 5th 6th order polynominals or the sum of sin and cosine waves for example) without forcing the user to "plot a table" ?
But, I want to "test" the output of equations (in my case, the data is for temperature, wet-bulb temperature, wind speed, and pressure over several years for data taken every hour each day) themselves.
What I'd like to do is estimate equations approximating these different values, "test" then against the data by plotting the equations and their data at various resolutions of time and years (sometimes plotting all the years over top of one another by day-of-year, some times looking at min-max and average data for the month, etc. Then, re-edit the equations and try again.
Frankly, I'm not sure what I'm going to find, so I don't know what I'll need to do - but I don't want to just look at or re-plot 32,000 data points every time..
Is there an Excel "equation editor" or add-on program that lets you display and plot equations themselves (4th order, 5th 6th order polynominals or the sum of sin and cosine waves for example) without forcing the user to "plot a table" ?
