u ALL of the data together?
>
>
> Sent on the Sprint® Now Network from my BlackBerry®
>
> -Original Message-
> From: Dilip Pandey
> Date: Fri, 26 Nov 2010 20:52:39
> To:
> Cc:
> Subject: Re: $$Excel-Macros$$ Nonlinear Regression Analysis
>
> Hi Bob,
&g
View --> http://processtrends.com/toc_trend_analysis_with_Excel.htm
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
_
I am OK with three different x and y values ... I'm not sure why that
never occurred to me!
Would it help to send you ALL of the data together?
On Nov 26, 9:22 am, Dilip Pandey wrote:
> Hi Bob,
>
> Ok, in order to determine the best Singular X and Y values we need to break
> down or segregate th
Hi Bob,
Ok, in order to determine the best Singular X and Y values we need to break
down or segregate the large data into the similar type of data sets. After
this segregation we can have 2 or 3 sets of Singular Xs and Ys which can be
used to fulfill / justify the equation as one set of X and Y c
While the Goal Seek feature is interesting and I thank you for
bringing it up, I don't think it answers my problem.
I'm attempting to make a predictive model, so I'm looking for a method
to determine the best X and Y value to fit the data set. So, while X
and Y certainly change from record to reco
Hi Bob,
I have done something in the attached file.
I believe if the x and y are not fixed at all the time, then we can
use Goal Seek feature of Excel to obtain the desired results.
Question:- How are you determining X and Y when you already have As and Bs.
Best Regards,
DILIPandey
On 11/23/10,
Hello,
Thanks for your response!
Here's a random sampling of the data:
169 140 10
164 197 19
50 339 31
73 326 19
204 238 34
143 201 18
59 74 3
296 216 20
31 121 9
108 148 7
139 317 24
41 263 14
Hi Bob,
This seems to be interesting to me. Would you mind providing some
sample data with the the indicative result which you want to obtain
through Excel.
Best Regards,
DILIPandey
On 11/23/10, Bob wrote:
> Good afternoon,
>
> I have a fairly large data set (roughly 7,000 samples) on which I
Good afternoon,
I have a fairly large data set (roughly 7,000 samples) on which I
would like to run some nonlinear regression analysis.
I'm fully capable of using the Data Analysis Toolpak and running the
linear analysis there, but unless I'm totally missing it, there
doesn't seem to be a method
