Prev: Creating a grouping variable with a scatter plot
Next: Gantt Chart!
From: clcnewtoaccess on 8 Apr 2010 08:36
Excel 2003
Is there a way to create a chart using daily data and create a trend line
for each week. The data does not have an Saturday's or Sunday's.

My data looks like this.

Date Output Input
2/15/2010 229 215
2/16/2010 441 153
2/17/2010 205 43
2/18/2010 283 138
2/19/2010 609 121
2/22/2010 272 136
2/23/2010 373 16
2/24/2010 193 176
2/25/2010 339 358
2/26/2010 533 238
3/1/2010 374 252
3/2/2010 244 269
3/3/2010 306 216
3/4/2010 297 229
3/5/2010 538 202
3/8/2010 235 373
3/9/2010 446 410
3/10/2010 385 335
3/11/2010 457 89
3/12/2010 462 71
3/15/2010 303 420
3/16/2010 575 139
3/17/2010 323 452
3/18/2010 414 129
3/19/2010 621 436

Thanks,
--
clcnewtoaccess
From: Jon Peltier on 9 Apr 2010 15:58
To use Excel's built-in trendline feature, you need a separate series
for each set of points you want analyzed by a trendline. That means one
series for each week.

Alternatively, you could use SLOPE() and INTERCEPT() worksheet functions
to compute the line of best fit for each week, then calculate X and Y
values for the endpoints of each week's line, and plot each pair of
points as a new series.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 4/8/2010 8:36 AM, clcnewtoaccess wrote:
> Excel 2003
> Is there a way to create a chart using daily data and create a trend line
> for each week. The data does not have an Saturday's or Sunday's.
>
> My data looks like this.
>
> Date Output Input
> 2/15/2010 229 215
> 2/16/2010 441 153
> 2/17/2010 205 43
> 2/18/2010 283 138
> 2/19/2010 609 121
> 2/22/2010 272 136
> 2/23/2010 373 16
> 2/24/2010 193 176
> 2/25/2010 339 358
> 2/26/2010 533 238
> 3/1/2010 374 252
> 3/2/2010 244 269
> 3/3/2010 306 216
> 3/4/2010 297 229
> 3/5/2010 538 202
> 3/8/2010 235 373
> 3/9/2010 446 410
> 3/10/2010 385 335
> 3/11/2010 457 89
> 3/12/2010 462 71
> 3/15/2010 303 420
> 3/16/2010 575 139
> 3/17/2010 323 452
> 3/18/2010 414 129
> 3/19/2010 621 436
>
> Thanks,
From: clcnewtoaccess on 12 Apr 2010 08:44
I have the Slope & Intercept calculations, How do I calculate the X & Y
values from this?
--
clcnewtoaccess


"Jon Peltier" wrote:

> To use Excel's built-in trendline feature, you need a separate series
> for each set of points you want analyzed by a trendline. That means one
> series for each week.
>
> Alternatively, you could use SLOPE() and INTERCEPT() worksheet functions
> to compute the line of best fit for each week, then calculate X and Y
> values for the endpoints of each week's line, and plot each pair of
> points as a new series.
>
> - Jon
> -------
> Jon Peltier
> Peltier Technical Services, Inc.
> 774-275-0064
> http://peltiertech.com/
>
>
> On 4/8/2010 8:36 AM, clcnewtoaccess wrote:
> > Excel 2003
> > Is there a way to create a chart using daily data and create a trend line
> > for each week. The data does not have an Saturday's or Sunday's.
> >
> > My data looks like this.
> >
> > Date Output Input
> > 2/15/2010 229 215
> > 2/16/2010 441 153
> > 2/17/2010 205 43
> > 2/18/2010 283 138
> > 2/19/2010 609 121
> > 2/22/2010 272 136
> > 2/23/2010 373 16
> > 2/24/2010 193 176
> > 2/25/2010 339 358
> > 2/26/2010 533 238
> > 3/1/2010 374 252
> > 3/2/2010 244 269
> > 3/3/2010 306 216
> > 3/4/2010 297 229
> > 3/5/2010 538 202
> > 3/8/2010 235 373
> > 3/9/2010 446 410
> > 3/10/2010 385 335
> > 3/11/2010 457 89
> > 3/12/2010 462 71
> > 3/15/2010 303 420
> > 3/16/2010 575 139
> > 3/17/2010 323 452
> > 3/18/2010 414 129
> > 3/19/2010 621 436
> >
> > Thanks,
> .
>
From: Jon Peltier on 13 Apr 2010 10:36
Slope is m and Intercept is b. For desired values of X, calculate Y
using the well known formula

Y = mX + b

With X and Y in adjacent columns, plot each segment as a new series in
the chart.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 4/12/2010 8:44 AM, clcnewtoaccess wrote:
> I have the Slope& Intercept calculations, How do I calculate the X& Y
> values from this?
 | 
Pages: 1
Prev: Creating a grouping variable with a scatter plot
Next: Gantt Chart!