The Department of Economic and Community Development (DECD) reported that in 2005 the average number of new jobs created per county was 450. The department also provided the following information regarding a sample of 5 counties in 2006.
County New Jobs Created In 2006
Bradley 410
Rhea 480
Marion 407
Grundy 428
Sequatchie 400
In Excel compute the sample average and the standard deviation for 2006.
We want to determine whether there has been a significant decrease in the average number of jobs created.
In Excel compute and report the test statistic. (z or t-score, just report the numeric value)