hi,
In Excel, There are two functions that calculate slope and intercept.
you can use them.
For the equation to be automatically written at any cell of desire;
Just use the combination of concatenate function and calculate the
slope and intercept using the above said functions at the same cell.
It
Dear Rekha,
Greetings!
I used to solve manually. Firstly find the slope of the regression
equation by identifying the independent variable and the dependent
variable. Then find the value of the intersept. When one has the
values of the slope and intersept, it is easy to find the regression
equatio
hello,
yes. it is possible to find a linear regression line.
here, 2 things can be done in excel.
firstly, finding a regression line in the scatter diagram itself.
but beware! screen readers will not help you out with scatter diagrams.
secondly,
estimating the value of dependent variable on the bas
Dear All
Could anybody please tell me about how to find a regression line for a
table of figures we have in XL.
I s it possible to find such a regression line?
Thanks & Best wishes
Rekha
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http: