Can someone please help me with this! there is an excel for it I'll send it through your email if you can give it$.$ Thanks. Yeah so please send me your email so I can send you the excel file. The trajectories $($time$-$space diagrams$)$ of a group of vehicles were recorded at a site from a US motorway

$($i$.$e$.$ NGSIM data, see figure $1$ below$).$ The data are given in the spreadsheet "Assignment One Question

$2.$xls$"$ in this unit's Moodle site. This dataset contains the information of $7$ vehicles while the information of

the $8^{th}$ vehicle is considered missing.

Figure $1$: NGSIM data. Left: data collection site. Right: time$-$space diagram of $8$ vehicles.

a$)$ Calculate the average spacing $($i$.$e$.$ the space headway$)$ of the vehicles at different time steps given

in the excel sheet $[2].$ Plot these time varying values $[1]$

b$)$ Calculate the space mean speed at different time steps given in the excel sheet $[2].$ Plot these time

varying values $[1]$

c$)$ Calculate the flow at different time steps given in the excel sheet $[3].$ Plot these time varying values

$[1]$