Trying create a formula in excel to predict next burglary.

June 12, 2015 at 07:38:42
Specs: Windows 7
I HAVE TO PREDICT WHEN THE NEXT VEHICLE WILL BE STOLEN. I HAVE ON EXCEL DATEFROM TIMEFROM DATETO AND TIME TO. I HAVE A TOTAL OF FIVE DIFFERENT INCIDENTS. I AM TRYING TO "PREDICT" WHEN MY NEXT HIT WILL BE. CAN ANYONE PLEASE HELP ME???

See More: Trying create a formula in excel to predict next burglary.

Report •

#1
June 12, 2015 at 13:02:18
First off, please do not post in all caps. All caps is the internet equivalent of yelling and nobody likes to be yelled at.

Second, this sounds very much like a homework problem. It the un-official policy of this forum to not provide direct, final answers to homework problems but to help lead the student towards the answer.

In this case, I might consider finding the time difference between each incident, then average those differences. Once I had that average, I just might use it for something.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
June 12, 2015 at 13:40:41
Sorry for the all caps but I was working on something while asking my question.
This is not homework, I was asked at work to predict when the next vehicle burg would occur. I was just looking for guidance on how to find the difference between each incident and then I could see what day of week they occurred.

Report •

#3
June 12, 2015 at 20:48:49
I don't see why the difference between 2 incidents is required for you to determine the day of the week. If you have a date, you can find the day of the week just by formatting the cell correctly.

In any case, to find the difference between dates and/or times, you simply subtract the earlier value from the later value.

Perhaps some examples of your data would help us suggest something more substantial.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question