## Lesson 11

February 25, 2015

**Wed, Feb 25**

Review:

- Multiple Regression in Excel, Google Sheets

Presentation:

- t-test: significance of regression coefficients
- F-test: significance of overall model

Assignment:

**Read Section 12.7 p. 495-500**Test of Slope and Test of Overall Model (Simple Regression)**Read Section 13.2 p. 531-533**Significance tests for Overall Model and Regression Coefficients**Calculate the t test of slope and F-test of Overall Model**for the 3 linear regression models produced in Exam 1, part 1 (i.e., calculate t and F for the Americas, EMEA, and AsiaPac models)- Determine the
**t test statistics**for each coefficient in the Database problems assigned in Lesson 10. - Determine the
**F-statistic**for each model produced in the Database problems assigned in Lesson 10.