"For XXIAO only"

profilekarmam1
week_4_dataset.xlsx
Home>Mathematics homework help>Numerical analysis homework help>"For XXIAO only"

Raw data

Year Number of crashes Alcohol Tax rate ($/gallon)
2004 11504
2005 11495
2006 11736 14.02
2007 11215 14.54
2008 10294 14.54
2009 9366 20.13
2010 8217 20.13
2011 8411 20.13
2012 8776 20.91
2013 8047 20.56
2014 7666 19.19

Histogram and Scatterplot

Descriptive Statistics

Column n Mean Variance Std. dev. Std. err. Median Range Min Max Q1 Q3
Number of crashes 11 9702.4545 2496543.9 1580.0455 476.40165 9366 4070 7666 11736 8217 11495
Alcohol Tax rate ($/gallon) 9 18.238889 8.6648111 2.9436051 0.98120171 20.13 6.89 14.02 20.91 14.54 20.13
95% confidence interval results:
μ : Mean of variable
Variable Sample Mean Std. Err. DF L. Limit U. Limit
Number of crashes 9702.4545 476.40165 10 8640.9655 10763.944
Shapiro-Wilk goodness-of-fit results:
Variable n Stat P-Value
Number of crashes 11 0.87500342 0.0899
Shapiro-Wilk goodness-of-fit results:
Variable n Stat P-Value
Alcohol Tax rate ($/gallon) 9 0.74893219 0.0053