[Blindmath] {Spam?} RE: Graphing in excel

[Trevor Attenberg]

My impression was that there are graphing options in Excel that will
generate R^2 values, p vals, and so forth right there on the spot. My
trouble has been extracting the information from the section of the excel
sheet where the graphing appears. I wonder if the JAWS pc cursor or the NVDA
and Window Eyes equivalents would be of service in getting you in the right
area of the worksheet. I've not had much luck in this regard. By the way,
could you tell me how one does generate r^2 and respective p vals from data
columns in Excel? I do know the process in R.
Best,
Trevor
  

-----Original Message-----
From: Blindmath [mailto:blindmath-bounces at nfbnet.org] On Behalf Of Allan
Mesoga via Blindmath
Sent: Sunday, February 21, 2016 11:01 AM
To: Blind Math list for those interested in mathematics
Cc: Allan Mesoga
Subject: Re: [Blindmath] Graphing in excel

I don't know how to insert equations on the graph but copying equation from
cell to cell you may press ctrl+c on cell where your equation is located
then go to cell wher you want it to copy and press ctrl+v to paste it or
press application key and select paste special to give more options.
Hope it helps.

On 2/21/16, Sarah Jevnikar via Blindmath <blindmath at nfbnet.org> wrote:
> Hi there,
> I've fought with Excel graphs and am afraid I've thrown in the towel 
> and gotten sighted assistance. I'm sure others here will have better
ideas.
>
> As for the formulae question, you can do the following.
> 1. Type the formula in the first cell you want it in and press Enter 
> for it to be applied.
> 2. Press up arrow to return to the cell you just typed in.
> 3. Hold down the shift key and press down arrow until you reach the 
> last cell the formula should go in.
> 4. Press control-D. This will fill the column of cells with the 
> formula the first one contained.
> Notes:
> 1. If the column of cells is large, this can become tedious. You can 
> type Control-g (for Go To) and type the range of cells (C2:C52, for
instance).
> Then cells C2 through C52 are selected and you can type Control-d.
> 2. The formula will change based on the cell reference. For example, 
> if your initial formula in cell C1 was
> =A1+B1
> Your formula in C2 would be
> =A2+B2
> If you didn't want this to change, you'd use $. For instance,
> =$A$1+B1 would cause cell A1 to always be added to other cells (B2, 
> B3,
> etc.)
> 3. You can do the same thing with formulae or information along a row:
> Select for instance A1:Z1 with Control-g or shift+right arrow, with 
> contents in A1, and hit Control-r.
>
> I hope this helps,
> Sarah
>
>
> -----Original Message-----
> From: Blindmath [mailto:blindmath-bounces at nfbnet.org] On Behalf Of 
> Anna via Blindmath
> Sent: February-21-16 12:18 AM
> To: nabs-l at nfbnet.org; Nfb Science Email; blindmath at nfbnet.org
> Cc: annajee82 at gmail.com
> Subject: [Blindmath] Graphing in excel
>
> I use JAWS and Excel 2010.  I have to make a bunch of graphs and have 
> to use Excel.  I know how to make the graphs but I do not know how to 
> insert the equation for it and insert the R squared value and stuff 
> like that.  I know that with a mouse you right click on a data point 
> on the graph and then you can do it.  But I don't think you can do 
> that with JAWS so how could I do it?
> Also, I would like to insert some equations into some cells and drag 
> it down to other cells, instead of typing in the same equation over 
> and over in a bunch of cells.  With the mouse it's simply click, hold, 
> and drag.  How do you do it with JAWS?
> I would be very grateful for help. And if there is a more appropriate 
> place for me to be asking this question, please let me know.
>
> Thanks!
>
> Anna E Givens
>
>
> _______________________________________________
> Blindmath mailing list
> Blindmath at nfbnet.org
> http://nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
> To unsubscribe, change your list options or get your account info for
> Blindmath:
> http://nfbnet.org/mailman/options/blindmath_nfbnet.org/sarah.jevnikar%
> 40mail
> .utoronto.ca
> BlindMath Gems can be found at
> <http://www.blindscience.org/blindmath-gems-home>
>
>
> _______________________________________________
> Blindmath mailing list
> Blindmath at nfbnet.org
> http://nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
> To unsubscribe, change your list options or get your account info for
> Blindmath:
> http://nfbnet.org/mailman/options/blindmath_nfbnet.org/allan.mesoga%40
> gmail.com
> BlindMath Gems can be found at
> <http://www.blindscience.org/blindmath-gems-home>
>


--
Allan R. Mesoga
Copyreader
Learning Resources Production Division
Bureau of Learning Resources
Department of Education
Mobile number:  09198861145
Personal website:  http://www.armesoga.xtreemhost.com/

_______________________________________________
Blindmath mailing list
Blindmath at nfbnet.org
http://nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
To unsubscribe, change your list options or get your account info for
Blindmath:
http://nfbnet.org/mailman/options/blindmath_nfbnet.org/tattenberg%40gmail.co
m
BlindMath Gems can be found at
<http://www.blindscience.org/blindmath-gems-home>