Question

all the answers must be done please help and codes should be done in matlab

Part C (Based off week 12 workshop content Sinee the implementation of the CityCyele scheme in October 2010, the Bris bane council has recorded the mamber of City Cycle trips every month The results are available in the CityCycleData.cov' fie on Blackboard 1. Import the data into MATLAB using the cavread fuaction, and the visualise the data with the scatter function Coenment on whether a linear model woald be appropriate to use. 2. Use the fitin function to conduct a linear regression on the data What is the equation for the linear model? 3. Construct a 95% confidence interval for the shpe and yintercept of the linear model 4. Is there significant evidence (using a significance level of α 006) to show that the masber of trips is affected by mouth. Explain why. . What proportion of total variance of trip nambers is being accounted for by month? Home Insert Page layout Formulas Data Review View Add Ins Nit Calibri Ea Copy Paste ,Format Painter 1 Blu-1E.0,iArn좋를剥误 国Merge & Center Font Alignment A1 f Month No. 1 Month Nd Total CityCycle Trips 1 6075 2 7923 3 5057 4 3020 4178 6283 6 7 5945 8 7616 9 9497 10 7577 12 11 8194 13 12 11326 13 10908 14 14 11315 15 16 15 11102 16 14323 17 18 17 15003 18 16464 19 19 17794 20 18874 21 21 15755 22 19774 23 22297 24 21326 citycycleData CityCycleData Home Insert Page LayoutFormulas Data ReviewViewAdd-Ins Nitro Pro9 % Cut copy Paste Format Painter B I U Clipboard Font Alignment Numb AIMonthNo Al 20 19 17794 20 18874 21 21 15755 22 19774 23 22297 24 21326 26 25 20553 26 19213 27 15966 28 16219 29 14573 30 18180 31 19678 32 19491 33 17495 34 19209 35 21593 36 21522 37 21843 38 20575 39 19600 40 22703 41 21912 42 24662 43 23783 HcityCycleData 0 Home Einsert Page Layout Formulas -Data Renew-View Add Ins Nitro Pro % cut Calibri da Copy Paste Ger Format Painter BI U E Font Alignment Month No. 43 23783 4424369 45 22640 46 25235 47 22473 48 24049 49 28844 51 50 26020 52 51 22956 52 23526 53 23140 54 30572 56 55 27720 56 28550 57 23973 59 58 28770 59 32159 61 60 30734 61 33994 62 30488 63 30625 64 30752 65 31016 66 34804 67 36596 Read Page Layout Formulas Data Review View Add-Ins Nitro Pro 9 Calibri Copy Paste Format Painter Font Alignment Month No. 69 68 37861 69 27677 70 35625 72 71 39151 7237304 73 40865 74 40518 76 75 39848 76 44128 78 7743110 78 47900 79 54225 80 52884 81 46830 82 57256 83 63803 84 67769 85 59458 86 62263 87 57141 88 64261 89 52937 90 63795 91 68497 92 69525 Ready F니 Esc Cut Calibri Wrap Text llGo Copy Paste JFormat Painter IB-u.ltho A- llt Merge & Center. Clipboard Font Alignment Month No. A1 76 75 39848 76 44128 77 43110 7978 47900 80 79 54225 80 52884 81 81 46830 82 82 57256 83 83 63803 84 8467769 85 59458 86 87 86 62263 87 57141 89 88 64261 89 52937 91 90 63795 92 91 68497 92 69525 93 60628 95 94 68472 95 67046 96 62827 97 59943 98 71663 99 63112 CityCycleData ESC

Answer 1

Answers:

1. Matlab code to scatter plot

M = csvread('csvlist.dat',1,0)
X = M(:,1)
Y = M(:,2)
scatter(X,Y)

If you observe the graph properly  dependent variable Y has a linear relationship to the independent variable X. XY scatterplot is linear and that the residual plot shows a random pattern. so linear model is appropriate for this

octave:5 Scatter(X,Y) Gnuplot 20000 10000 40 100 20 60 80

2. For the given data, linear regression is

ŷ = 617.93001X + 0.38858   

   load census;
   fitpoly2=fit(X,Y,'poly1')
   % Plot the fit with the plot method.
   plot(fitpoly2,X,Y)

3. To compute 95% interval for slope and y intercept

print the value of fitpoly2 from previous, it will give 95% confidence interval

4. Based on the hypothesis and significance level yes there is dependency of no of trips on no of months.

5. fitlm(X,Y) will give the expected result.