60.1K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer