Multiple Correlation and Multiple Regression

Thomas J. Quirk
Additional contact information
Thomas J. Quirk: Webster University

Chapter Chapter 7 in Excel 2007 for Educational and Psychological Statistics, 2012, pp 147-162 from Springer

Abstract: Abstract There are many times in educational and psychological research when you want to predict a criterion, Y, but you want to find out if you can develop a better prediction model by using several predictors to predict Y instead of a single predictor as we discussed in Chap. 6 of this book. The resulting statistical procedure is called “multiple correlation” because it uses two or more predictors, each weighed differently in an equation, to predict Y. The job of multiple correlation is to determine if using several predictors can do a better job of predicting Y than any single predictor by itself. The equation for multiple correlation is presented, explained, and a practical business problem is used to present the Excel commands needed to find the multiple correlation and the multiple regression equation generated from the data set. Excel commands are also used to create a SUMMARY OUTPUT which gives the coefficients needed to write the multiple regression equation for the data. Finally, the Excel commands needed to find the correlation between all the variables are explained so that you can create a “correlation matrix” for your data set. You will learn how to read this correlation matrix to determine the correlation between any two variables in your study. Three practice problems are given at the end of the chapter to test your Excel skills, and the answers to these problems appear in Chap. 9 of this book. An additional practice problem is presented in the Practice Test given in Chap. 10 along with its answer in Chap. 11 of this book.

Keywords: Correlation Matrix; Decimal Place; Point Score; Read Score; National Football League (search for similar items in EconPapers)
Date: 2012
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sprchp:978-1-4614-3725-3_7

Ordering information: This item can be ordered from
http://www.springer.com/9781461437253

DOI: 10.1007/978-1-4614-3725-3_7

Access Statistics for this chapter

More chapters in Springer Books from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().