Suppose we want to estimate (1) In Excel's main tool bar, click-on TOOLS, DATA ANALYSIS, then double-click-on REGRESSION

[answerhappygod]

Suppose We Want To Estimate 1 In Excel S Main Tool Bar Click On Tools Data Analysis Then Double Click On Regression 1 (46.27 KiB) Viewed 38 times

Suppose we want to estimate (1) In Excel's main tool bar, click-on TOOLS, DATA ANALYSIS, then double-click-on REGRESSION. A regression pop-box appears. 1. Next to Input Y Range, type a1:a6 (this includes the variable name, wage) 2. Next to Input X Range, type b1;b6. It is usually useful to place the X′​ s to the left of Y. 3. Because we have variable labels in the first row, click Labels. Excel will use the variable names in the output. 4. In order to make Excel print out the residuals, click-on Residuals. 5. Finally, click-on OK. Excel will automatically send the output to a new sheet (if this is your first regression, Excel will send the output to Sheet 4). You can navigate amongst the sheets by using the tabs at the bottom of the screen. Useful Shortcut: Instead of physically typing the X and Y-data cell ranges, try the following simple trick. First, click-on the white area next to Input Y Range. This places the cursor in the area. Then, click-and-hold the mouse in the first cell containing the Y-data, in our case, cell A1. Now, drag over the remaining Y-data cells, in this case cells A2-A6. Once you release the mouse button, Excel will automatically enter the data cells. Finally, perform the same task for the X-data cells, and proceed as explained above.