Question

Provide summary statistics for ?, ?1, ?2. In particular, what is the mean, median, and standard deviation across your 51 observations? Report the results for two simple least-squares regression estimates: ? on ?1 and ? on ?2. For each regression, your report should include the estimate of the intercept, the estimate of the coefficient on the ? variable, as well as the standard error and P-value for each of those estimates. And in words, interpret these results. (How should we interpret the intercepts? What about the slope coefficients? What about the P-values?)  

State Name	X1 /Total of NICS Firearm Background Checks (12 months)	X2/ Gun Ownership	Y/ Gun Murder Rate per 100K
Alabama	737,509	51.70%	2.8
Alaska	85,621	57.80%	2.7
Arizona	331,442	31.10%	3.6
Arkansas	257,346	55.30%	3.2
California	1,761,079	21.30%	3.4
Colorado	454,062	34.70%	1.3
Connecticut	307,750	16.70%	2.7
Delaware	50,416	25.50%	4.2
District of Columbia	742	3.60%	16.5
Florida	1,147,082	24.50%	3.9
Georgia	566,946	40.30%	3.8
Hawaii	2,066	6.70%	0.5
Idaho	15,290	55.30%	0.8
Illinois	136,946	20.20%	2.8
Indiana	1,247,398	39.10%	2.2
Iowa	1,076,917	42.90%	0.7
Kansas	147,309	42.10%	2.2
Kentucky	185,859	47.70%	2.7
Louisiana	3,218,371	44.10%	7.7
Maine	372,613	40.50%	0.8
Maryland	94,744	21.30%	5.1
Massachusetts	18	12.60%	1.8
Michigan	125,694	38.40%	4.2
Minnesota	167,285	41.70%	1
Mississippi	500,921	55.30%	4
Missouri	519,244	41.70%	5.4
Montana	252,372	57.70%	1.2
Nebraska	584,875	38.60%	1.8
Nevada	127,705	33.80%	3.1
New Hampshire	79,340	30.00%	0.4
New Jersey	127,480	12.30%	2.8
New Mexico	136,816	34.80%	3.3
New York	90,034	18.00%	2.7
North Carolina	147,912	41.30%	3
North Dakota	346,048	50.70%	0.6
Ohio	531,876	32.40%	2.7
Oklahoma	69,429	42.90%	3
Oregon	748,502	39.80%	0.9
Pennsylvania	359,276	34.70%	3.6
Rhode Island	276,126	12.80%	1.5
South Carolina	993,429	42.30%	4.5
South Dakota	15,892	56.60%	1
Tennessee	22,129	43.90%	3.5
Texas	326,997	35.90%	3.2
Utah	100,268	43.90%	0.8
Vermont	654,192	42.00%	0.3
Virginia	1,574,266	35.10%	3.1
Washington	254,814	33.10%	1.4
West Virginia	34,588	55.40%	1.5
Wisconsin	1,342	44.40%	1.7
Wyoming	462,997	59.70%	0.9

Answer 1

State Name	X1 /Total of NICS Firearm Background Checks (12 months)	X2/ Gun Ownership	Y/ Gun Murder Rate per 100K
Alabama	737,509	51.70%	2.8		X1			X2			Y
Alaska	85,621	57.80%	2.7		Column1			Column1			Column1
Arizona	331,442	31.10%	3.6
Arkansas	257,346	55.30%	3.2		Mean	428026.9608		Mean	0.36945098		Mean	2.7941176
California	1,761,079	21.30%	3.4		Standard Error	79815.04021		Standard Error	0.01968958		Standard Error	0.3450196
Colorado	454,062	34.70%	1.3		Median	254814		Median	0.398		Median	2.7
Connecticut	307,750	16.70%	2.7		Mode	#N/A		Mode	0.553		Mode	2.7
Delaware	50,416	25.50%	4.2		Standard Deviation	569993.3972		Standard Deviation	0.14061171		Standard Deviation	2.4639328
District of Columbia	742	3.60%	16.5		Sample Variance	3.24892E+11		Sample Variance	0.01977165		Sample Variance	6.0709647
Florida	1,147,082	24.50%	3.9		Kurtosis	11.11129045		Kurtosis	-0.2837093		Kurtosis	18.975188
Georgia	566,946	40.30%	3.8		Skewness	2.917588609		Skewness	-0.5080621		Skewness	3.6337493
Hawaii	2,066	6.70%	0.5		Range	3218353		Range	0.561		Range	16.2
Idaho	15,290	55.30%	0.8		Minimum	18		Minimum	0.036		Minimum	0.3
Illinois	136,946	20.20%	2.8		Maximum	3218371		Maximum	0.597		Maximum	16.5
Indiana	1,247,398	39.10%	2.2		Sum	21829375		Sum	18.842		Sum	142.5
Iowa	1,076,917	42.90%	0.7		Count	51		Count	51		Count	51
Kansas	147,309	42.10%	2.2
Kentucky	185,859	47.70%	2.7
Louisiana	3,218,371	44.10%	7.7		Y on X1
Maine	372,613	40.50%	0.8		SUMMARY OUTPUT
Maryland	94,744	21.30%	5.1
Massachusetts	18	12.60%	1.8		Regression Statistics
Michigan	125,694	38.40%	4.2		Multiple R	0.177616087
Minnesota	167,285	41.70%	1		R Square	0.031547474
Mississippi	500,921	55.30%	4		Adjusted R Square	0.011783137
Missouri	519,244	41.70%	5.4		Standard Error	2.449373327
Montana	252,372	57.70%	1.2		Observations	51
Nebraska	584,875	38.60%	1.8
Nevada	127,705	33.80%	3.1		ANOVA
New Hampshire	79,340	30.00%	0.4			df	SS	MS	F	Significance F
New Jersey	127,480	12.30%	2.8		Regression	1	9.57618	9.57618015	1.59618174	0.2124
New Mexico	136,816	34.80%	3.3		Residual	49	293.972	5.999429697
New York	90,034	18.00%	2.7		Total	50	303.548
North Carolina	147,912	41.30%	3
North Dakota	346,048	50.70%	0.6			Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Ohio	531,876	32.40%	2.7		Intercept	2.465483678	0.43046	5.727529362	6.1358E-07	1.6004	3.330529414	1.6004379	3.33052941
Oklahoma	69,429	42.90%	3		X Variable 1	7.67788E-07	6.1E-07	1.263400864	0.21242345	-5E-07	1.98904E-06	-4.53E-07	1.989E-06
Oregon	748,502	39.80%	0.9
Pennsylvania	359,276	34.70%	3.6
Rhode Island	276,126	12.80%	1.5		Y on X2
South Carolina	993,429	42.30%	4.5
South Dakota	15,892	56.60%	1		SUMMARY OUTPUT
Tennessee	22,129	43.90%	3.5
Texas	326,997	35.90%	3.2		Regression Statistics
Utah	100,268	43.90%	0.8		Multiple R	0.328118736
Vermont	654,192	42.00%	0.3		R Square	0.107661905
Virginia	1,574,266	35.10%	3.1		Adjusted R Square	0.089450923
Washington	254,814	33.10%	1.4		Standard Error	2.35115106
West Virginia	34,588	55.40%	1.5		Observations	51
Wisconsin	1,342	44.40%	1.7
Wyoming	462,997	59.70%	0.9		ANOVA
						df	SS	MS	F	Significance F
					Regression	1	32.6806	32.68058115	5.91192212	0.0187
					Residual	49	270.868	5.527911309
					Total	50	303.548
						Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
					Intercept	4.918316753	0.93361	5.268051797	3.0664E-06	3.0422	6.794480418	3.0421531	6.79448042
					X Variable 1	-5.749610147	2.36469	-2.431444451	0.01874148	-10.5	-0.997589614	-10.50163	-0.9975896