The data I have to work with is from *****! Finance which includes OPEN, HIGH, LOW, and CLOSING prices.

What I want to do is find the regression line with this data. I would like to use the least squares method to do so but am confused about how to go about it. I'm not sure exactly what data is suppose to be used for what variables? How would I set up the math?

Also, is there a way to do this in excel? I know how to use the regression analysis in excel but don't know what the dependent and independent variables would be for this data to find the regression equation.

Also, I want to plot two support and resitance lines, which would be two standard deviations from the regression line. How would I do this?

Thanks!!!