++ MUST HAVE UK RECOGNISED STATISTICS QUALIFICATION++
I live on a rural road in the south east.
There is a school further up the road and there is a proposal to allow long & slow vehicles to pull out onto the road, on a blind bend.
A recent traffic survey was done under Covid-19 semi-lockdown restrictions, so the survey is inadequate to reflect 'normal' conditions.
I don't have access to the raw data, but I've got the traffic flow & speeds (avg. & 85th %ile) by hour (see attached).
I also have alternative 'vehicle volume data per hour' from a different survey that was done pre-Covid, not in the exact same spot, but close enough with no turn-offs inbetween.
I would like to model the recorded 'speeds p/h' from the recent survey (Survey A) against the 'volumes p/h' of the previous survey (Survey B) - especially the 85th%ile speed for each day (0-24), when applied to a more realistic non-lockdown traffic pattern.
I need to complete the 'Est. 85th%ILE Speed' and 'Est. Avg Speed' columns on each table.
The red cell - Est.85th%ILE speed per day is the most critical.
I only have a basic grasp of this level of statistics from many years ago, and can't remember how to go about it.
Please is this something you would be able to help with?
There are 3-days of data, with single-lane traffic moving in the eastbound and westbound directions - so 6 small tables of excel data overall (see attached).
And I would need to cite any conditions of the modelling (e.g if no speed was recorded in Survey A at a certain time, but there were previous volumes recorded for that time in Survey B, this traffic speed data will be missing from the new model presumably, so the model is not conclusive and perhaps on the conservative-side?)
Also the statistical principles applied, e.g. cumulative frequency etc.
It is quite urgent.
Many thanks in advance for any help
Bu iş için 17 freelancer ortalamada £156 teklif veriyor
I have ph. D in statistics with vast experience in studying and running data analysis. I can work with your data that leads to a model answering your research questions
hello I have goods experience in excel data. I can do this project with 100% accuracy and with in time .you will find results more than your expectation. i have 20 year experience in this field. Regards
I am offering my services on short notice. Relevant Skills and Experiance Please consider me and give me a chance to impress you by my quality services.
Hi I am a qualified statistician and can start right away. Hope you will consider my application. Looking forward to working with you.