How do I use excel to find the regression equation, letting the first variable be the predictor (x) variable. Find the best predicted Nobel Laureate rate for a country that has 78.6 internet users per 100 people. How does it compare to the country's actual Nobel Laureate rate of 1.5 per 10 million people? The data tab does not show up on my excel.
Equations and Inequations
Equations and inequalities describe the relationship between two mathematical expressions.
Linear Functions
A linear function can just be a constant, or it can be the constant multiplied with the variable like x or y. If the variables are of the form, x2, x1/2 or y2 it is not linear. The exponent over the variables should always be 1.
How do I use excel to find the regression equation, letting the first variable be the predictor (x) variable. Find the best predicted Nobel Laureate rate for a country that has 78.6 internet users per 100 people. How does it compare to the country's actual Nobel Laureate rate of 1.5 per 10 million people?
The data tab does not show up on my excel.
To run regression, enable the data analysis by following the steps below :
- Go to files then click options.
- Click customize ribbon and under main tab tick data and click ok.
- After the data tab is visible in the ribbon check for data analysis, if present then fine if not follow the given steps.
- Go to options and click add ins.
- Click analysis tool pack and then go.
- After this tick analysis tool pack and click ok.
The data analysis tool pack will appear.
| Internet Users per 100 |
Nobel Laureates |
| 79.5 | 5.4 |
| 79.6 | 24.3 |
| 78.4 | 8.6 |
| 44.7 | 0.1 |
| 83.3 | 6.2 |
| 38.1 | 0.1 |
| 90.7 | 25.4 |
| 88.8 | 7.6 |
| 79.4 | 8.9 |
| 82.9 | 12.6 |
| 52.7 | 1.9 |
| 77.6 | 12.7 |
| 56.7 | 3.3 |
| 78.5 | 1.5 |
| 91.8 | 11.4 |
| 94 | 25.7 |
| 64.4 | 3.1 |
| 57.5 | 1.9 |
| 67.5 | 1.7 |
| 93.9 | 32 |
| 85.1 | 31 |
| 86.2 | 18.9 |
| 78.5 | 10.8 |
Step by step
Solved in 2 steps with 1 images
