Need help with Task 3 Assessment 2 is a portfolio of activities “… to develop an
ID: 3270476 • Letter: N
Question
Need help with Task 3
Assessment 2 is a portfolio of activities
“…to develop and support key research skills including reading and responding professionally to a paper or report, discussing, analysing and presenting data in oral, written and visual forms.”
These instructions relate to four of these activities:
readingandresponding professionally to a paper or report;
analysing and presenting data in written form.
Your context
You are an engineering manager and analyst employed by Brisbane City Council (BCC)
Your role includes:
management and operation of BCC’s transport infrastructure
providinginput into the future strategic direction of this infrastructure.
You are researching strategies to increase the utilisation of BCC’s bicycle pathways to help alleviate congestion on main roads.
YourDirector has come across an academic study from the US which has investigated how weather factors impact on commuting to work by bicycle:
Flynn, B. S., Dana, G. S., Sears, J., &Aultman-Hall, L. (2012). Weather factor impacts on commuting to work by bicycle. Preventive Medicine, 54(2), 122-124.
BCC has also captured quite extensive data on the utilisation of BCC’s bicycle pathways, along with weather data captured at the same time.
You are to provide an analysisof this data to address questions about this data (see Task 3, below).
Your assessment must be supported by appropriate evidence from your analysis.
This is the link for the data zip file on weather and commuters: https://www.dropbox.com/s/unvlwviemcoxdio/Assignment%202a%20-%20Data%2020170804.zip?dl=0
Task 3 You have been provided 3 years' of data from BCC and BOM (Bureau of Meteorology) on daily commuter numbers and associated weather data in Brisbane. Are the seasonaltrends observed in Melbourne in the Australian study (Nankervis, 1999) consistent with what's observed in the Brisbane data? What role does daily extreme weatherevents appearto play in commuter numbers in Brisbane? What are the limitations in the given data to answer this question? Is the impact of daily weatherconditions consistent across the entire Brisbane network? 1. 2. 3. Provide statistical measures and/orregression outputs/plots to support your findings Provide your Matlab (orsimilar) analysis here to provide evidence for yourfindings. Provide all necessary regression outputs and/orplots to supportyouranswers to the above points.Explanation / Answer
1.
Fitted Trend Equation for Brisbane data is
Yt = 23880 + 33.0*t
Have to compare with Melborne data
3.
Regression Analysis: Total versus Rainfall amo, Maximum temp, ...
The regression equation is
Total = 45709 - 115 Rainfall amount (millimetres)
+ 70 Maximum temperature (Degree C)
- 1068 Minimum temperature (Degree C)
+ 699 Daily global solar exposure (MJ
1093 cases used, 3 cases contain missing values
Predictor Coef SE Coef T P
Constant 45709 2811 16.26 0.000
Rainfall amount (millimetres) -114.96 38.24 -3.01 0.003
Maximum temperature (Degree C) 69.8 164.8 0.42 0.672
Minimum temperature (Degree C) -1068.5 131.3 -8.14 0.000
Daily global solar exposure (MJ 699.41 83.56 8.37 0.000
S = 14085.4 R-Sq = 15.1% R-Sq(adj) = 14.7%
There are missing value in the data and only 14.7% of factors explain about predictors.