Question about Microsoft Excel for PC
What is the tool/steps to plot a regression curve/line against a set of points in excel? I have used this functionality many years back, but cant remember it now...
You probably want to use the LINEST function for straight lines or LOGEST for exponential curves.
In Excel 2007, there are a few tricks. One is to select a range of cells and enter your formula there. If you do not select a range of cells all the variables (coefficentis, R2, errors, etc) will not be dislayed.
The other tricks is one must hit Ctrl+Shift+Enter to display the results.
http://support.microsoft.com/kb/828533 is a link from Microsoft with a detailed explaination. Happy OLS regressing!
Posted on May 13, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 24, 2015 | Microsoft Excel for PC
Apr 22, 2013 | Microsoft Office Computers & Internet
Dec 09, 2010 | Microsoft Office Standard 2007: Windows
Jun 18, 2010 | Microsoft Office Excel 2007 Upgrade:...
Jan 28, 2010 | Microsoft Word 2000 for PC
Jul 10, 2009 | Microsoft Office Excel 2007
Dec 11, 2008 | Microsoft Computers & Internet
Nov 26, 2008 | Microsoft Excel for PC
Jul 23, 2008 | Microsoft Office Professional 2007 Full...
Mar 07, 2008 | Microsoft Office Professional 2007 Full...
Jan 28, 2016 | Microsoft Excel for PC
1,858 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: