You have been asked to determine if the hourly rate of a dispatch position in Madison, Dane county is comparable to the wages paid to dispatchers in surrounding cities and counties. The average hourly wage in those areas is $25.00. You will be using Excel for this exercise.
City of Madison, Dane county
Hourly wages for Dispatchers
23.75
32.25
24.50
26.75
28.25
30.50
31.75
24.50
23.45
28.00
31.25
24.80
26.70
31.60
28.75
29.25
a) Create an excel spreadsheet for this data to find the mean, standard deviation, variation, and range.
b) Write out a null and alternative (research) hypothesis for this.
c) Find the 95% confidence interval for this data. Use two decimal points.