Free — no account required

Hotel Booking Cancellation Prediction In Minutes

Upload your data and get a complete hotel booking cancellation prediction report. Free.

24,000+ analyses run
Encrypted & deleted in 7 days
PDF & citation included

Drop your CSV here

or click to browse · max 3 MB

📊
-
Rows
-
Columns
-
Numeric

Running hotel booking cancellation prediction analysis...

Running hotel booking cancellation prediction analysis...

Your report is ready

Sent to — interactive charts, statistical results, R code, and AI insights.

Analyze another file
Sample Output

Every report includes interactive charts, tables, and AI insights

Upload your data to get your own report

View all case studies See all free tools

How it works

Logistic regression on hotel booking data predicting cancellation from lead time deposit type customer type market segment and prior cancellation history with seasonal trend analysis and model evaluation metrics

Use this when you have hotel booking records with a binary cancellation outcome and want to identify which booking characteristics drive cancellation risk and how rates trend over time

Do not use if your goal is survival analysis or if you lack a clear binary cancellation flag in the dataset

What data do you need?

Dataset with 15 columns

hotel (categorical) is_canceled (binary) lead_time (numeric) arrival_date_year (numeric) arrival_date_month (categorical) deposit_type (categorical) customer_type (categorical) previous_cancellations (numeric) reserved_room_type (categorical) assigned_room_type (categorical) market_segment (categorical) adults (numeric) children (numeric) adr (numeric) total_of_special_requests (numeric)

Minimum 100 rows

What's in the report?

Cornerstone #20 — logistic + time series on hotel booking demand (2,682 votes)

📈

Monthly Cancellation Rate Trend

Month-over-month cancellation rate by hotel type revealing seasonal peaks and trends

📊

Cancellation Rate by Deposit Type

Cancellation rates grouped by deposit policy (No Deposit, Non Refund, Refundable)

📊

Cancellation Rate by Market Segment

Cancellation rates grouped by booking channel and market segment

📦

Lead Time Distribution by Cancellation Status

Box plot of lead time in days split by whether booking was canceled or kept

📊

Cancellation Rate by Customer Type

Cancellation rates by customer segment Transient Contract Group Transient-Party

📊

Logistic Regression: Odds Ratios for Cancellation

Logistic regression odds ratios showing which predictors most increase or decrease cancellation risk

🟧

Reserved vs Assigned Room Type Matrix

Heatmap of reserved vs assigned room type showing frequency of room reassignment

📋

Model Performance Metrics

Model performance metrics accuracy AUC-ROC sensitivity and specificity on the test set

🤖

AI Insights

Plain-English interpretation — what the numbers mean, what's significant, and what to do next.

The Question This Answers

See description

See description

Questions?

See our FAQ for details on pricing, data privacy, and how the analysis works. Every report includes a Methodology section showing the statistical test, assumptions checked, and diagnostics run.

Your data has more stories to tell

Run any analysis on your own data — validated R analyses, interactive reports, AI insights, and PDF export.

Try Free — No Credit Card
Powered by MCP Analytics