Regression Analysis Microsoft® Excel®

3. Simple Regression

In This Chapter

Predicting with Correlation and Standard Scores

Predicting with Regression Coefficient and Intercept

Shared Variance

The TREND() Function

Partial and Semipartial Correlations

As I write this chapter, a program at the University of Virginia, called the Reproducibility Project, is getting considerable publicity for its work. That work consists of replicating published experiments to determine whether the findings stand up when the studies are repeated. The project expends considerable effort to ensure that the conditions that were in place when the experiment was originally conducted are maintained when it’s replicated. Even so, the findings in around 60% of the experiments are substantially weaker when repeated ...