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 and explained, and a practical 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 of 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 Appendix A of this book. An additional practice problem is presented for each chapter in the Practice Test given in Appendix B along with answers in Appendix C of this book.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
ESPN. NFL Team Total Offense Statistics – 2009a. Retrieved December 9, 2010, from http://espn.go.com/nfl/statistics/team/_/stat/total/year/2009
ESPN. NFL Team Total Defense Statistics – 2009b. Retrieved December 9, 2010, from http://espn.go.com/nfl/statistics/team/_/stat/total/position/defense/year/2009
Keller, G. Statistics for Management and Economics (8th ed.). Mason, OH: South-Western Cengage Learning, 2009.
Levine, D.M., Stephan, D.F., Krehbiel, T.C., and Berenson, M.L. Statistics for Managers using Microsoft Excel (6th ed.). Boston, MA: Prentice Hall/Pearson, 2011.
National Football League. Standings [2009 Regular Season by league]. Retrieved December 9, 2010 http://www.nfl.com/standings?category=league&season=2009-REG&split=Overall
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
Copyright information
© 2012 Springer Science+Business Media, LLC
About this chapter
Cite this chapter
Quirk, T. (2012). Multiple Correlation and Multiple Regression. In: Excel 2010 for Educational and Psychological Statistics. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-2071-2_7
Download citation
DOI: https://doi.org/10.1007/978-1-4614-2071-2_7
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-2070-5
Online ISBN: 978-1-4614-2071-2
eBook Packages: Mathematics and StatisticsMathematics and Statistics (R0)