LASA 1: Linear Regression
penelop_eee
MAT106_module3_worksheet2.xlsYour Data
| 1 | 5 |
| 2 | 10 |
| 3 | 15 |
| 4 | 20 |
| Start with your data |
Chart
| 1 | 5 |
| 2 | 10 |
| 3 | 15 |
| 4 | 20 |
| Highlight the data | |
| Click Insert and then | |
| charts (use the Scatter chart) |
Your Chart
| 1 | 5 |
| 2 | 10 |
| 3 | 15 |
| 4 | 20 |
Your Chart
Linear Correlation and Regressi
| 1 | 5 | ||||||||||
| 2 | 10 | ||||||||||
| 3 | 15 | ||||||||||
| 4 | 20 | ||||||||||
| Directions: | |||||||||||
| 1. On the chart, right click on a data point. | |||||||||||
| 2. From the dropdown menu, choose Add Trendline. | 22.82 | ||||||||||
| 3. Click the boxes indicating you want to see the | |||||||||||
| correlation coefficient, and the equation. | |||||||||||
| For Example: This is a line with a perfectly linear R^2 value of 1, | |||||||||||
| and with the equation y= 5x. | |||||||||||
| A linear equation can be used to make predictions. |
