use matlab

he spreadsheet $$work$.$xls$($source: department of energy$)$ contains data for how people commute to work from $1980,1990,2000,$ and $2009.$

$**$Read data file $$work$.$xls$$ Only columns C to F$,$ and rows $4$ to $17$ in the spreadsheet are to be used.Clean$($remove$)$ non$-$numerical columns and rows. Some part of data $($n$/$a$)$ should be changed to zero.

Task $1$: According to this database, how many total workers are there in $1990?$

Task $2$: Using data from all four years, what percent of people drive alone to work?

Task $3$: Comparing $2009$ to $1980,$ what is the percent decrease of the people who walk to work? Note: percent decrease $=$ absolute value of the difference between the two data, divided by the original data.

Task $4$: Assuming the average distance traveled by commuters who drive alone is $30$ miles a day, and assume the average miles$-$per$-$gallon is $27$ Miles. How many gallons of gasoline is consumed everyday by commuters who drive alone?

Task $5$: If $30\%$ of the people who drive alone to work now take the bus, how many people utilize public transformation in total?

Task $6$: If for every $500$ additional people who take the bus, the bus fare can be reduced by $1$ cent. How much can the bus fare be reduced if $30\%$ of the people who drive alone to work now take the bus? Assuming bus fare per person is $$1$ per person per ride.

Task $7$: Using data for the four years, how many people bike to work on average?

Task $8$: Show the number of people who take subway to work for each given data year with bar graph.