Spreadsheet problem BUSI 620 "The nature and scope of Managerial economics" Pg 37 speed sheet problem Spreadsheet problem pg 37 "The nature and scope of managerial economics" Using the data, where column A represents student numbers, column B the finishing time for a 1 mile race for 10 students, and column C the age of the students
(a) Use the data analysis tools to plot a line graph of all the finishing times.
(b) Calcualte a mean, median, mode, sample, variance, sample standard deviation, and coefficient of variation to statistically describe the data.
(c) Use excel to find the covariance between the two variables. What does the covariance indicate about the relationship between finishing time and age?