- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Requesting advice for predicting a very simple DATETIME.
I want to predict the time corresponding to a specific value.
I plan to travel a total distance of about 100 km. The first 6 hours will be on foot, and the rest by car.
Assuming the car’s speed is fairly consistent, I want to create a simple model to predict the date and time (yyyy-mm-dd hh:mm:ss) when I will reach the 88 km mark.
Fortunately, I can obtain distance data every second. I think I can create a linear regression curve by using `DATETIME` on the Y-axis and distance on the X-axis.
However, I can't seem to use `DATETIME` on the Y-axis. What should I do?
I plan to travel a total distance of about 100 km. The first 6 hours will be on foot, and the rest by car.
Assuming the car’s speed is fairly consistent, I want to create a simple model to predict the date and time (yyyy-mm-dd hh:mm:ss) when I will reach the 88 km mark.
Fortunately, I can obtain distance data every second. I think I can create a linear regression curve by using `DATETIME` on the Y-axis and distance on the X-axis.
However, I can't seem to use `DATETIME` on the Y-axis. What should I do?
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Requesting advice for predicting a very simple DATETIME.
It appears that your DATETIME column has been input as a character column. It needs to be a numeric JMP Date Time column.
Go to the Help pull down menu and go to JMP Online Help. Then lookup JMP Date and Time values.
Once your column is numeric, you will be able to use it as the Y column.
Jim
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Requesting advice for predicting a very simple DATETIME.
It appears that your DATETIME column has been input as a character column. It needs to be a numeric JMP Date Time column.
Go to the Help pull down menu and go to JMP Online Help. Then lookup JMP Date and Time values.
Once your column is numeric, you will be able to use it as the Y column.
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Requesting advice for predicting a very simple DATETIME.
For more information: Using dates, times, datetimes and durations in JMP
-Jeff