1.) ResidentialWater.xls contains sample data on water charges by various U.S. water utilities. The City of Tulsa charges $21.62 for the same amount of water consumption. Test the hypothesis of whether Tulsa's water cost is different from the U.S. water utilities' population average. Use the p-value approach with 95% confidence.

\f\fA B 1 Public Utility Company Rate (5 CCF) 2 Orlando Utilities Commission $10.48 3 Memphis Light, Gas and Water $9.18 4 Central Arkansas Water $11.80 5 City of Phoenix Water System $6.50 6 City of Lincoln Water System $12.42 7 San Antonio Water System $14.53 8 Salt Lake City Public Utilities $15.56 9 Nashville Metro Water Services $10.12 10 City of Dover Water System $14.50 11 Lakeland Electric $16.18 12 Huntsville Utilities $17.60 13 Omaha Metropolitan Utilities District $19.18 14 Jacksonville Electric Authority $17.98 15 City of Dallas Water System $12.85 16 City of St. Louis Water System $16.80 17 Charleston Water System $17.35 18 City of Clewiston Water System $15.64 19 Springfield (IL) City Water, Light and Power $14.80 20 City Of Milwaukee Water System $18.91 21 Detroit Sewerage and Water Department $17.99 22 City of Charlotte Water System $14.90 23 Louisville Water Company $18.42 24 City of Jackson (MS) Water System $16.05 25 Las Vegas Valley Water District $26.85 26 City of Columbus OH Water System $22.32 27 City of Oklahoma City - Utilities $22.76 28 Jackson TN Energy Authority $20.98 29 Knoxville Utilities Board $23.45 30 New York City Water Board $19.05 31 Reno Truckee Meadows Water Authority $23.70 32 Chattanooga American Water Company $19.26 33 Marietta Board of Lights & Water $23.75 34 City Utilities of Springfield MO $27.80 35 Indianapolis Citizens Energy Group $27.05 36 City of Philadelphia Water System $27.14 37 LA Sewerage and Water Board of New Orleans $26.99 38 Boston Water and Sewer Commission $24.68 39 Birmingham Water Works $37.86 40 Austin Water $26.51 41 City of Bellevue Water System $39.01 42 City of Los Angeles Water System $29.46 43 Peoria American Water $41.65