Question: can anybody help me through excel for below problem step by step tutorial. please note that i i want to get tutorial and step by

can anybody help me through excel for below problem step by step tutorial. please note that i i want to get tutorial and step by step formula for this question to be solve from PIVOTTABLE in EXCEL

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

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 Finance Questions!