IS310 Second Assignment Refer to the traffic congestion cost table as the primary source of your observations, and do the followings; ONLY TYPED HARD COPY IS ACCEPTED 1. Summarize the cost by calculating the mean 2. Calculate the Standard deviation 3. Use a bar graph for this data set. Indicate the average and STD on the graph ONLY TYPED HARD COPY IS ACCEPTED 4. Calculate the average for all cities of each class (5 classes total) then use a pie chart to compare the 5 average cost of cities in each part of the country 5. Write a paragraph summarizing what you have learned (noticed) from examining this data set. Please Note: ONLY TYPED HARD COPY IS ACCEPTED This is an individual project. ONLY TYPED HARD COPY IS ACCEPTED Any similarity between two project which indicates any act of copying, or...will result zero score for all involved. Project is due before the start of the class on Oct. 23 for Monday class, Oct 25 for MW and Evening class, and Oct. 26 for TTH classes ONLY TYPED HARD COPY IS ACCEPTED. Cost due to traffic congestion, per registered vehicle. City Northeastern cities Baltimore, MD Cost Traffic 530 Boston, MA 880 Hartford, CT 250 New York, NY Philadelphia, PA 420 Pittsburgh, PA 400 Washington, DC Midwestern cities 1,090 1,420 Chicago, IL 570 Cincinnati, OH 200 Cleveland, OH 140 Columbus, OH 230 Detroit, MI 530 Indianapolis, IN 130 Kansas City, MO 160 Louisville, KY 190 Milwaukee, WI 370 Southern cities Minneapolis-St. Paul, MN 270 Oklahoma City, OK 190 St. Louis, MO 540 Atlanta, GA 640 Charlotte, NC 390 Ft. Lauderdale, FL 290 Jacksonville, FL 400 Memphis, TN 140 Miami, FL 680 Nashville, TN 340 New Orleans, LA 340 Norfolk, VA 390 Orlando, FL 420 Tampa, FL 310 Southwestern cities Albuquerque, NM 210 Austin, TX Corpus Christi, TX 50 Dallas, TX 750 Denver, CO 420 El Paso, TX 120 Fort Worth, TX 420 Houston, TX 750 Phoenix, AZ 630 Salt Lake City, UT Western cities 410 90 San Antonio, TX 290 Honolulu, HI 470 Los Angeles, CA 980 Portland, OR 500 Sacramento, CA 280 San Bernardino-River, CA 1,320 San Diego, CA 480 San Francisco-Oakland, CA 930 San Jose, CA 960 Seattle-Everett, WA 880