The detected speed in km/hr of 60 vehicles (n=60) in a carriageway is tabulated below:

Plot the data on both the normal and lognormal probability papers, and construct the least-squares regression line through the data points and determine the coefficient of determination if a linear trend can be observed from each probability plot. You are recommended to use Microsoft Excel to make the plot and determine the coefficient of determination. From a visual inspection of the plotted data points, the underlying distribution is a better model to represent the probability distribution of the vehicular speed in the carriageway. Estimate the parameters of the normal and lognormal distributions respectively

Normal Distribution Probability Plots: Least-squares regression line y=Ax+B R^2

Lognormal Distribution Probability Plots: Least-squares regression line y=Ax+B R^2

(*Round to four decimal places, for example: 0.3333)

Vehicle number 46 Vehicle number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 au Speed (km/hr) 46.5 51.5 47.5 52 47 50 45.5 44 45.5 52.5 46 41 48.5 54.5 47.5 Vehicle number 16 17 18 19 20 21 22 23 Speed (km/hr) 44 52 47.5 53.5 52 49.5 37 49 49.5 57.5 52 48 42.5 46 Vehicle number 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Speed (km/hr) 51 38.5 52.5 46.5 47.5 47 47 45 49.5 41.5 43.5 52.5 43 46 44 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Speed (km/hr) 47.5 52 52.5 39 52 51 57.5 41.5 50 48 49 45.5 45.5 44 55.5 24 25 26 27 28 29 30 ULU 40 45 Vehicle number 46 Vehicle number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 au Speed (km/hr) 46.5 51.5 47.5 52 47 50 45.5 44 45.5 52.5 46 41 48.5 54.5 47.5 Vehicle number 16 17 18 19 20 21 22 23 Speed (km/hr) 44 52 47.5 53.5 52 49.5 37 49 49.5 57.5 52 48 42.5 46 Vehicle number 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Speed (km/hr) 51 38.5 52.5 46.5 47.5 47 47 45 49.5 41.5 43.5 52.5 43 46 44 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Speed (km/hr) 47.5 52 52.5 39 52 51 57.5 41.5 50 48 49 45.5 45.5 44 55.5 24 25 26 27 28 29 30 ULU 40 45