5) Cost of Residential Water. On its municipal website, the city of Tulsa states that the rate it charges per 5 CCF of residential water is $21.62. How do the residential water rates of other US public utilities compare to Tulsa’s rate? The file ResidentialWater contains the rate per 5 CCF of residential water for 42 randomly selected US cities.
|Public Utility Company||Rate (5 CCF)|
|Orlando Utilities Commission||$10.48|
|Memphis Light, Gas and Water||$9.18|
|Central Arkansas Water||$11.80|
|City of Phoenix Water System||$6.50|
|City of Lincoln Water System||$12.42|
|San Antonio Water System||$14.53|
|Salt Lake City Public Utilities||$15.56|
|Nashville Metro Water Services||$10.12|
|City of Dover Water System||$14.50|
|Omaha Metropolitan Utilities District||$19.18|
|Jacksonville Electric Authority||$17.98|
|City of Dallas Water System||$12.85|
|City of St. Louis Water System||$16.80|
|Charleston Water System||$17.35|
|City of Clewiston Water System||$15.64|
|Springfield (IL) City Water, Light and Power||$14.80|
|City Of Milwaukee Water System||$18.91|
|Detroit Sewerage and Water Department||$17.99|
|City of Charlotte Water System||$14.90|
|Louisville Water Company||$18.42|
|City of Jackson (MS) Water System||$16.05|
|Las Vegas Valley Water District||$26.85|
|City of Columbus OH Water System||$22.32|
|City of Oklahoma City - Utilities||$22.76|
|Jackson TN Energy Authority||$20.98|
|Knoxville Utilities Board||$23.45|
|New York City Water Board||$19.05|
|Reno Truckee Meadows Water Authority||$23.70|
|Chattanooga American Water Company||$19.26|
|Marietta Board of Lights & Water||$23.75|
|City Utilities of Springfield MO||$27.80|
|Indianapolis Citizens Energy Group||$27.05|
|City of Philadelphia Water System||$27.14|
|LA Sewerage and Water Board of New Orleans||$26.99|
|Boston Water and Sewer Commission||$24.68|
|Birmingham Water Works||$37.86|
|City of Bellevue Water System||$39.01|
|City of Los Angeles Water System||$29.46|
|Peoria American Water||$41.65|
The hypothesis for checking whether the population mean rate per 5 CCF of residential water charged by US public utilities differs from $21.62 rate charged by Tulsa or not.
That is, the population mean rate per 5 CCF of residential water charged by US public utilities is equal to $21.62.
That is, the population mean rate per 5 CCF of residential water charged by US public utilities is different from $21.62.
The p-value for the hypothesis testing is 0.2568 and it is obtained below:
The mean value for the given sample observations is 20.2383 and it is calculated by using Excel function, “=AVERAGE (A2:A43)”.
The standard deviation is 7.7991 and it is calculated by using Excel function,
The number of sample observations is n=42.
The degree of freedom is, n – 1 = 42– 1 = 41.
The value of P(t<-1.15) is 0.1284 and it is obtained by using the Excel function
Our solutions are written by experts, many with advanced degrees, and available 24/7See Solution
Q: Suppose we have the short hand info on a Normal Distribution as N(10,25). What is the population mea...
A: Mean:Mean is a measure of center in case of quantitative data. Mean of a data set is the sum of the ...
Q: Compute the least- squares regression line for the given data set: x 1 2 3 4 5 y 5 6 9 8...
A: The least square regression line is obtained below:Step-by-step procedure to obtain Regression outpu...
Q: Explain how Pearson's Coefficient is utilized to determine the shape of data.
A: Value of Pearson's coefficient of skewness describes the shape of the distributon. As a general rule...
Q: In a recent poll, the Gallup organization found that 45% of adult Americans believe that the overall...
A: Binomial distribution:A random variable Y denoting the number of successes in n trials for probabili...
Q: Determine the median and the first and third quartiles in the following data. ...
A: Median:Median is the middle most value of all the observations.The median for the given data can be ...
Q: Find the indicated probability: Two 6-sided dice are rolled. What is the probability that the sum ...
A: We are given, 2 six-sided die rolled. So we first need to write down the possible outcomes from this...
Q: Suppose that we perform an experiment where we classify the outcome as either a success or a failure...
A: It is given that p = 0.9, q = 0.10, n = 4 and X= 2.
Q: A permutation is an ordered arrangement order matters r distinct objects are chosen from n distinc...
A: Number of ways in which first, second, and third prizes be awarded in a contest with 825 contestan...
Q: A fair coin is flipped six times. What is the probability that heads occurs exactly 5 times if it is...
A: It is given that, a fair coin is flipped six times. Therefore, p = 0.5, q = 0.5 and n = 6.
Sorry about that. What wasn’t helpful?