First table is the data and second is the Regression analysis and anova table fr
ID: 3049971 • Letter: F
Question
First table is the data and second is the Regression analysis and anova table from the excel. My hypothesis is that as the population increases, more accidents will occur annually. Can you please help me analysing the data and determine if my hypothesis is correct or not. And also help generate regression equation and interprete all outputs of the table. like what r square, r and std. error p value etc represents.
Thank you!
Year Population | Total Accidents 20091566303 2044 2010 1515199 2545 2011 1524947 2560 2012 1539429 2690 2013 1561686 1961 2014 1610921 2110 Regression Analysis r2 0.518 r-0.720 Std. Error 244.088 Dep. Var. Total Accidents ANOVA table df 1 255,949.3515 4.30 4 59,578.9955 value .1069 Source MS Regression 255,949.3515 Residual 238,315.9819 Total 494,265.3333 Regression output confidence interval 95% upper variables coefficients std. error Intercept 12,455.8648 4,892.0614 0.0031 t (df-4) p-value 95% lower 2.546.0636 -1,126.6752 26,038.4049 2.073 1069 Population 0.0065 0.0153 0.0022Explanation / Answer
Answer to the question is as follows:
Hypothesis that as population increases more accidents will occir
annually isn't true. look at the p-value of regression, it' at .1069 which is
more than .05, and hence, we will conclude that Population is insignificant
Hypothesis is not correct in this case.
Other interpretations as asked by you
rsquare value is .518
correlation is -.720
p-value is .1069
stdev error for population is .0031,
The variable is statistically not significant
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.