Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
use matlab he spreadsheet work . xls ( source: department of energy ) contains data for how people commute to work from 1 9 8
use matlab he spreadsheet workxlssource: department of energy contains data for how people commute to work from and Read data file workxls Only columns C to F and rows to in the spreadsheet are to be used.Cleanremove nonnumerical columns and rows. Some part of data na should be changed to zero. Task : According to this database, how many total workers are there in Task : Using data from all four years, what percent of people drive alone to work? Task : Comparing to 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 : Assuming the average distance traveled by commuters who drive alone is miles a day, and assume the average milespergallon is Miles. How many gallons of gasoline is consumed everyday by commuters who drive alone? Task : If of the people who drive alone to work now take the bus, how many people utilize public transformation in total? Task : If for every additional people who take the bus, the bus fare can be reduced by cent. How much can the bus fare be reduced if of the people who drive alone to work now take the bus? Assuming bus fare per person is $ per person per ride. Task : Using data for the four years, how many people bike to work on average? Task : Show the number of people who take subway to work for each given data year with bar graph.
use matlab
he spreadsheet workxlssource: department of energy contains data for how people commute to work from and
Read data file workxls Only columns C to F and rows to in the spreadsheet are to be used.Cleanremove nonnumerical columns and rows. Some part of data na should be changed to zero.
Task : According to this database, how many total workers are there in
Task : Using data from all four years, what percent of people drive alone to work?
Task : Comparing to 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 : Assuming the average distance traveled by commuters who drive alone is miles a day, and assume the average milespergallon is Miles. How many gallons of gasoline is consumed everyday by commuters who drive alone?
Task : If of the people who drive alone to work now take the bus, how many people utilize public transformation in total?
Task : If for every additional people who take the bus, the bus fare can be reduced by cent. How much can the bus fare be reduced if of the people who drive alone to work now take the bus? Assuming bus fare per person is $ per person per ride.
Task : Using data for the four years, how many people bike to work on average?
Task : Show the number of people who take subway to work for each given data year with bar graph.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started