ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do I do first order serial correlation in Excel 2007 (https://www.excelbanter.com/new-users-excel/204306-how-do-i-do-first-order-serial-correlation-excel-2007-a.html)

Richie

how do I do first order serial correlation in Excel 2007
 
fIRST ORDER SERIAL CORRELATION IN excel 2007 wHAT IS THE COMMAND?

Bernard Liengme

how do I do first order serial correlation in Excel 2007
 
Do you mean a linear fit?
Look at functions SLOPE and INTERCEPT; and LINEST if you want lots of
detailed stats.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"RICHIE" wrote in message
...
fIRST ORDER SERIAL CORRELATION IN excel 2007 wHAT IS THE COMMAND?




ShaneDevenshire

how do I do first order serial correlation in Excel 2007
 
Bernard,

Thanks for asking that question!

--
Thanks,
Shane Devenshire


"Bernard Liengme" wrote:

Do you mean a linear fit?
Look at functions SLOPE and INTERCEPT; and LINEST if you want lots of
detailed stats.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"RICHIE" wrote in message
...
fIRST ORDER SERIAL CORRELATION IN excel 2007 wHAT IS THE COMMAND?






All times are GMT +1. The time now is 12:29 PM.

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