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 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.
For privacy and security, delivered files are not available for public download. The student who placed this order can sign in to access the delivered work from their dashboard.
Post your assignment and receive offers from verified writers in your subject area.
Post a new assignment Back to latest orders