Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Using date and time of past crimes to project the next occurance

Trying to find the formulas to use to project the next probable occurance of
an event based on date and time....2 separate fields date in one time in the
other.
The events usually 3 or more.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Using date and time of past crimes to project the next occurance

P(a)=No ways event can happen/No possible outcomes.

Take throwing a 6 with a standard dice.

P(a)= 1/6

You need to be a lot more specific about what you are trying to predict if
you want to incorporate date/time into the equation.

"WR1CH" wrote:

Trying to find the formulas to use to project the next probable occurance of
an event based on date and time....2 separate fields date in one time in the
other.
The events usually 3 or more.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Using date and time of past crimes to project the next occuran

Mike
I am trying to predict the next date/time period that another crime will
occur based on the periods between the dates/times that have already occured.
Thanks

"Mike" wrote:

P(a)=No ways event can happen/No possible outcomes.

Take throwing a 6 with a standard dice.

P(a)= 1/6

You need to be a lot more specific about what you are trying to predict if
you want to incorporate date/time into the equation.

"WR1CH" wrote:

Trying to find the formulas to use to project the next probable occurance of
an event based on date and time....2 separate fields date in one time in the
other.
The events usually 3 or more.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default Using date and time of past crimes to project the next occuran

Your best bet is to fit a curve to the 3 or more values
I'd ignore the times, if the dates are not too close

The advantage of a chart, is that as more data is added
the accuracy of the chart can be seen.

Much better of course if you weren't using crimes as data :)

Steve

On Tue, 06 Feb 2007 19:57:00 -0000, WR1CH
wrote:

Mike
I am trying to predict the next date/time period that another crime will
occur based on the periods between the dates/times that have already
occured.
Thanks

"Mike" wrote:

P(a)=No ways event can happen/No possible outcomes.

Take throwing a 6 with a standard dice.

P(a)= 1/6

You need to be a lot more specific about what you are trying to predict
if
you want to incorporate date/time into the equation.

"WR1CH" wrote:

Trying to find the formulas to use to project the next probable

occurance of
an event based on date and time....2 separate fields date in one time

in the
other.
The events usually 3 or more.




--
Steve (3)
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Using date and time of past crimes to project the next occuran

Steve
Thanks for the response, actually the times are important as well.
In trying to predict a pattern for a crime...like burglary, we not only use
date and time of day that it happened but location as well. Of course the
location is mapped.
We need both the date and time to predict what day and what time of day to
patrol or stake out a potential area that a burglary, robbery or ? may take
place.
So I am trying to predict the next earliest and latest date and the time
range within those dates that the incident may likely occur. That way police
resources can be deployed with some statistical probability of
success....hopefully.
Rich

"SteveW" wrote:

Your best bet is to fit a curve to the 3 or more values
I'd ignore the times, if the dates are not too close

The advantage of a chart, is that as more data is added
the accuracy of the chart can be seen.

Much better of course if you weren't using crimes as data :)

Steve

On Tue, 06 Feb 2007 19:57:00 -0000, WR1CH
wrote:

Mike
I am trying to predict the next date/time period that another crime will
occur based on the periods between the dates/times that have already
occured.
Thanks

"Mike" wrote:

P(a)=No ways event can happen/No possible outcomes.

Take throwing a 6 with a standard dice.

P(a)= 1/6

You need to be a lot more specific about what you are trying to predict
if
you want to incorporate date/time into the equation.

"WR1CH" wrote:

Trying to find the formulas to use to project the next probable
occurance of
an event based on date and time....2 separate fields date in one time
in the
other.
The events usually 3 or more.




--
Steve (3)



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default Using date and time of past crimes to project the next occuran

I think you'd be better posting on a forum where the bad guys are
They obviously have the dates/times in a spreadsheet
and plan there future crimes accordingly :)

Steve

On Wed, 07 Feb 2007 03:09:00 -0000, WR1CH
wrote:

Steve
Thanks for the response, actually the times are important as well.
In trying to predict a pattern for a crime...like burglary, we not only
use
date and time of day that it happened but location as well. Of course the
location is mapped.
We need both the date and time to predict what day and what time of day
to
patrol or stake out a potential area that a burglary, robbery or ? may
take
place.
So I am trying to predict the next earliest and latest date and the time
range within those dates that the incident may likely occur. That way
police
resources can be deployed with some statistical probability of
success....hopefully.
Rich

"SteveW" wrote:

Your best bet is to fit a curve to the 3 or more values
I'd ignore the times, if the dates are not too close

The advantage of a chart, is that as more data is added
the accuracy of the chart can be seen.

Much better of course if you weren't using crimes as data :)

Steve

On Tue, 06 Feb 2007 19:57:00 -0000, WR1CH
wrote:

Mike
I am trying to predict the next date/time period that another crime

will
occur based on the periods between the dates/times that have already
occured.
Thanks

"Mike" wrote:

P(a)=No ways event can happen/No possible outcomes.

Take throwing a 6 with a standard dice.

P(a)= 1/6

You need to be a lot more specific about what you are trying to

predict
if
you want to incorporate date/time into the equation.

"WR1CH" wrote:

Trying to find the formulas to use to project the next probable
occurance of
an event based on date and time....2 separate fields date in one

time
in the
other.
The events usually 3 or more.

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default Using date and time of past crimes to project the next occurance

Are you working on the TV program "Numbers" <g
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WR1CH" wrote in message
...
Trying to find the formulas to use to project the next probable occurance
of
an event based on date and time....2 separate fields date in one time in
the
other.
The events usually 3 or more.



  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Using date and time of past crimes to project the next occuran

I wish.......this is volunteer work at a police department.

"Bernard Liengme" wrote:

Are you working on the TV program "Numbers" <g
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WR1CH" wrote in message
...
Trying to find the formulas to use to project the next probable occurance
of
an event based on date and time....2 separate fields date in one time in
the
other.
The events usually 3 or more.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine Date & Time Cells KrunoG Excel Discussion (Misc queries) 0 January 31st 06 08:08 PM
How to calculate Date & Time differences robs Excel Worksheet Functions 2 October 4th 05 04:22 PM
Using VLOOKUP with a Date and Time Charles Excel Discussion (Misc queries) 4 September 20th 05 06:38 PM
How do I calculate if a date is in a certain time frame? Pe66les Excel Worksheet Functions 19 August 27th 05 11:07 PM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM


All times are GMT +1. The time now is 06:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"