Based on these data, multiple regression model equations can be obtained to predict per capita consumption which is influenced by paper consumption, fish consumption and fuel oil consumption. From Microsoft Excel processing, the following data are obtained: Question : a. Make a multiple regression equation model! b. How is the hypothesis testing based on each independent variable! c. Based on the answer to b how to model the enhanced multiple regression equation
Correlation
Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.
Linear Correlation
A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.
Regression Analysis
Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.
Based on these data, multiple regression model equations can be obtained to predict per capita consumption which is influenced by paper consumption, fish consumption and fuel oil consumption. From Microsoft Excel processing, the following data are obtained:
Question :
a. Make a multiple regression equation model!
b. How is the hypothesis testing based on each independent variable!
c. Based on the answer to b how to model the enhanced multiple regression equation
![Country
Fish
Consumption
per capita
Oil
Раper
Consumptions
(kg/1000
реople)
consumption
consumption
(kg)
1000
barrels/day
5454
Japan
Portugal
United States
19700
5570
76892
24126
158.7
132.7
277
84579
6860
15641
17033
430
16500
47
Venezuela
Greece
2090
4490
31.1
42.1
331
Italy
Norway
United
10790
13400
9040
43098
41575
52355
44.3
90.6
43.9
1936
183
1803
Kingdom
Philippines
640
940
76.3
235](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb61d18fe-9bf6-422d-9538-66e8f996a2a8%2Fd2a2e4d1-33db-49b5-9bd4-85bf0209c4c2%2Frgaxdf4_processed.png&w=3840&q=75)
![OUTPUT
Regression Statistics
Multiple R
0,9677869
R Square
0,9366114
Adjusted R Square
0,8985783
Standard Error
2084,9394
Observations
9
ANOVA
Significance
df
SS
MS
F
F
Regression
321148160,6 107049387 24,62619 0,002013655
Residual
21734861,62
4346972,3
Total
8
342883022,2
Standard
Upper
Coefficients
Error
t Stat
P-value
Lower 95%
95%
-538,2796
1556,378436
0,3458539
0,74352
-4539,07774 3462,5185
Intercept
X Variable 1
X Variable 2
0,2336803
0,04397761
5,3136194
0,00315
0,12063223
0,3467283
18,087993
18,48045874
0,9787632
0,37264
-29,4175389
65,593524
X Variable 3
-0,211649
0,228690877
0,9254819
0,39718
-0,79951787
0,3762193](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb61d18fe-9bf6-422d-9538-66e8f996a2a8%2Fd2a2e4d1-33db-49b5-9bd4-85bf0209c4c2%2Fiqdkaij_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)