[Blindmath] Performing Linear Regressions with Excel

[shane-blindmath at csy.ca]

Hmm I like the method in this tutorial but linest is an array function. How
do you enter those using Jaws without a mouse as there is more than one
return value. I've always used the data analysis tool pack to do this.

Shane

-----Original Message-----
From: blindmath-bounces at nfbnet.org [mailto:blindmath-bounces at nfbnet.org] On
Behalf Of Birkir Rúnar Gunnarsson
Sent: October-29-10 18:58
To: Blind Math list for those interested in mathematics
Subject: Re: [Blindmath] Performing Linear Regressions with Excel

Here is a fairly good tutorial and sample work sheet that should get
you on your way:
http://office.microsoft.com/en-us/excel-help/perform-a-regression-analysis-H
A001111963.aspx

Excel has what you need in this. You could go a longer way about this
if you wish, but these functions should get you what you need.
Cheers and good luck.
-B

On 10/30/10, Tina Hansen <th404 at comcast.net> wrote:
> In my current math course, I am being asked to create scattergrams of data
> and then perform linear regression, that is, add a line of best fit, to
the
> data and get an equasion. Since I don't have an audio graphing calculator
on
> my computer, I thought it would be good to try it with Excel. I was told
> that Excel could do what I need, but am not sure how to make it happen.
>
> I am running Excel 2003. If anyone out there can give me the steps for
> performing linear regression with Excel, I'd really appreciate your help.
> Thanks.
>
>
> _______________________________________________
> Blindmath mailing list
> Blindmath at nfbnet.org
> http://www.nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
> To unsubscribe, change your list options or get your account info for
> Blindmath:
>
http://www.nfbnet.org/mailman/options/blindmath_nfbnet.org/birkir.gunnarsson
%40gmail.com
>

_______________________________________________
Blindmath mailing list
Blindmath at nfbnet.org
http://www.nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
To unsubscribe, change your list options or get your account info for
Blindmath:
http://www.nfbnet.org/mailman/options/blindmath_nfbnet.org/shane-blindmath%4
0csy.ca