Regression Using the Excel LINEST Function

Short Description
a version of Microsoft Excel which has the LINEST built-in function … With these nine cells highlighted, place the cursor in the formula bar, …

Website: www.pge.com | Filesize: 394kb

Content
Regression Using the Excel LINEST Function Page 1 of 4
Copyright., Pacific Gas and Electric Company, all rights reserved www.pge.com/pec
Regression Using the Excel LINEST
Function
This application note is intended to serve as a companion to the Using Measured Current as a
Proxy for Power application note. To calculate power using collected current data you will need
to run a regression analysis using collected power data for calibration. Microsoft Excel’s LINEST
function makes this task relatively simple. You will need the following things:
?collected current data (1 or 2 weeks’ data in most cases)
?collected power data (24 or 48 hours’ data in most cases)
?a version of Microsoft Excel which has the LINEST built-in function
This application note uses graphics from a PC environment with Excel version 7.0. The
instructions, however, apply to older versions of Excel and to Macintosh environments, also. This
application note will not explain every detail about the LINEST function. For further information
about LINEST, refer to the Excel manual or HELP tools. This application note also assumes that
the reader knows how to use the Excel application.
Regression Using Excel LINEST
1….