[Blindmath] A Question About Excel and JAWS

[Godfrey, Jonathan]

Hi Trevor,

If you want to fill downwards from a cell with a formula in it already, highlight the range and hit ctrl+D

For example, I entered a 1 in cell A1. I then typed =1+a1 into cell A2. I then highlighted from A2 downwards to some point and hit ctrl+D which worked.

I still use the hotkey presses that were for the old style menu items. Filling downwards was alt+E, I, D
The last D for down gets changed to R U or L for the other directions.


Btw: did you really mean biplots? To me, a biplot is a specialised form of graph for depicting a principal component analysis using points and arrows. If regression is the context in which you are working I think a bivariate plot or scatter diagram are examples of the terminology that is more accurate. 

Jonathan


-----Original Message-----
From: Blindmath [mailto:blindmath-bounces at nfbnet.org] On Behalf Of Trevor Attenberg via Blindmath
Sent: Saturday, 22 November 2014 5:25 p.m.
To: 'Blind Math list for those interested in mathematics'
Subject: [Blindmath] A Question About Excel and JAWS

                Hey Blind  Mathemagicians list,

I have two questions for the knowing that I wasn't able to answer via the Blind Math List archives. They should be pretty easy.

First: is there a way to drag a formula through a column, row, or block of values using JAWS on a laptop? You know how a mouse user can drag a formula, and thus not need to type said formula over and over again? Never have I figured a means or analogue for this by way of JAWS. JAWS manuals do provide a dragging command, but this hasn't worked for me. Perhaps I am missing something. I've tried with and without the JAWS cursor.

Second and finally, I would like to know how to independently retrieve regression stats within excel. I am able to generate biplots etc. from the menu bar, but I haven't been able to figure out how to find R2 values and the like. This seems like pretty important stuff. Perhaps I should simply learn to do it in R? There's a thread that discusses Excel and regression from close to a decade ago, but this doesn't seem particularly helpful-perhaps it is no longer accurate.

Thank you for your time, and in advance for your help.

Trevor

           

_______________________________________________
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/a.j.godfrey%40massey.ac.nz
BlindMath Gems can be found at <http://www.blindscience.org/blindmath-gems-home>