Skip to main content

Multiple Correlation and Multiple Regression

  • Chapter
  • First Online:
Excel 2013 for Human Resource Management Statistics

Part of the book series: Excel for Statistics ((EXCELSTAT))

  • 917 Accesses

Abstract

There are many times in human resource management 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 human resource management 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 is 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 in the Practice Test given in Appendix B along with its answer in Appendix C of this book.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Subscribe and save

Springer+ Basic
EUR 32.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or Ebook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  • Aamodt M, Surrette M, and Cohen D. Understanding statistics: a guide for I/O psychologists and human resource professionals. Belmont: WADSWORTH CENGAGE Learning; 2007.

    Google Scholar 

  • Davis J H. Statistics for compensation: a practical guide to compensation analysis. Hoboken: John Wiley & Sons; 2011.

    Google Scholar 

  • Keller G. Statistics for management and economics. 8th ed. Mason: South-Western Cengage Learning; 2009.

    Google Scholar 

  • Levine D, Stephan D, Krehbiel T, Berenson M. Statistics for managers using Microsoft Excel. 6th ed. Boston: Pearson Prentice Hall; 2011.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this chapter

Cite this chapter

Quirk, T.J., Palmer-Schuyler, J. (2016). Multiple Correlation and Multiple Regression. In: Excel 2013 for Human Resource Management Statistics. Excel for Statistics. Springer, Cham. https://doi.org/10.1007/978-3-319-28982-3_7

Download citation

Publish with us

Policies and ethics