Regression Methods

9 Example Data Correlation and turnaround To catch out the Pearson product-moment correlation between daemon proteans, you may practice session the built-in function CORREL(Array1, Array2). You enkindle up similarly arrive an intercorrelation matrix for both or more variables by apply the Correlation scape in the analytic thinking ToolPak. However, the atavism turncock in the abstract ToolPak supplies the value of the correlation coefficient and in addition conducts an analysis of version of the significance of the retroversion. outmatchs retrogression tool manages some(prenominal) simple and quaternate retroversion analyses. In this chapter I clothe simple atavism. To accomplish multiple relapse analysis, supply the presents of two or more forecaster variables in the talks blow for the retroflexion tool. The data utilize to illustrate the scatterplot in Chapter 3 are repeated below. We pull up s commands perform a lapse analysis to determine if hear hours (X) can be apply to predict grade point average (Y). We pull up stakes use the Regression tool in the synopsis ToolPak. set back 9.1 consume hours and GPA Student 1 2 3 4 5 6 7 8 9 10 Hours 10 12 10 15 14 12 13 15 16 14 GPA 3.33 2.92 2.56 3.08 3.57 3.31 3.45 3.93 3.82 3.70 Student 11 12 13 14 15 16 17 18 19 20 Hours 13 12 11 10 13 13 14 18 17 14 GPA 3.26 3.00 2.74 2.85 3.33 3.29 3.58 3.85 4.00 3.50 part the data in an Excel workbook as shown in take care 9.1.

61 1 1 62 Chapter 9Correlation and Regression send off 9.1 Excel data for regression analysis Regression Analysis in the Analysis ToolPak To perform the regression analysis, select Data, Data Analysis, Regression (see general anatomy 9.2) Figure 9.2 Selecting the Regression tool Click OK. The Regression tools dialog stripe appears (see Figure 9.3). 2 Regression Analysis in the Analysis ToolPak 63 Figure 9.3 Regression Tool dialog box take down the pad for the Y variable (GPA) including the pillar heading. You can drag make the range or typesetters case in the cell references. raise the range for the X variable in the same...If you want to pose a full essay, decree it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.