Question
In the production of a certain metal, we suspect that monthly production (Y) in tons is dependent on the number of people working (X 1
In the production of a certain metal, we suspect that monthly production (Y) in tons is dependent on the number of people working (X1) in the factory and the amount of water used (X2), in cubic meters. The table below shows the data.
| Production | Number of People | water (m3) |
|---|---|---|
| 7107 | 129 | 3067 |
| 6373 | 141 | 2828 |
| 6796 | 153 | 2891 |
| 9208 | 166 | 2994 |
| 14792 | 193 | 3082 |
| 14564 | 189 | 3898 |
| 11964 | 175 | 3502 |
| 13526 | 186 | 3060 |
| 12656 | 190 | 3211 |
| 14119 | 187 | 3286 |
| 16691 | 195 | 3542 |
| 14571 | 206 | 3125 |
| 13619 | 198 | 3022 |
| 14575 | 192 | 2922 |
| 14556 | 191 | 3950 |
| 18573 | 200 | 4488 |
| 15618 | 200 | 3295 |
1. Write down the generic form of a regression line with two independent variables.
2. Identify the null and alternative hypotheses for this MLR.
3. Using Excel, find the following:
- Adjusted r2 value
- Equation of the regression line
- p-Value for the regression
- Whether or not the correlation is statistically significant (<0.03)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Introductory Algebra Concepts And Graphs
Authors: Charles P McKeague
1st Edition
1630980110, 9781630980115
