The first sheet on QMB3200-Homework#1Data.xlsx is named Commute Time. It lists the average commute time (in minutes) it takes citizens of 379 metropolitan areas to travel to work and back home each day. a. Using Excels statistical functions such as -AVERAGE(), -SUM() etc., give the mean, median, mode, max, min, variance (sample) and standard deviation (sample) of the average commute times, 10th percentile, 20th percentile, 40th percentile, 50th percentile, 60th percentile, 80th percentile, 1st quartile, 2nd quartile, 3rd quartile. Look at the values of the median and the 2nd quartile and the 50th percentile and comment. b. Find the frequency of commute times between 30-39.99, 40-49.99, 50-59.99, 60-69.99 and 70-79.99. c. Find the relative frequency of the commute times for the above intervals. d. Find the cumulative relative frequency of the commute times for the above intervals. e. Plot a line chart of the relative frequencies obtained in part c above. f. Plot a pie-chart of the relative frequencies. g. Make three statements about the data from the cumulative relative frequency table or the plots. Metropolitan Area 2 Abilene, TX 3 Akron, OH 4 Albany, GA 5 Albany-Schenectady-Troy, NY 6 Albuquerque, NM Commute Time 37.57 49.38 44.52 48.37 48.85 54.63 7 Alexandria, LA 8 Allentown-Bethlehem-Easton, PA 53.55 43.37 9 Altoona, PA 10 Amarillo, TX 11 Ames, IA 12 Anchorage, AK 13 Anderson, IN 14 Anderson, SC 15 Ann Arbor, MI 17 Appleton, WI 39.68 35.97 47.98 49.92 51.22 47.00 16 Anniston-Oxford, AL 50.72 38.93 18 Asheville, NC 46.83 19 Athens-Clarke County, GA 46.92 20 Atlanta-Sandy Springs-Marietta, GA 66.33 21 Atlantic City, NJ 51.07 22 Auburn-Opelika, AL 44.45 23 Augusta-Richmond County, GA-SC 52.13 24 Austin-Round Rock, TX 54.13 25 Bakersfield, CA 49.75 26 Baltimore-Towson, MD 27 Bangor, ME 28 Barnstable Town, MA 29 Baton Rouge, LA 63.42 45.88 50.18 55.03 30 Battle Creek, MI 42.92 31 Bay City, MI 46.62 32 Beaumont-Port Arthur, TX 47.50 33 Bellingham, WA 43.40 34 Bend, OR 38.52 35 Bethesda-Gaithersburg-Frederick, MD 68.47 36 Billings, MT 38.90 37 Binghamton, NY 43.17 00 38 Birmingham-Hoover, AL 39 Bismarck, ND A 40 Blacksburg-Christiansburg-Radford, VA 41 Bloomington, IN 42 Bloomington-Normal, IL 43 Boise City-Nampa, ID 44 Boston-Quincy, MA 45 Boulder, CO 57.97 33.85 43.65 46.75 36.13 43.53 64.60 46.13 46 Bowling Green, KY 44.68 47 Bremerton-Silverdale, WA 68.22 48 Bridgeport-Stamford-Norwalk, CT 58.92 49 Brownsville-Harlingen, TX 44.30 50 Brunswick, GA 48.67 51 Buffalo-Niagara Falls, NY 45.47 52 Burlington, NC 46.67 53 Burlington-South Burlington, VT 45.00 54 Cambridge-Newton-Framingham, MA 58.10 55 Camden, NJ 60.12 56 Canton-Massillon, OH 46.68 57 Carson City, NV 37.72 58 Casper, WY 35.48 59 Cedar Rapids, IA 40.40 60 Champaign-Urbana, IL 37.23 61 Charleston, WV 54.08 62 Charleston-North Charleston, SC 52.80 63 Charlotte-Gastonia-Concord, NC-SC 56.28 64 Charlottesville, VA 49.32 65 Chattanooga, TN-GA 51.20 66 Cheyenne, WY 34.65 67 Chicago-Naperville-Joliet, IL 67.57 68 Chico, CA 44.08 69 Cincinnati-Middletown, OH-KY-IN 52.23 70 Clarksville, TN-KY 51.27 71 Cleveland, TN 47.28 72 Cleveland-Elyria-Mentor, OH 51.98 73 Coeur d'Alene, ID 45.72 74 College Station-Bryan, TX 39.80 75 Colorado Springs, CO 76 Columbia, MO 47.62 38.77 77 Columbia, SC 52.38 78 Columbus, GA-AL 79 Columbus, IN 80 Columbus, OH 81 Corpus Christi, TX 82 Corvallis, OR 83 Cumberland, MD-WV 84 Dallas-Plano-Irving, TX 85 Dalton, GA 86 Danville, IL 46.52 40.45 49.73 44.75 37.40 52.97 59.13 47.52 43.60 87 Danville, VA 49.35 88 Davenport-Moline-Rock Island, IA-IL 41.35 89 Dayton, OH 45.40 90 Decatur, AL 52.15 91 Decatur, IL 39.00 92 Deltona-Daytona Beach-Ormond Beach, FL 54.22 93 Denver-Aurora, CO 56.33 94 Des Moines-West Des Moines, IA 41.67 95 Detroit-Livonia-Dearborn, MI 55.65 96 Dothan, AL 47.30 97 Dover, DE 98 Dubuque, IA 99 Duluth, MN-WI 100 Durham, NC 101 Eau Claire, WI 102 Edison, NJ 103 El Centro, CA 104 Elizabethtown, KY 105 Elkhart-Goshen, IN 106 Elmira, NY 48.40 32.78 42.25 48.43 39.45 69.37 43.27 49.93 39.12 41.45 107 El Paso, TX 48.82 108 Erie, PA 39.78 109 Essex County, MA 57.57 110 Eugene-Springfield, OR 41.57 111 Evansville, IN-KY 44.73 A B 112 113 Fairbanks, AK Fargo, ND-MN 36.70 34.35 114 Framington, NM 50.80 115 Fayetteville, NC 48.00 116 Fayetteville-Springdale-Rogers, AR-MO 43.47 117 Flagstaff, AZ 40.28 118 Flint, MI 55.13 119 Florence, SC 50.98 120 Florence-Muscle Shoals, AL 5130 121 Fond du Lac, WI 39.67 122 Fort Collins-Loveland, CO 44.58 123 Fort Lauderdale-Pompano Beach-Deerfield Beach, 58.47 124 Fort Smith, AR-OK 48.18 125 Fort Walton Beach-Crestview-Destin, FL 47.13 126 Fort Wayne, IN 128 Fresno, CA 129 Gadsden, AL 130 Gainesville, FL 131 Gainesville, GA 132 Gary, IN 133 Glens Falls, NY 134 Goldsboro, NC 44.67 127 Fort Worth-Arlington, TX 57.32 47.27 52.88 46.35 56.17 57.83 48.27 46.38 135 Grands Fork, ND-MN 31.85 136 Grand Junction, CO 38.45 137 Grand Rapids-Wyoming, MI 47.43 138 Great Falls, MT 33.73 139 Greeley, CO 49.98 140 Green Bay, WI 39.93 141 Greensboro-High Point, NC 48.22 142 Greenville, NC 46.23 143 Greenville, SC 48.02 144 Gulfport-Biloxi, MS 5178 145 Hagerstown-Martinsburg, MD-WV 58.03 146 Hanford-Corcoran, CA 44.50 147 Harrisburg-Carlisle, PA 47.00 148 Hamisonburg, VA 4185 149 Hartford-West Hartford-East Hartford, CT 48.73 150 Hamesburg, MS 5157 151 Hickory-Morganton-Lenoir, NC 45.80 152 Hinesville-Fort Stewart, GA 48.68 153 Holland-Grand Haven, M 4133 154 Honolulu H 58.38 155 Hot Springs, AR 45.07 156 Houma-Bayou Cane-Thibodaues, LA 55.90 157 Houston-Sugar Land-Baytown, TX 6180 18 Huntington-Ashland, WV-KY-OH 50.45 159 Huntsville, AL 47.10 10 Idaho Falls D 42.98 Com 161 Indianapolis-Carmel, IN 51.28 162 lowa City, IA 38.55 163 Ithaca, NY 37.10 164 Jackson, MI 165 Jackson, MS 166 Jackson, TN 167 Jacksonville, FL 168 Jacksonville, NC 169 Janesville, WI 170 Jefferson City, MO 171 Johnson City, TN 172 Johnstown, PA 49.50 5155 43.13 57.37 45.43 43.40 44.02 46.75 47.00 173 Jonesboro, AK 4143 174 Joplin, MO 40.83 175 Kalamazoo-Portage, MI 44.02 176 Kankakee-Bradley, IL 50.68 177 Kansas City, MO-KS 49.08 178 Kennewick-Richland-Pasco, WA 45.27 179 Killeen-Temple-Fort Hood, TX 46.07 180 Kingsport-Bristol-Bristol, TN-VA 49.12 181 Kingston, NY 56.32 182 Knoxville, TN 183 Kokomo, IN 184 La Crosse, WI-MN 185 Lafayette, IN 49.22 39.10 37.63 39.15 186 Lafayette, LA 53.43 187 Lake Charles, LA 44.67 188 Lake County-Kenosha County, IL-WI 61.70 189 Lakeland, FL 54.73 190 Lancaster, PA 45.50 191 Lansing-East Lansing, MI 45.13 192 Laredo, TX 46.42 193 Las Cruces, NM 45.25 194 Las Vegas-Paradise, NV 52.25 195 Lawrence, KS 4118 196 Lawton, OK 36.42 137 Lebanon, PA 199 Lewiston, ID-WA 201 Lima, OH 45.95 34.45 199 Lewiston-Auburn, ME 200 Lexington-Fayette, KY 39 73 202 Lincoln, NE 38.05 203 Little Rock-North Little Rock, AR 50 10 204 Logan, UT-10 36.45 205 Longview, TX 47.03 206 Longview.WA 45.43 207 Los Angeles-Long Beach-Glendale, CA 62.37 200 Louisville-Jefferson County, KY-IN 50.20 209 Lubbock TX 36.95 49.98 44.53 B C o 210 Lynchburg, VA 211 Macon, GA 212 Madera, CA A 49.62 52.52 55.45 43.35 213 Madison, WI 214 Manchester-Nashua, NH 54.10 43.22 215 Mansfield, OH 216 McAllen-Edinburg-Mission, TX 44.921 217 Medford, OR 39.17 218 Memphis, TN-AR-MS 53.33 219 Merced, CA 55.32 220 Miami-Miami Beach-Kendall, FL 64.50 221 Michigan city-La Porte, IN 47.22 222 Midland, TX 39.67 223 Milwaukee-Waukesha-Weat Allis, WI 47.33 224 Minneapolis-St. Paul-Bloomington, MN-WI 50.07 225 Missoula, MT 36.82 226 Mobile, AL 54.38 227 Modesto, CA 228 Monroe, LA 229 Monroe, MI 230 Montgomery, AL 231 Morgantown, WV 57.15 46.95 51.78 49.87 48.82 232 Morristown, TN 50.58 233 Mount Vernon-Anacortes, WA 52.70 234 Muncie, IN 42.37 235 Muskegon-Norton Shores, MI 44.43 236 Myrtle Beach-Conway-North Myrtle Beach, SC 50.73 237 Napa, CA 50.68 238 Naples-Marco Island, FL 50.35 239 Nashville-Davidson-Murfreesboro, TN 55.65 240 Nassau-Suffolk, NY 70.60 241 Newark-Union, NJ-PA 66.30 242 New Haven-Milford, CT 42.90 243 New London-Norwich, CT-RI 49.78 244 New Orleans-Metairie-Kenner, LA 57.32 246 Niles-Benton Harbor, MI 245 New York-White Plains-Wayne, NY-NJ 79.38 42.63 247 Norwich-New London, CT 243 Oakland-Fremont-Hayward, CA 47.60 68.13 249 Ocala, FL 250 Gcean City, NJ 252 Odgen-Clearfield, UT 54.90 251 Odessa, TX 253 Oklahoma City, OK 254 Olympia, WA 256 Orlando-Kissimmee, FL 49.67 40.00 46.82 47 48 255 Omaha-Council Bluffs, NE-IA 51.68 41.98 257 Oshkosh-Neenah, W 57.43 200 Owensboro, KY 38.13 CommuteTime 44.43 BetaEmployer B A 259 Oxnard-Thousand Oaks-Ventura, CA 53.47 260 Palm Bay-Melbourne-Titusville, FL 52.38 261 Panama City-Lynn Haven, FL 46.42 262 Parkersburg-Marietta-Vienna, WV-OH 46.13 263 Pascagoula, MS 54.10 264 Pensacola-Ferry Pass-Brent, FL 53.15 42.82 265 Peoria, IL 266 Philadelphia, PA 61.72 267 Phoenix-Mesa-Scottsdale, AZ 55.38 268 Pine Bluff, AR 269 Pittsburgh, PA 270 Pittsfield, MA 49.50 54.42 40.77 271 Pocatello, ID 36.65 272 Portland-South Portland-Biddeford, ME 49.35 273 Portland-Vancouver-Beavertown, OR-WA 274 Port St. Lucie-Fort Pierce, FL 5145 54.75 275 Poughkeepsie-Newburgh-Middletown, NY 276 Prescott, AZ 66.78 46.52 277 Providence-New Bedford-Fall River, RI-MA 50.72 278 Provo-Orem, UT 39.48 279 Pueblo, CO 43.93 280 Punta Gorda, FL 50.32 281 Racine, W 282 Raleigh-Cary, NC 283 Rapid City, SD 284 Reading, PA 47.37 55.48 36.95 47.75 285 Redding, CA 44.15 286 Reno-Sparks, NV 4127 287 Richmond, VA 54.10 288 Riverside-San Bernardino-Ontario, CA 65.98 289 Roanoke, VA 47.60 290 Rochester, MN 37.55 291 Rochester, NY 44.88 292 Rockford, IL 234 Rocky Mount, NC 293 Rockingham County-Strafford County, NH 46.65 57.83 295 Rome, GA 47.65 297 Saginaw-Saginaw Township, Mi 296 Sacramento-Arden-Arcade-Roseville, CA 5100 54.08 298 St. Cloud, MN 46.17 299 St. George, UT 40.95 300 St Joseph, MO-KS 36.03 301 St Louis, MO-IL 302 Salem, OR 303 Salinas, CA 304 Salisbury, MD 305 Salt Lake City, UT 206 San Angelo, TX 42.80 54.80 49.23 49.18 45.95 48.52 1907 Ban Antonio, TX 38.57 53.45 CommuteTi B A 308 San Diego-Carlsbad-San Marcos, CA 53.25 40.40 309 Sandusky, OH 311 San Jose-Sunnyvale-Santa Clara, CA 310 San Francisco-San Mateo-Redwood City, CA 6162 56.10 313 Santa Ana-Anaheim-Irvine, CA 312 San Luis Obispo-Paso Robles, CA 43.92 57.55 314 Santa Barbara-Santa Maria, CA 40.45 315 Santa Cruz-Watsonville, CA 57.87 316 Santa Fe, NM 45.05 317 Santa Rosa-Petaluma, CA 55.83 318 Sarasota-Bradenton-Venice, FL 47.42 319 Savannah, GA 51.95 320 Scranton-Wilkes Barre, PA 45.07 321 Seattle-Bellevue-Everett, WA 57.42 322 Sebastian-Vero Beach, FL 42.93 323 Sheboygan, WI 36.02 324 Sherman-Denison, TX 53.15 325 Shreveport-Bossier City, LA 47.38 326 Sioux City, IA-NE-SD 37.78 327 Sioux Falls, SD 37.55 328 South Bend-Mishawaka, IN-MI 44.60 329 Spartanburg, SC 48.50 330 Spokane, WA 44.72 331 Springfield, IL 41.78 332 Springfield, MA 333 Springfield, MO 334 Springfield, OH 335 State College, PA 336 Stockton, CA 337 Sumter, SC 338 Syracuse, NY 47.07 45.85 46.50 41.37 62.32 46.43 43.98 339 Tacoma, WA 60.35 340 Tallahassee, FL 50.93 341 Tampa-St. Petersburg-Clearwater, FL 342 Terre Haute, IN 54.52 343 Texarkana, TX-Texarkana, AR 45.47 344 Toledo, OH 43.72 345 Topeka, KS 347 Tucson, AZ 348 Tulsa, OK 44.30 346 Trenton-Ewing, NJ 44.02 57.70 50.68 349 Tuscaloosa, Al 46.55 350 Tyler TX 47.43 351 Utica-Rome, NY 47.65 352 Valdosta, GA 43.98 355 Vallejo-Fairfield, CA 43.50 354 Victoria, TX 67.67 355 Vineland-Millville-Bridgeton, NJ 46.58 255 Virginia Beach-Norfolk Newport News. VA-NC 49.68 5182 Somm 357 Visalia-Porterville, CA 358 Waco, TX 46.42 42.87 359 Warner Robins, GA 43.75 360 Warren-Troy-Farmington Hills, MI 58.22 361 Washington-Arlington-Alexandria, DC-MD-VA-WV 69.88 362 Waterloo-Cedar Falls, IA 34.92 38.42 363 Wausau, W 364 Weirton-Steubenville, WV-OH 48.30 365 Wenatchee, WA 37.98 366 West Palm Beach-Boca Raton-Boynton Beach, FL 54.25 367 Wheeling, WV-OH 48.93 368 Wichita, KS 4117 369 Wichita Falls, TX 38.95 370 Williamsport, PA 371 Wilmington, DE-MD-NJ 372 Wilmington, NC 373 Winchester, VA-WV 374 Winston-Salem, NC 42.12 53.20 48.67 59.10 49.27 375 Worcester, MA 55.32 376 Yakima, WA 41.27 377 York-Hanover, PA 51.93 378 Youngstown-Warren-Boardman, OH-PA 379 Yuba City, CA 44.98 380 Yuma, AZ 54.62 40.23 381 382