I have a distribution of patient appointment booking time that looks like below. How can I simulate this data in excel? I am confused as to what distribution I should be using, it is not uniform or poisson.
Based on your comment
I'm trying to simulate data for an optimization problem, wherein I need to optimize patient no show rates at a clinic. I want to simulate this booking scenario, 7 to 19 here is the time of the day where patients have appointments
I am assuming you want to generate a random set of appointments throughout the day that are typical of the activity historically seen at the clinic. If this is not the case then I will delete this answer.
One possible approach to achieving this is to sample directly from your historic data. Rather than explicitly defining a distribution to sample from. Under this approach, you should consider sampling whole days at a time rather than selecting individual appointments. This is because it seems unlikely to me that appointments throughout the day would be independent of each other as the clinician running the clinic is unlikely to schedule too many appointments in a short space of time.