Two-Variable Statistics (Chapter 3)
Lesson 4: Use of Technology for Regression Analysis (3.1 to 3.3)
In this course, we are using Microsoft Excel to perform regression analysis
In this course, we are using Microsoft Excel to perform regression analysis
Video 1: How to Install Excel 2007 Data Analysis Add-In
Just in case if you have not done so!
Video 2: Excel Basics for Linear Regression (2003-2007 version)
Video 3: Determine Correlation Coefficient Using Excel 2007 with Brief Explanation
Video 4: Perform a Linear Regression Using Excel 2007
Video 5: Perform a Quadratic Regression Using Excel 2010
It is important to change the labels to make your analysis more meaningful in everyday applications
Video 6: Linear vs. Exponential Regression Using Excel 2010
Choose the one with a higher Coefficient of Determination r²
How to Predict Using Excel
Read p. 189: Solution 2 for Example 2 part (c)
- Enter the equation for the line or curve of best fit as a formula in one cell (Cell B14)
- Enter the value you use for the prediction in another cell (Cell A13)
Note: Make sure you use the right referenced cell in your formula
- Enter the equation for the line or curve of best fit as a formula in one cell (Cell B14)
- Enter the value you use for the prediction in another cell (Cell A13)
Note: Make sure you use the right referenced cell in your formula
Assigned Practices:
1. eBook: Do exercises on p. 191 - #2, #4, #6 and #7
Assignment (Due via email on Oct. 3, 2014 by 11:59 pm):
1. eBook 3.3: Do exercises on p. 192 - #3 and #5
Use only one Excel file and name it using the format MDM4U_Assign4_Yourfullname.
Within the file, use one worksheet for each question.
Ms. Chor's Email: [email protected]
Late Assignment: 10% deducted per day (after Oct. 3, 2014 11:59 pm) Max. 30%