(877) 729-0812
We connect to your computer over the Internet to...
Answer
how can u get the pc download to Xbox
Problem for Microsoft Excel for PC
How do I run a regression analysis in Excel
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...
Clarification Request
Posted by chargeo1 on May 13, 2008
thats that fancy thing with pivot charts correct?
im pretty sure i remember how to get the line, but ill have to check, its been a while since i took the course.
Best Solution
posted on May 13, 2008
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!
kpenguin
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!
kpenguin
Yes
No
Popular Solutions for Microsoft Excel for PC
Questions and Unsolved Problems for Microsoft Excel for PC
Do you recommend Microsoft Excel for PC?
Answer
Answer
I am writing a user spreadsheet that requires a couple of drop down choices to prompt automatic cell...
(More)
Answer
what is formula to use 5 point drop down list to prompt entry of cell value into specific location
Answer
using an excel sheet, assume that sum of some cells is 100.77 and i want to use this sum in other...
(More)
Answer
microsoft end user license agreement Excel shows at startup in registered program
Ask our Experts
Top Business and... Experts
Top Computer & Laptop Repair
Best Business and Productivity
Recommended by Owners
Recommended by Owners
