Regression Methods

9
Example Data

Correlation and turnaround

To find the Pearson product-moment correlation between devil variables, you may practice session the built-in function CORREL(Array1, Array2). You sack up similarly derive an intercorrelation matrix for two or more variables by using the Correlation tool in the analytic thinking ToolPak. However, the regress tool in the Analysis ToolPak supplies the value of the correlation coefficient and in addition conducts an analysis of variance of the significance of the retroversion. Excels Regression tool manages both simple and multiple regression analyses. In this chapter I deck simple regression. To accomplish multiple regression analysis, supply the presents of two or more predictor variables in the talks box for the Regression tool.

The data used to illustrate the scatterplot in Chapter 3 are repeated below. We will perform a regression analysis to determine if study hours (X) can be used to predict GPA (Y). We will use the Regression tool in the Analysis ToolPak.
Table 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

Place the data in an Excel workbook as shown in take care 9.1.





61 1 1

62

Chapter 9â€"Correlation and Regression

Figure 9.1 Excel data for regression analysis

Regression Analysis in the Analysis ToolPak
To perform the regression analysis, select Data, Data Analysis, Regression (see Figure 9.2)

Figure 9.2 Selecting the Regression tool

Click OK. The Regression tools dialog box appears (see Figure 9.3).

2

Regression Analysis in the Analysis ToolPak

63

Figure 9.3 Regression Tool dialog box

take down the range for the Y variable (GPA) including the column heading. You can drag done the range or type in the cell references. Enter the range for the X variable in the same...If you want to cohere a full essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper