Skip to study
← Back to Galarza Lab
Galarza Lab / Data & AI / Comparative study

Calgary Fuel Price Forecasting

One challenge. Six AI-assisted solutions. One transparent comparison. Explore the workflow, project evidence and results without confusing documentation with verified model performance.

Calgary, Alberta2021–2026 historical observationsSix solution tracksStudy version 1.1
Research brief

Forecast the next recorded-day gasoline price

This study investigates time-series approaches for forecasting regular gasoline prices in Calgary. Model quality must be evaluated on a consistent future holdout, not on in-sample performance, visual appeal or an AI platform’s claims.

1,516Historical price observations
303Chronological validation rows
3.320ChatGPT workflow MAE · ¢/L
9.1%MAE reduction vs baseline
Forecasting process showing historical price data, lag features, chronological validation and governance
Reference figure 1 — documented machine-learning workflow (schematic, not an interface screenshot).
Bar chart showing MAE 3.653 cents per litre for previous-price baseline and 3.320 for Linear Regression
Reference figure 2 — verified ChatGPT workflow validation MAE against the previous-price baseline.

Scope note: 1,516 recorded-day observations are documented through October 23, 2026. The original assignment worksheet mentions an October 20, 2026 cutoff; comparisons should use one reconciled, frozen data version.

Solution 01 / 06

ChatGPT

Documented

Time-series dataset inspection; lag and rolling-feature engineering; chronological model validation; decision rationale and governance.

Recorded validation results

Selected approach: Linear Regression; MAE: 3.320 ¢/L; RMSE: 4.804 ¢/L; baseline MAE: 3.653 ¢/L.

Reported feature set: lags 1, 2, 3 and 5; rolling five-observation mean and standard deviation, plus a previous change feature. Training: 1,208 rows; validation: 303 rows. This is an internal chronological split, not an independent evaluation of all six AI solutions.

Evidence note

Historical workflow and model comparison are evidenced. Local app file was produced in an earlier exercise, but is not bundled in this Lab package.

Add the original ChatGPT forecasting app, its screenshots and validated datasets as approved public assets.

Solution 02 / 06

Google Notebook / Colab

Awaiting evidence

Notebook-based data exploration, reproducibility, code execution, models, diagnostics, and forecasting interface as demonstrated in your actual notebook.

Validation results

Not documented yet. No MAE, RMSE, accuracy ranking or deployment claims are assigned to this solution.

Evidence note

No separate notebook results or URL have been supplied. This heading intentionally accommodates Google Colab or NotebookLM until the actual product and output are identified.

Add notebook link, screenshots, executed cells, validation metrics and dataset version.

Solution 03 / 06

Google AI Studio

Awaiting evidence

Prompt-driven implementation, interface design, model invocation, deployment options, and validation when documented.

Validation results

Not documented yet. No MAE, RMSE, accuracy ranking or deployment claims are assigned to this solution.

Evidence note

No Google AI Studio outputs or evaluation have been supplied.

Add application link, prompt methodology, screenshot and quantified metrics.

Solution 04 / 06

Perplexity

Awaiting evidence

Research methodology, source use, generated code or application behavior, as supported by the actual implementation.

Validation results

Not documented yet. No MAE, RMSE, accuracy ranking or deployment claims are assigned to this solution.

Evidence note

No independent Perplexity test results or screenshots are available in this package.

Add project URL, sources, model code or exported result and accuracy metrics.

Solution 05 / 06

Claude

Awaiting evidence

Development workflow, application design, execution, and time-series evaluation when provided.

Validation results

Not documented yet. No MAE, RMSE, accuracy ranking or deployment claims are assigned to this solution.

Evidence note

No Claude-specific results or deployed application have been supplied.

Add published artifact, methodology, screenshot and validation details.

Solution 06 / 06

Gemini

Awaiting evidence

Feature engineering, forecasting behavior, model selection and testing against a common holdout dataset when available.

Validation results

Not documented yet. No MAE, RMSE, accuracy ranking or deployment claims are assigned to this solution.

Evidence note

No Gemini-specific results or deployment evidence have been supplied.

Add Gemini solution URL, screenshots, metrics and testing notes.

Section 07 / 07

Summary comparison of solutions

This table is a structured comparison framework, not a six-way benchmark. Only independently documented results are quantified.

PlatformOutput evidenceHoldout MAE (¢/L)RMSE (¢/L)Public application
ChatGPTWorkflow and metrics documented3.3204.804Not linked here
Google Notebook / ColabAwaiting materialsNot verifiedNot verifiedNot linked
Google AI StudioAwaiting materialsNot verifiedNot verifiedNot linked
PerplexityAwaiting materialsNot verifiedNot verifiedNot linked
ClaudeAwaiting materialsNot verifiedNot verifiedNot linked
GeminiAwaiting materialsNot verifiedNot verifiedNot linked

Fair comparison protocol

  1. Use identical price observations, recorded-day calendar, target definition and validation dates.
  2. Require every forecast to use only information available before the target date; exclude data leakage.
  3. Compute MAE, RMSE and median absolute error on identical rows, alongside the previous-price baseline.
  4. Compare interval coverage and width, reproducibility, execution cost, code quality and usability.
  5. Record each platform's version, prompts, code, screenshots and limitations before naming a winner.

Publication checklist: Place approved screenshots in assets/fuel/screenshots/; link original apps and reports only after validating access; add versioned comparable prediction CSVs. Never expose API keys, private prompts, account details or licensed third-party datasets.

The illustration graphics on this page are original explanatory SVGs. All six screenshot areas are placeholders until real screenshots are uploaded.