The attached data sets reflect field data taken at two sites in Huskytown. You are an engineering intern and you have been asked by your supervisor to analyze the data and prepare a brief report documenting any conclusions and recommendations that you have. Using the "attached" data sets, analyze the data. Assume Greenshield's model for space mean speed as a function of density. Attached MS Excel Data Set One Tasks to be Completed Task 1: Using regression to determine the theoretical equation that describes the speed as a function of density:
Task 2: Using histograms, calculate and graph the following:
Task 3: Using any analysis tools, plot:
Task 4: Write up a report stating the information specified above, as well as your own conclusions about the data provided.
|