Question: The file Attachment_Commute.xls contains average time it takes for a citizen of each metropolitan area to commute to work and back home each day.Question. Generate

The file "Attachment_Commute.xls" contains average time it takes for a citizen of each metropolitan area to commute to work and back home each day.Question. Generate a histogram for distribution of daily commute times. Are shorter or longer commute times generally more likely for these commuters? (Hint: analyze the shape of the distribution).

The file "Attachment_Commute.xls" contains
A B C 1 Daily Commute Data for Selected U.S. Metropolitan Areas N W Metropolitan_Area Daily_Commute Abilene, TX 32.3 Akron, OH 44.6 Albany, GA 36.5 Albany-Schenectady-Troy, NY 43.9 Albuquerque, NM 43.2 1 00 Alexandria, LA 43.6 10 Allentown-Bethlehem-Easton, PA 44.8 11 Altoona, PA 35.0 12 Amarillo, TX 37.1 13 Anchorage, AK 39.2 14 Ann Arbor, MI 46.8 15 Anniston, AL 40.0 16 Appleton-Oshkosh-Neenah, WI 33.8 17 Asheville, NC 41.1 18 Athens, GA 37.8 19 Atlanta, GA 55.8 20 Atlantic City-Cape May, NJ 42.8 21 Augusta-Aiken, GA-SC 47.1 22 Austin-San Marcos, TX 46.3 23 Bakersfield. CA 42.2 24 Baltimore, MD 55.9 25 Bangor, ME 32.0 26 Barnstable-Yarmouth, MA 41.4 27 Baton Rouge, LA 48.9 28 Beaumont-Port Arthur, TX 42.5 29 Bellingham, WA 36.1 30 Benton Harbor, MI 37.0 31 Bergen-Passaic, NJ 53.2 32 Billings, MT 34.1 33 Biloxi-Gulfport-Pascagoula, MS 44.5 34 Binghamton, NY 37.2 35 Birmingham, AL 49.4 36 Bismarck, ND 27.1 37 Bloomington, IN 37.8 38 Bloomington-Normal, IL 33.9 39 Boise City, ID 36.6 40 Boston, MA-NH 51.8 41 Boulder-Longmont, CO 43. 1 42 Brazoria, TX 51.5 43 Bremerton, WA 51.5 44 Bridgeport, CT 44.7 45 Brockton, MA 57.6 46 Brownsville-Harlingen-San Benito, TX 36.5 47 Bryan-College Station, TX 32.3 48 Buffalo-Niagara Falls, NY 41.9 49 Burlington, VT 37.0 50 Canton-Massillon, OH 41.3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!