Regression Methods

9 Example Data Correlation and turnaround To pose the Pearson product-moment correlation between cardinal multivariates, you may practice seance the built-in function CORREL(Array1, Array2). You disregard up similarly get along an intercorrelation matrix for two or more variables by use the Correlation marionette in the analytic thinking ToolPak. However, the retrogression peckerwood in the summary ToolPak supplies the value of the correlation coefficient and in addition conducts an analysis of difference of the significance of the retroversion. excels retroflection tool manages some(prenominal) simple and octuple reverse analyses. In this chapter I blow up simple retroversion. To accomplish multiple fixing analysis, supply the presents of two or more soothsayer variables in the talks package for the throwback tool. The data utilise to illustrate the scatterplot in Chapter 3 are repeated below. We depart perform a regression analysis to determine if adopt hours (X) can be utilise to predict grade point average (Y). We depart use the Regression tool in the epitome 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 devote the data in an Excel workbook as shown in precede care 9.1.

61 1 1 62 Chapter 9Correlation and Regression project 9.1 Excel data for regression analysis Regression Analysis in the Analysis ToolPak To perform the regression analysis, select Data, Data Analysis, Regression (see bet 9.2) Figure 9.2 Selecting the Regression tool Click OK. The Regression tools duologue stripe appears (see Figure 9.3). 2 Regression Analysis in the Analysis ToolPak 63 Figure 9.3 Regression Tool dialog box take down the get for the Y variable (GPA) including the tugboat heading. You can drag do the range or instance in the cell references. usher in the range for the X variable in the same...If you want to rive a full essay, nightclub it on our website: Orderessay

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