Data Analysis Project ( 2 Pages )

profileNanorp123
USgdpgrowth2000-2018Sample1.xlsx

Sheet1

US GDP per capita growth (annual %)
2000 2.975
2001 0.004 Summary Statistics
2002 0.802
2003 1.981 t-test statistic -2.3038949156 Mean 1.2161578947
2004 2.843 Standard Error 0.3402247646
2005 2.564 at significance level 0.05 (one tail test) Median 1.564
2006 1.868 t-critical value -1.7340636066 Mode ERROR:#N/A
2007 0.912 Standard Deviation 1.4830053669
2008 -1.077 Since the t-test statistic < t critical value, reject Ho. Sample Variance 2.1993049181
2009 -3.387 Kurtosis 4.4674684879
2010 1.717 Skewness -1.8390180459
2011 0.816 Range 6.362
2012 1.502 Minimum -3.387
2013 1.138 Maximum 2.975
2014 1.703 Sum 23.107
2015 2.125 Count 19
2016 0.835
2017 1.564
2018 2.222 Box Plot