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
Get step-by-step solutions from verified subject matter experts
