Question

With Matlab Please

Transplant data

The data file “transplants.txt” contains the # of transplants performed each year by different states in the country. Here’s the first few lines of the file:

0, 2015,2014,2013,2012,2011,2010,2009,2008,2007,2006,2005,2004,2003,2002,2001,2000

1,40,401,413,372,422,433,411,428,476,493,493,403,492,454,464,5272,109,711,754,652,735,618,590,601,607,511,498,421,354,376,341,2893,20,123,156,161,155,159,173,158,171,183,185,154,119,122,103,110

.

.

.

Each row is a different state, and each column (starting at column 2)is a different year; the first column is the state #, and the states are always listed 1, 2, 3, ... .

The first row of the file is a header row denoting the year; you may assume the years are consecutive, in descending order (e.g. 2015, 2014, 2013, ...).But the first year

can change —do not assume that column 2 is always 2015.

Likewise, do not assume that there are exactly 17 columns. Solve each of exercises below for the general case —the file could change to include more or less rows, and more or less columns. The only fair assumptions are (a)the states (rows) are listed

consecutively starting at 1, and (b) the years (columns) are listed consecutively in descending order .A sample input file is being made available so you can test your work if you wish:

transplants.csv:

https://www.dropbox.com/s/setu6ykcja2hwfx/transplants.csv?dl=0

This file can be found on the course web page under “Exams”, then “exam03

-files”; it contain only numeric data, so you can use the load( ) function to programmatically load the data.

Questions:

1.Column 2 contains the most recent year of transplant data. Recall that the first row is really a header row, and the actual data starts in the second row. Extract the year into a variable Y and extract the transplant data for that year into a variable T; keep in mind the # of rows can change from one file to the next. This should take just 2 lines of MATLAB code, no loops.

Example: given the data you see above, Y would be the value 2015, and T would be a column vector containing

40

109

20

.

.

.

Answer 1

null