you lack data, type a formula such as: =A2-.2 (this indicates a decrease of 2 tenths of a unit per year from the score in cell A2 – assuming cell A1 contains the name of the variable, cell A2 would have the first score – you type the preceding formula in cell A3 – i.e., the first cell without data - other mathematical signs are * for multiply, + for add and / for division) and press “enter”; (3) Highlight the cell you just typed the formula in (e.g., A3) and as many cells as you want this same amount of change to extend; (4) Click on “Edit”; (5) Click on “Fill”; (6) Click on “Down” – or whatever direction you are going; (7) Click somewhere else to remove the highlight.
: 1 – open an Excel file; 2 – click on “Tools”; 3 – click on “Data
Analysis”; 4 – click on “Regression”; 5 – make sure that the dependent variable is either in Column A or the last column on the right; 6 - It is important to remember that Excel does not read letter variable names. Also, the variables need to be by column (i.e., one column per variable). For example, suppose your first column (i.e., column “A” in Excel) contains 100 observations on a variable named “CONS.” Excel can’t read the variable name “CONS.” Since the variable (i.e., column) contains 100 scores beginning with the second row and ending with the 101st row, enter the following in the box: $A$2:$A$101 (i.e., Excel will read cells A2 through A101). If “CONS” were the dependent variable (i.e., “y”) in a regression, then $A$2:$A$101 would go in the “y” box. In my case, the independent variables were in columns A through C and the dependent variable was in column D. It would appear handy to have the independent variables next to each other. Thus, if you have 4 variables (i.e., the dependent variable and three independent variables), make your dependent variable either the first, or last, column. In the “Input Range” box I entered: $D$2:$D$101 and in the “Input Range” box I entered: $A$2:$C$101 and check “Residuals” below.
Fill Command: To quickly fill a cell with the contents of an adjacent cell, you can press CTRL+D to fill
from the cell above or CTRL+R to fill from the cell to the left. To fill a cell with the contents of a cell below it (that is, to fill up), on the Home tab, in the Editing group, click Fill, and then click Up. To fill a cell with the contents of a cell to the right (fill left), on the Home tab, in the Editing group, click Fill, and then click Left.
Omitting Commas: To get rid of commas (i.e., thousands separator): (1)
highlight everything you want converted; (1) look for “General” in the middle of the heading on top; (2) change it to “Number” (this should “do it” – if not, click on the “,” icon – you’ll figure it out).
Getting “#NA” Rather than a Number when Cutting and Pasting: Highlight
what you want to cut and paste, click on “Paste Special” and look for a numbers option (e.g., 1 2 3 in a diagram that appears when you select “Paste Special”. Use the options with the right click on the mouse rather than “ctrl c” and “ctrl v” to copy and paste.