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.

can anybody help me through excel formula for below problem step by step . please note that just want to get step by step excel formulas for this question .

also i have attached a small summary of excel file s table as picture for your reference.

E4 X V B C D Metropolitan Area Commute Time 2 Abilene, TX 37.57 B Akron, OH 49.38 Albany, GA 44.52 5 Albany-Schenectad 48.37 6 Albuquerque, NM 48.85 7 Alexandria, LA 54.63 Allentown-Bethleh 53.55 9 Altoona, PA 43.37 10 Amarillo, TX 39.68 11 Ames, IA 35.97 12 Anchorage, AK 47.98 13 Anderson, IN 49.92 14 Anderson, SC 51.22 15 Ann Arbor, MI 47 16 Anniston-Oxford, A 50.72 17 Appleton, WI 38.93 18 Asheville, NC 46.83 19 Athens-Clarke Cour 46.92 20 Atlanta-Sandy Sprin 66.33 21 Atlantic City, NJ 51.07 22 Auburn-Opelika, AL 44.45 28 Augusta-Richmond 52.13 24 Austin-Round Rock, 54.13 25 Bakersfield, CA 49.75 26 Baltimore-Towson, 63.42 27 Bangor, ME 45.88 28 Barnstable Town, IV 50.18 29 Baton Rouge, LA 55.03 Sheet1 Ready 1Accessibility Good to go Type here to search