Answer photo question.

Plot the data on both the normal and lognormal probability papers, and construct the leastrsquares regression line through the data points and determine the coefficient of determination ifa 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, which 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 Iognormal distributions respectively Normal Distribution Probaility Plots: C1. p = (*Round to two decimal places, for example: 0.33) C2. 0: (*Round to four decimal places, for example: 0.3333) C3. Least-squares regression line y = Ax + B A= (*Round to four decimal places, for example: 0.3333) B= (*Round to two decimal places, for example: 0.33) C4. R2 = (*Round to four decimal places, for example: 0.3333)1. The detected speed in km/hr of 60 vehicles (n=60) in a carriageway is tabulated below: Vehicle Speed Vehicle Speed Vehicle Speed Vehicle Speed number (km/hr) number (km/hr) number (km/hr) number (km/hr) 1 46.5 16 44 31 51 46 47.5 2 51.5 17 52 32 38.5 47 52 47.5 18 47.5 33 52.5 48 52.5 52 19 53.5 34 46.5 49 39 47 20 52 35 47.5 50 52 6 50 21 49.5 36 47 51 51 45.5 22 37 37 47 52 57.5 44 23 49 38 45 53 41.5 45.5 24 49.5 39 49.5 54 50 10 52.5 25 57.5 40 41.5 55 48 11 46 26 52 41 43.5 56 49 12 41 27 48 42 52.5 57 45.5 13 48.5 28 42.5 43 43 58 45.5 14 54.5 29 46 44 46 59 44 15 47.5 30 40 45 44 60 55.5