![]() If you added headers in the first cells of each column, click the check box next to "Labels."Ĭlick the radio button next to "Output Range" then place your cursor into the text box next to the radio button and click on cell C1.Ĭlick "OK" and your regression table will appear on the spreadsheet starting in cell C1. The closer to 1, the better the regression line (read on) fits the data. 96 of the variation in Quantity Sold is explained by the independent variables Price and Advertising. R Square equals 0.962, which is a very good fit. Place your cursor into the "Input X Range" text box and repeat the process to select the data set that holds your independent, or explanatory, variables. Excel produces the following Summary Output (rounded to 3 decimal places). Tabel Summary output ini melaporkan kekuatan hubungan antara model (variabel bebas) dengan variabel terikat. Tampilan pertama dari output regresi Excel sebagai berikut: Tabel 1. Now click and hold on the top cell in the column that contains your dependent variables, drag the mouse down to the last data-holding cell in that column and release the mouse button. Oleh karenanya, untuk bisa memahami tulisan ini, sebaiknya terlebih dahulu membaca tulisan yang disebutkan diatas. Place your cursor into the "Input Y Range" text box. Select "Regression" from the list that appears in the Data Analysis window and then click "OK." If desired, you can add headers to your data in cells A1 and B1 so that you can tell the data sets apart.Ĭlick on the "Data" tab at the top of the Excel window and then click the "Data Analysis" button when it appears on the ribbon. Repeat the process with your second set of values down the second column. Continue to enter the rest of the set of values down the cells in the first column. This video shows how to generate simple linear regression statistics using the Data Analysis Addin in Excel intercept, slope, regression equation, SSR, SSE. Select cell A1 and enter the first value for your first set of values. ![]() Click the small check box next to "Analysis ToolPak" and click "OK." You will now have access to the regression feature. Click on "Add-Ins" on the left side of the Options window and then click "Go" when the button appears at the bottom of the Options window. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |