Give the worksheets meaningful names. If you get any load errors, try to understand whether you can reload the data and correct them. Create another worksheet and name it analysis.
This is where you should do your analysis work. Use built-in functions to answer the following questions. Be sure to display your analysis work in a neat, easy-to-follow format. Find the fastest time, slowest time, median, and mean times for each of the 8 races. Find the mean and median marathon finish times for all 4 years combined. Find the mean and median half-marathon finish times for all 4 years combined. Quartiles help group data into buckets — the first quarter of data is the first quartile, the second quartile same as the median is the first half of the data, and the third quartile represents the first 75 percent.
Find the values that define the first, second, and third quartiles for each half-marathon. Is there a year in which runners seem slower or faster? Scott Wietecha wins fifth Nashville marathon. Hometown woman wins St. Lauren Mitchell wins the St. Tyler Andrews wins St. Medics hit the Nashville marathon course as temperatures reach the 80s.
Photos: St. Videos: St. The third place went to Daniel Everett with a time of In the ladies race, Lauren Mitchell took top honors by finishing the race in She bested Katlyn Will who crossed the finish line 15 seconds behind her. Lisa Steffes got the third place in Complete results. Tyler Andrews outpaced more then runners to win in
0コメント