Question

In: Statistics and Probability

With increasing congestion and the level of pollution in major cities, governments are trying to reduce...

With increasing congestion and the level of pollution in major cities, governments are trying to
reduce the regular use of cars and encourage the use of public transport to travel to work. The
following table presents data on the methods of travel used by Australian workers by age groups
collected during on the census night for CENSUS 2016. The data are stored in file Assignmen
Dataset.XLS, TRAVEL sheet available in the Written Assignment folder. Using this data and
EXCEL, answer the questions below.
Method of Travel to work by Age
(Employed persons counted at home on census night)
(a) Analyse the method of travel for the total number of employees travelling to work, using
appropriate graphical descriptive method(s). Comment on your findings.

Method of travel 15 to 24
years
25 to 34
years
35 to 44
years
45 to 54
years
55 years or
more
Total
Train 59,160 66,088 50,508 30,899 14,877 221,532
Bus 63,153 53,371 44,668 30,711 16,251 208,154
Ferry/tram 6,856 10,138 5,519 3,481 2,108 28,102
Taxi 4,203 5,257 4,759 3,705 2,139 20,063
Car as driver 561,563 1,003,159 1,102,709 729,600 324,821 3,721,852
Car as passenger 156,174 127,822 106,694 74,262 32,727 497,679
Motorbike/motor scooter 11,995 23,067 13,802 5,694 2,687 57,245
Bicycle 24,941 26,345 18,503 8,252 3,954 81,995
Walked only 78,735 80,955 78,467 59,249 38,601 336,007
Other 8,188 21,250 23,116 17,275 9,462 79,291
Total 974,968 1,417,452 1,448,745 963,128 447,627 5,251,920

Solutions

Expert Solution

We want to analyze the given data using graphical descriptive method

1) Clustered Column :

For the graph below we can see that side by side comapriaion of the number of people from different age group using certain travelling method. Also which method of travel is most populer among the different agegroup.

2) 100% Staked Column : Using this graphical method we can observe that the share of % of the people from different group using certain method of travel. Eg. Younger people (age 15 - 24 prefer to use Car as passenger, Bicycle and Bus

3) Clustered Barchart : Using this we can observe number of people using certain travelling method of different age group. eg. In all age group people prefer to use car as driver for travelling purpose.

4) Stacked barchart : We can find the which age group prefer which travelling method also which age group travel most.

5) 100% Stcked Barchart: We can find the % of which age group prefer which travelling method.


Related Solutions

With increasing congestion and the level of pollution in major cities, governments are trying to reduce...
With increasing congestion and the level of pollution in major cities, governments are trying to reduce the regular use of cars and encourage the use of public transport to travel to work. The following table presents data on the methods of travel used by Australian workers by age groups collected during on the census night for CENSUS 2016. The data are stored in file Assignmen Dataset.XLS, TRAVEL sheet available in the Written Assignment folder. Using this data and EXCEL, answer...
Some companies and municipalities are switching to a four-day workweek to reduce traffic congestion, air pollution,...
Some companies and municipalities are switching to a four-day workweek to reduce traffic congestion, air pollution, and stressed employees. Compressing the workweek into four 10-hour days sounds pretty good to you. You would much prefer having Friday free to schedule medical appointments and take care of family business, in addition to leisurely three-day weekends. As a manager at Skin Essentials, a mineral-based skin care products and natural cosmetics company, you are convinced that the company’s 200 employees could switch to...
Firm A: initial pollution level = 120, cost to reduce pollution 1 unit = $75 Firm...
Firm A: initial pollution level = 120, cost to reduce pollution 1 unit = $75 Firm B: initial pollution level = 150, cost to reduce pollution 1 unit = $100 a. Assume that the government decides to cut pollution by 1/3, telling firms that “Starting next year, you will only be permitted to emit 2/3 as much pollution as you currently do.” What is the cost for each firm under this policy? b. Suppose instead that the government issued permits...
Although cities encourage carpooling to reduce traffic congestion, most vehicles carry only one person. For example,...
Although cities encourage carpooling to reduce traffic congestion, most vehicles carry only one person. For example, 79% of vehicles on the roads are occupied by just the driver. (Round your answers to four decimal places.) (a) If you choose 10 vehicles at random, what is the probability that more than half (that is, 6 or more) carry just one person? (b) If you choose 108 vehicles at random, what is the probability that more than half (that is, 55 or...
If society wishes to reduce pollution, why is it more efficient to tax the pollution rather...
If society wishes to reduce pollution, why is it more efficient to tax the pollution rather than set a limit on pollution?
If society wishes to reduce pollution, why is it more efficient to tax the pollution rather...
If society wishes to reduce pollution, why is it more efficient to tax the pollution rather than set a limit on pollution? If the government issues tradeable pollution permits (ie., a cap-and-trade policy), does it matter for economic efficiency (social welfare) whether all firms receive the same amount of permits, or whether some firms receive more permits than others?
QUESTION 19 Emission controls on automobiles are an example of a a. policy to reduce congestion...
QUESTION 19 Emission controls on automobiles are an example of a a. policy to reduce congestion on urban freeways. b. corrective tax. c. command-and-control policy to increase social efficiency. d. policy that reduces pollution by allocating resources through market mechanisms. 4 points    QUESTION 20 A benevolent social planner would prefer that the output of good x be decreased from its current level if, at the current level of output of good x, a. social value = private value =...
Info: In 2017 a pollution index was calculated for a sample of cities in the eastern...
Info: In 2017 a pollution index was calculated for a sample of cities in the eastern states using data on air and water pollution. Assume the distribution of pollution indices is unimodal and symmetric. The mean of the distribution was 37.6 points with a standard deviation of 11.1 points. Answer question 10 to question 12 below. part A: What percentage of eastern cities would you expect to have a pollution index between 15.4 and 59.8 points? Select one: a. 99.7%...
Info: In 2017 a pollution index was calculated for a sample of cities in the eastern...
Info: In 2017 a pollution index was calculated for a sample of cities in the eastern states using data on air and water pollution. Assume the distribution of pollution indices is unimodal and symmetric. The mean of the distribution was 37.6 points with a standard deviation of 11.1 points. Answer question 10 to question 12 below. part A: What percentage of eastern cities would you expect to have a pollution index between 15.4 and 59.8 points? Select one: a. 99.7%...
Many larger cities are known for high traffic and congestion. Based on what you learned in...
Many larger cities are known for high traffic and congestion. Based on what you learned in this chapter what are some ways a city can reduce the demand for traffic?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT