Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can anybody help me through excel for below problem step by step tutorial The file xlsx lists the average time (in minutes) it takes citizens

can anybody help me through excel for below problem step by step tutorial

The file xlsx lists the average time (in minutes) it takes citizens of 379 metropolitan areas totravel to work and back home each day. a. make a histogram of the daily commute times. b. Find the most representative average daily commute time across this distribution. c. Find a useful measure of the variability of these average commute times around the mean. d. The empirical rule for standard deviations indicatesthat approximately 95% of these averagetravel times will fall between whichtwovalues? For this particular data set, isthisempirical rule at least approximately correct?

Metropolitan_Area Commute Time
Abilene, TX 37.57
Akron, OH 49.38
Albany, GA 44.52
Albany-Schenectady-Troy, NY 48.37
Albuquerque, NM 48.85
Alexandria, LA 54.63
Allentown-Bethlehem-Easton, PA 53.55
Altoona, PA 43.37
Amarillo, TX 39.68
Ames, IA 35.97
Anchorage, AK 47.98
Anderson, IN 49.92
Anderson, SC 51.22
Ann Arbor, MI 47.00
Anniston-Oxford, AL 50.72
Appleton, WI 38.93
Asheville, NC 46.83
Athens-Clarke County, GA 46.92
Atlanta-Sandy Springs-Marietta, GA 66.33
Atlantic City, NJ 51.07
Auburn-Opelika, AL 44.45
Augusta-Richmond County, GA-SC 52.13
Austin-Round Rock, TX 54.13
Bakersfield. CA 49.75
Baltimore-Towson, MD 63.42
Bangor, ME 45.88
Barnstable Town, MA 50.18
Baton Rouge, LA 55.03
Battle Creek, MI 42.92
Bay City, MI 46.62
Beaumont-Port Arthur, TX 47.50
Bellingham, WA 43.40
Bend, OR 38.52
Bethesda-Gaithersburg-Frederick, MD 68.47
Billings, MT 38.90
Binghamton, NY 43.17
Birmingham-Hoover, AL 57.97
Bismarck, ND 33.85
Blacksburg-Christiansburg-Radford, VA 43.65
Bloomington, IN 46.75
Bloomington-Normal, IL 36.13
Boise City-Nampa, ID 43.53
Boston-Quincy, MA 64.60
Boulder, CO 46.13
Bowling Green, KY 44.68
Bremerton-Silverdale, WA 68.22
Bridgeport-Stamford-Norwalk, CT 58.92
Brownsville-Harlingen, TX 44.30
Brunswick, GA 48.67
Buffalo-Niagara Falls, NY 45.47
Burlington, NC 46.67
Burlington-South Burlington, VT 45.00
Cambridge-Newton-Framingham, MA 58.10
Camden, NJ 60.12
Canton-Massillon, OH 46.68
Carson City, NV 37.72
Casper, WY 35.48
Cedar Rapids, IA 40.40
Champaign-Urbana, IL 37.23
Charleston, WV 54.08
Charleston-North Charleston, SC 52.80
Charlotte-Gastonia-Concord, NC-SC 56.28
Charlottesville, VA 49.32
Chattanooga, TN-GA 51.20
Cheyenne, WY 34.65
Chicago-Naperville-Joliet, IL 67.57
Chico, CA 44.08
Cincinnati-Middletown, OH-KY-IN 52.23
Clarksville, TN-KY 51.27
Cleveland, TN 47.28
Cleveland-Elyria-Mentor, OH 51.98
Coeur d'Alene, ID 45.72
College Station-Bryan, TX 39.80
Colorado Springs, CO 47.62
Columbia, MO 38.77
Columbia, SC 52.38
Columbus, GA-AL 46.52
Columbus, IN 40.45
Columbus, OH 49.73
Corpus Christi, TX 44.75
Corvallis, OR 37.40
Cumberland, MD-WV 52.97
Dallas-Plano-Irving, TX 59.13
Dalton, GA 47.52
Danville, IL 43.60
Danville, VA 49.35
Davenport-Moline-Rock Island, IA-IL 41.35
Dayton, OH 45.40
Decatur, AL 52.15
Decatur, IL 39.00
Deltona-Daytona Beach-Ormond Beach, FL 54.22
Denver-Aurora, CO 56.33
Des Moines-West Des Moines, IA 41.67
Detroit-Livonia-Dearborn, MI 55.65
Dothan, AL 47.30
Dover, DE 48.40
Dubuque, IA 32.73
Duluth, MN-WI 42.25
Durham, NC 48.43
Eau Claire, WI 39.45
Edison, NJ 69.37
El Centro, CA 43.27
Elizabethtown, KY 49.93
Elkhart-Goshen, IN 39.12
Elmira, NY 41.45
El Paso, TX 48.82
Erie, PA 39.78
Essex County, MA 57.57
Eugene-Springfield, OR 41.57
Evansville, IN-KY 44.73
Fairbanks, AK 36.70
Fargo, ND-MN 34.35
Framington, NM 50.80
Fayetteville, NC 48.00
Fayetteville-Springdale-Rogers, AR-MO 43.47
Flagstaff, AZ 40.28
Flint, MI 55.13
Florence, SC 50.98
Florence-Muscle Shoals, AL 51.30
Fond du Lac, WI 39.67
Fort Collins-Loveland, CO 44.58
Fort Lauderdale-Pompano Beach-Deerfield Beach, FL 58.47
Fort Smith, AR-OK 48.18
Fort Walton Beach-Crestview-Destin, FL 47.13
Fort Wayne, IN 44.67
Fort Worth-Arlington, TX 57.32
Fresno, CA 47.27
Gadsden, AL 52.88
Gainesville, FL 46.35
Gainesville, GA 56.17
Gary, IN 57.83
Glens Falls, NY 48.27
Goldsboro, NC 46.38
Grands Fork, ND-MN 31.85
Grand Junction, CO 38.45
Grand Rapids-Wyoming, MI 47.43
Great Falls, MT 33.73
Greeley, CO 49.98
Green Bay, WI 39.93
Greensboro-High Point, NC 48.22
Greenville, NC 46.23
Greenville, SC 48.02
Gulfport-Biloxi, MS 51.78
Hagerstown-Martinsburg, MD-WV 58.03
Hanford-Corcoran, CA 44.50
Harrisburg-Carlisle, PA 47.00
Harrisonburg, VA 41.85
Hartford-West Hartford-East Hartford, CT 48.73
Hattiesburg, MS 51.57
Hickory-Morganton-Lenoir, NC 45.80
Hinesville-Fort Stewart, GA 48.68
Holland-Grand Haven, MI 41.33
Honolulu, HI 58.38
Hot Springs, AR 45.07
Houma-Bayou Cane-Thibodaux, LA 55.90
Houston-Sugar Land-Baytown, TX 61.80
Huntington-Ashland, WV-KY-OH 50.45
Huntsville, AL 47.10
Idaho Falls, ID 42.98
Indianapolis-Carmel, IN 51.28
Iowa City, IA 38.55
Ithaca, NY 37.10
Jackson, MI 49.50
Jackson, MS 51.55
Jackson, TN 43.13
Jacksonville, FL 57.37
Jacksonville, NC 45.43
Janesville, WI 43.40
Jefferson City, MO 44.02
Johnson City, TN 46.75
Johnstown, PA 47.00
Jonesboro, AK 41.43
Joplin, MO 40.83
Kalamazoo-Portage, MI 44.02
Kankakee-Bradley, IL 50.68
Kansas City, MO-KS 49.08
Kennewick-Richland-Pasco, WA 45.27
Killeen-Temple-Fort Hood, TX 46.07
Kingsport-Bristol-Bristol, TN-VA 49.12
Kingston, NY 56.32
Knoxville, TN 49.22
Kokomo, IN 39.10
La Crosse, WI-MN 37.63
Lafayette, IN 39.15
Lafayette, LA 53.43
Lake Charles, LA 44.67
Lake County-Kenosha County, IL-WI 61.70
Lakeland, FL 54.73
Lancaster, PA 45.50
Lansing-East Lansing, MI 45.13
Laredo, TX 46.42
Las Cruces, NM 45.25
Las Vegas-Paradise, NV 52.25
Lawrence, KS 41.18
Lawton, OK 36.42
Lebanon, PA 45.95
Lewiston, ID-WA 34.45
Lewiston-Auburn, ME 49.98
Lexington-Fayette, KY 44.53
Lima, OH 39.73
Lincoln, NE 38.05
Little Rock-North Little Rock, AR 50.10
Logan, UT-ID 36.45
Longview, TX 47.03
Longview, WA 45.43
Los Angeles-Long Beach-Glendale, CA 62.37
Louisville-Jefferson County, KY-IN 50.20
Lubbock, TX 36.95
Lynchburg, VA 49.62
Macon, GA 52.52
Madera, CA 55.45
Madison, WI 43.35
Manchester-Nashua, NH 54.10
Mansfield, OH 43.22
McAllen-Edinburg-Mission, TX 44.92
Medford, OR 39.17
Memphis, TN-AR-MS 53.33
Merced, CA 55.32
Miami-Miami Beach-Kendall, FL 64.50
Michigan city-La Porte, IN 47.22
Midland, TX 39.67
Milwaukee-Waukesha-Weat Allis, WI 47.33
Minneapolis-St. Paul-Bloomington, MN-WI 50.07
Missoula, MT 36.82
Mobile, AL 54.38
Modesto, CA 57.15
Monroe, LA 46.95
Monroe, MI 51.78
Montgomery, AL 49.87
Morgantown, WV 48.82
Morristown, TN 50.58
Mount Vernon-Anacortes, WA 52.70
Muncie, IN 42.37
Muskegon-Norton Shores, MI 44.43
Myrtle Beach-Conway-North Myrtle Beach, SC 50.73
Napa, CA 50.68
Naples-Marco Island, FL 50.35
Nashville-Davidson-Murfreesboro, TN 55.65
Nassau-Suffolk, NY 70.60
Newark-Union, NJ-PA 66.30
New Haven-Milford, CT 42.90
New London-Norwich, CT-RI 49.78
New Orleans-Metairie-Kenner, LA 57.32
New York-White Plains-Wayne, NY-NJ 79.38
Niles-Benton Harbor, MI 42.63
Norwich-New London, CT 47.60
Oakland-Fremont-Hayward, CA 68.13
Ocala, FL 54.90
Ocean City, NJ 49.67
Odessa, TX 40.00
Odgen-Clearfield, UT 46.82
Oklahoma City, OK 47.48
Olympia, WA 51.68
Omaha-Council Bluffs, NE-IA 41.98
Orlando-Kissimmee, FL 57.43
Oshkosh-Neenah, WI 38.13
Owensboro, KY 44.43
Oxnard-Thousand Oaks-Ventura, CA 53.47
Palm Bay-Melbourne-Titusville, FL 52.38
Panama City-Lynn Haven, FL 46.42
Parkersburg-Marietta-Vienna, WV-OH 46.13
Pascagoula, MS 54.10
Pensacola-Ferry Pass-Brent, FL 53.15
Peoria, IL 42.82
Philadelphia, PA 61.72
Phoenix-Mesa-Scottsdale, AZ 55.38
Pine Bluff, AR 49.50
Pittsburgh, PA 54.42
Pittsfield, MA 40.77
Pocatello, ID 36.65
Portland-South Portland-Biddeford, ME 49.35
Portland-Vancouver-Beavertown, OR-WA 51.45
Port St. Lucie-Fort Pierce, FL 54.75
Poughkeepsie-Newburgh-Middletown, NY 66.78
Prescott, AZ 46.52
Providence-New Bedford-Fall River, RI-MA 50.72
Provo-Orem, UT 39.48
Pueblo, CO 43.93
Punta Gorda, FL 50.32
Racine, WI 47.37
Raleigh-Cary, NC 55.48
Rapid City, SD 36.95
Reading, PA 47.75
Redding, CA 44.15
Reno-Sparks, NV 41.27
Richmond, VA 54.10
Riverside-San Bernardino-Ontario, CA 65.98
Roanoke, VA 47.60
Rochester, MN 37.55
Rochester, NY 44.88
Rockford, IL 46.65
Rockingham County-Strafford County, NH 57.83
Rocky Mount, NC 47.65
Rome, GA 51.00
Sacramento-Arden-Arcade-Roseville, CA 54.08
Saginaw-Saginaw Township, MI 46.17
St. Cloud, MN 40.95
St. George, UT 36.03
St. Joseph, MO-KS 42.80
St. Louis, MO-IL 54.80
Salem, OR 49.23
Salinas, CA 49.18
Salisbury, MD 45.95
Salt Lake City, UT 48.52
San Angelo, TX 38.57
San Antonio, TX 53.45
San Diego-Carlsbad-San Marcos, CA 53.25
Sandusky, OH 40.40
San Francisco-San Mateo-Redwood City, CA 61.62
San Jose-Sunnyvale-Santa Clara, CA 56.10
San Luis Obispo-Paso Robles, CA 43.92
Santa Ana-Anaheim-Irvine, CA 57.55
Santa Barbara-Santa Maria, CA 40.45
Santa Cruz-Watsonville, CA 57.87
Santa Fe, NM 45.05
Santa Rosa-Petaluma, CA 55.83
Sarasota-Bradenton-Venice, FL 47.42
Savannah, GA 51.95
Scranton-Wilkes Barre, PA 45.07
Seattle-Bellevue-Everett, WA 57.42
Sebastian-Vero Beach, FL 42.93
Sheboygan, WI 36.02
Sherman-Denison, TX 53.15
Shreveport-Bossier City, LA 47.38
Sioux City, IA-NE-SD 37.78
Sioux Falls, SD 37.55
South Bend-Mishawaka, IN-MI 44.60
Spartanburg, SC 48.50
Spokane, WA 44.72
Springfield, IL 41.78
Springfield, MA 47.07
Springfield, MO 45.85
Springfield, OH 46.50
State College, PA 41.37
Stockton, CA 62.32
Sumter, SC 46.43
Syracuse, NY 43.98
Tacoma, WA 60.35
Tallahassee, FL 50.93
Tampa-St. Petersburg-Clearwater, FL 54.52
Terre Haute, IN 45.47
Texarkana, TX-Texarkana, AR 43.72
Toledo, OH 44.30
Topeka, KS 44.02
Trenton-Ewing, NJ 57.70
Tucson, AZ 50.68
Tulsa, OK 46.55
Tuscaloosa, AL 47.43
Tyler, TX 47.65
Utica-Rome, NY 43.98
Valdosta, GA 43.50
Vallejo-Fairfield, CA 67.67
Victoria, TX 46.58
Vineland-Millville-Bridgeton, NJ 49.68
Virginia Beach-Norfolk-Newport News, VA-NC 51.82
Visalia-Porterville, CA 46.42
Waco, TX 42.87
Warner Robins, GA 43.75
Warren-Troy-Farmington Hills, MI 58.22
Washington-Arlington-Alexandria, DC-MD-VA-WV 69.88
Waterloo-Cedar Falls, IA 34.92
Wausau, WI 38.42
Weirton-Steubenville, WV-OH 48.30
Wenatchee, WA 37.98
West Palm Beach-Boca Raton-Boynton Beach, FL 54.25
Wheeling, WV-OH 48.93
Wichita, KS 41.17
Wichita Falls, TX 38.95
Williamsport, PA 42.12
Wilmington, DE-MD-NJ 53.20
Wilmington, NC 48.67
Winchester, VA-WV 59.10
Winston-Salem, NC 49.27
Worcester, MA 55.32
Yakima, WA 41.27
York-Hanover, PA 51.93
Youngstown-Warren-Boardman, OH-PA 44.98
Yuba City, CA 54.62
Yuma, AZ 40.23

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Discrete Mathematics

Authors: David J Hunter

2nd Edition

1449604447, 9781449604448

More Books

Students also viewed these Mathematics questions

Question

describe the two basic forms of functional social support;

Answered: 1 week ago

Question

7. How can the models we use have a detrimental effect on others?

Answered: 1 week ago