Correlation and Simple Linear Regression

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

Chapter Chapter 6 in Excel 2010 for Engineering Statistics, 2014, pp 111-154 from Springer

Abstract: Abstract Up until now in this book, you have been dealing with the situation in which you have had only one group or two groups of events or objects in your research study and only one measurement (i.e., variable) “number” on each of these. This chapter asks you to change gears again and to deal with the situation in which you are measuring two variables instead of only one variable, and you are trying to discover the “relationship” between these variables. For example, if one variable increases in value, does the other variable increase in value (i.e., a “positive” relationship) or decrease in value (i.e., a negative relationship), and is this relationship “weak” or “strong?” The formula for the correlation r is presented, explained, and the nine steps for computing a correlation are explained using a calculator example. Then, the Excel commands for computing a correlation are presented along with the Excel steps needed to create a chart summarizing the relationship between the two variables. You will learn how to use Excel to draw the “best-fit line” through the data points on a scatterplot and how to determine the equation for this line so that you can use this equation to predict one variable from the other variable. You will learn both how to print a chart by itself, and how to print both the table and the chart so that they fit onto a single page. 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.

Keywords: Regression Line; Decimal Place; Excel Spreadsheet; White Space; Advance Placement (search for similar items in EconPapers)
Date: 2014
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-3-319-02830-9_6

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

DOI: 10.1007/978-3-319-02830-9_6

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 ().