ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Sine trendline in scatter? (https://www.excelbanter.com/charts-charting-excel/231068-sine-trendline-scatter.html)

Thora May 16th 09 11:14 PM

Sine trendline in scatter?
 
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that I
can add a sine trend line to my scatter point chart and I need to. Is there a
way to do this or perhaps an add-on that adds it to the trendline-type menu?

Thanks,
Thora

Bernard Liengme[_3_] May 17th 09 02:43 AM

Sine trendline in scatter?
 
You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample data and
tell me the form of the equation to be used in the fit (example: y=Asin(Bx)
where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that I
can add a sine trend line to my scatter point chart and I need to. Is
there a
way to do this or perhaps an add-on that adds it to the trendline-type
menu?

Thanks,
Thora




Thora May 17th 09 07:37 PM

Sine trendline in scatter?
 
Hi,

Sorry I didn't see an email with caps to remove...so I thought it easiest
just to upload it externally. I hope that's okay. It's .xls

http://www.filedropper.com/sampledataneedssinetrend

The file contains two sets of data, the first is an obvious sine curve
trend, and the second sheet is a much less obvious sine trend (and the real
difficulty, as I can't freehand it). There are a few instances where there is
no data for Y; ignoring those should be fine, I should think.

As for the equation form...it's been so long since I've had to do any of
this... y=Asin(BX) is probably the best I can offer.

Thank you very mych for your assistance!

Thora



"Bernard Liengme" wrote:

You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample data and
tell me the form of the equation to be used in the fit (example: y=Asin(Bx)
where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that I
can add a sine trend line to my scatter point chart and I need to. Is
there a
way to do this or perhaps an add-on that adds it to the trendline-type
menu?

Thanks,
Thora





Royi Avital May 19th 09 08:01 AM

Sine trendline in scatter?
 
What's "Solver"?

Thanks.
--
Royi Avital


"Bernard Liengme" wrote:

You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample data and
tell me the form of the equation to be used in the fit (example: y=Asin(Bx)
where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that I
can add a sine trend line to my scatter point chart and I need to. Is
there a
way to do this or perhaps an add-on that adds it to the trendline-type
menu?

Thanks,
Thora





David Biddulph[_2_] May 19th 09 08:49 AM

Sine trendline in scatter?
 
If Excel help isn't working on your machine, you may need to reinstall
Excel.
--
David Biddulph

Royi Avital wrote:
What's "Solver"?

Thanks.

You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample
data and tell me the form of the equation to be used in the fit
(example: y=Asin(Bx) where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear
that I can add a sine trend line to my scatter point chart and I
need to. Is there a
way to do this or perhaps an add-on that adds it to the
trendline-type menu?

Thanks,
Thora




Bernard Liengme[_3_] May 19th 09 01:53 PM

Sine trendline in scatter?
 
If you look at this email you will see my address with TRUENORTH. added to
it
Or visit my website
I could not get the file from your site; also I need somewhere to send my
reply file
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

Sorry I didn't see an email with caps to remove...so I thought it easiest
just to upload it externally. I hope that's okay. It's .xls

http://www.filedropper.com/sampledataneedssinetrend

The file contains two sets of data, the first is an obvious sine curve
trend, and the second sheet is a much less obvious sine trend (and the
real
difficulty, as I can't freehand it). There are a few instances where there
is
no data for Y; ignoring those should be fine, I should think.

As for the equation form...it's been so long since I've had to do any of
this... y=Asin(BX) is probably the best I can offer.

Thank you very mych for your assistance!

Thora



"Bernard Liengme" wrote:

You will need to do this using Solver
Send me (private email - just remove TRUENORTH.) a file with sample data
and
tell me the form of the equation to be used in the fit (example:
y=Asin(Bx)
where A and B are to be determined)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Thora" wrote in message
...
Hi,

I admit I'm not well versed with Excel 2007, but it doesn't appear that
I
can add a sine trend line to my scatter point chart and I need to. Is
there a
way to do this or perhaps an add-on that adds it to the trendline-type
menu?

Thanks,
Thora








All times are GMT +1. The time now is 05:00 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com