1–1011–19

Graphs (Excel or not)

From: 99% of gargoyles look like (MR_BASTARD)13 Feb 2015 08:27
To: Peter (BOUGHTONP) 13 of 19
41396.13 In reply to 41396.12
quote: Peter (BOUGHTONP)

Trend lines are a good example of something that can be a PITA to get right at times, but are easily drawn with vectors.

Select data, right click, add trend line, select trend line that best fits the data. Gives you equation and R2 to boot. What's so difficult about that?

EDITED: 13 Feb 2015 08:27 by MR_BASTARD
Reply
0/0
From: koswix13 Feb 2015 09:18
To: Chris (CHRISSS) 14 of 19
41396.14 In reply to 41396.7
Ah, right. Also thought it was the scale.
Reply
0/0
From: Chris (CHRISSS)13 Feb 2015 09:40
To: koswix 15 of 19
41396.15 In reply to 41396.14
I don't think I explained it very well.
Reply
0/0
From: koswix13 Feb 2015 10:11
To: Chris (CHRISSS) 16 of 19
41396.16 In reply to 41396.15
No, I don't think you did, Christopher :C

I also assumed that everyone knows you right click a plot area and choose select data to tell excel what to plot.
Reply
0/0
From: Chris (CHRISSS)13 Feb 2015 10:37
To: koswix 17 of 19
41396.17 In reply to 41396.16
:( I've either been naughty or you're my grandmother.

Select data, not add more data. They should make it more obvious.
Reply
0/0
From: Peter (BOUGHTONP)14 Feb 2015 16:01
To: 99% of gargoyles look like (MR_BASTARD) 18 of 19
41396.18 In reply to 41396.13
> select trend line that best fits the data

You either have significantly more options than I, or have only ever dealt with boring data.

EDITED: 14 Feb 2015 16:02 by BOUGHTONP
Reply
0/0
From: 99% of gargoyles look like (MR_BASTARD)14 Feb 2015 19:19
To: Peter (BOUGHTONP) 19 of 19
41396.19 In reply to 41396.18
My Excel gives me exponential, linear, logarithmic, 5 orders of polynomial, power, and several orders of moving average (I've never figured the point of that). I'm sorry that your Excel is broken Paeter. I'm also sorry that your data are not as boring as mine. You live an exciting life.

What are your views on pizza Napoli?
Reply
0/0