MATLAB Help!!! Reading data from CSV/Excel File

======================================================================================================

Using the dataset provided to, write a script that will determine each boats

Average velocity (in knots)

Maximum and minimum speed (in knots)

The standard deviation of the speed of each boat

Be sure to calculate these properties without using the built-in functions in MATLAB for mean, sum, max, min, std, or other statistical functions. We want you to apply mathematical and programming reasoning to construct these calculations.

Output these results to a file called RaceStatistics.txt , using the fprintf command with numeric output as you have done earlier. The following example shows one way to explain the calculated quantities, but the numbers are not correct for your input data. You can use the wording shown below, or re-organize the information into two statements, one for Boat 1 and one for Boat 2. Your results should have the same numeric format as shown below:

The average instantaneous speed was 25.6 knots for Boat 1 and 24.9 knots for Boat 2. The maximum speeds were 35.1 knots for Boat 1 and 37.3 knots for Boat 2. The minimum speeds were 24.1 knots for Boat 1 and 25.6 knots for Boat 2. Boat 1 had a standard deviation of 6.5 knots, and Boat 2 had a standard deviation of 5.3 knots.

=====================================================================================

Here is the Data Set (store in either Excel or CSV file)

======================================================================================

Time Boat 1 Speed Boat 2 Speed

0	38	37.6
0.2	38	38.04
0.4	38.19	38.04
0.6	38.43	38.34
0.8	38.6	38.59
1	38.85	39.02
1.2	39.03	38.9
1.4	39.1	39.07
1.6	39.19	39.06
1.8	39.26	38.83
2	39.36	38.95