A local Council is investigating the impact of motorway and other noise on a local suburb. On 14 consecutive days, the noise level N {measured in decibels, dB) and the distance, d {in metres, m) from the motonvay was recorded at various locations. Distance d {m} Noise Level N [dB] 200 64.5 359 55.5 500 43.5 150 6?.5 111 52 850 34.5 200 66 450 48 750 42 250 60 33 54 1500 25.5 700 45 1250 33 a) Using Excel and the 'Noise monitoring' data Construct a Scatterplot of Noise level N against Distance from the motorway [d on the horizontal axis] b) Describe the relationship between the distance from the motorway and the noise level recorded c) Insert a Trend Iine/ Line of best t into your Scatter Plot d) Estimate the distance from the motonvay if the sound level is 50 dB e) Estimate the level of noise is the distance is one kilometre away Question 6: [5 marks] Answer the question below, making the best possible estimate for the situation. Your answer will be a combination of several quantities. Be sure to specify on what assumptions you have based your calculations, and why you have chosen a particular answer. Approximately many kilometres does an adult in their 40's walk in a decade, as part of daily activity? 9.5 x 102 or 9.5 x 103 or 9.5 x 10* km