Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Regression Analysis on Excel
Hi,
I need to perform a regression analysis on three different stock quotes in order to identify a potential trend and future prices. I have past price information for all of them, I simply do not know how to perform the specific statistics fictions on excel. I have installed the "data analysis" tool on excel, and have been able to generate accurate correlations between them. But, I need something that will allow me to determine future prices based on movements (percent change) of these three stocks compared to each other. Excel is, what I think, the best way to do this. Can anyone help me out? Thanks! :D |
#2
|
|||
|
|||
Quote:
The link below gives some information on how to perform regression analysis. http://office.microsoft.com/en-us/ex...001111963.aspx If you want instant help, it might be an idea to attach some sample data that we can have a look at. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Analysis on Excel | Excel Worksheet Functions | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Excel 2007; graph the best fit line from a regression analysis? | Charts and Charting in Excel | |||
regression analysis in excel 2007? | Excel Discussion (Misc queries) | |||
screening regression analysis in Excel | Excel Discussion (Misc queries) |