I think there is a positive correlation between the number of people who own guns and the death rate by gun violence around the world. To test my hypothesis I found some statistics about the number of guns per 100 people and the number of gun related deaths per 100000 people for 8 different countries. I conducted a correlation using MS Excel. The results are shown in this image below. Inspect the MS Excel output. Write out the step 5 answer by including both the formal answer and the conclusion. Please NOTE that you ONLY need to provide Step 5. Assume α = 0.05 and round your r-value to 2 decimal places

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
I think there is a positive correlation between the number of people who own guns and the death rate by gun violence around the world. To test my hypothesis I found some statistics about the number of guns per 100 people and the number of gun related deaths per 100000 people for 8 different countries. I conducted a correlation using MS Excel. The results are shown in this image below. Inspect the MS Excel output. Write out the step 5 answer by including both the formal answer and the conclusion. Please NOTE that you ONLY need to provide Step 5. Assume α = 0.05 and round your r-value to 2 decimal places.
Guns per 100 people
Guns deaths per 100000 people
SUMMARY OUTPUT
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
Regression
Residual
Total
Regression Statistics
Guns per 100 people Guns deaths per 100000 people
1
Intercept
Guns per 100 people
0.576197636
0.576197636
0.332003715
0.220671001
3.075158653
df
Coefficients
8
1
6
7
2.530378007
0.065628102
SS
1
MS
F
28.20039557 28.2004 2.982086
56.73960443 9.456601
Standard Error
84.94
Significance F
0.134937042
t Stat P-value
Lower 95%
Upper 95%
Lower 95.0% Upper 95.0%
1.554918032 1.627339 0.154789 -1.274369353 6.335125366 -1.274369353 6.335125366
0.038004041 1.726872 0.134937 -0.027364435 0.15862064 -0.027364435 0.15862064
Transcribed Image Text:Guns per 100 people Guns deaths per 100000 people SUMMARY OUTPUT Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Regression Statistics Guns per 100 people Guns deaths per 100000 people 1 Intercept Guns per 100 people 0.576197636 0.576197636 0.332003715 0.220671001 3.075158653 df Coefficients 8 1 6 7 2.530378007 0.065628102 SS 1 MS F 28.20039557 28.2004 2.982086 56.73960443 9.456601 Standard Error 84.94 Significance F 0.134937042 t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 1.554918032 1.627339 0.154789 -1.274369353 6.335125366 -1.274369353 6.335125366 0.038004041 1.726872 0.134937 -0.027364435 0.15862064 -0.027364435 0.15862064
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman