View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.charting
mauro mauro is offline
external usenet poster
 
Posts: 19
Default How do I adjust a curve ?

Del:

yes, you have reason I was traing to explain how the data fit, but I think
that was not a good explanation. I am traing to undertood you example. Thks

"Del Cotter" wrote:

On Thu, 14 Jun 2007, in microsoft.public.excel.charting,
Mauro said:

Del:

what do you think about this:


I got:

555.603 mean
004.154 st. dev.
152.906 area

But I don't know why you said the data would fit a normal distribution:
it's asymmetrical and has negative values. At the moment a polynomial
will fit the curve at least as well.

You should craft your own model of what you think the curve looks like
and use Solver on that.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.