Pular para o conteúdo

Move Beyond Excel with R for Health Technology Assessment

2 de novembro de 2026 · 27 min

Notas do episódio

A Conversation with Robert Smith

When should we move beyond Excel for health technology assessment?

I sit down with Dr Robert Smith to explore why increasingly complex health economic models call for a different approach—and how R can help.

We discuss the challenges of reviewing large spreadsheets, R’s strengths for simulation modelling, and how the R for HTA community shares tools and knowledge. Robert also explains how generative AI speeds up coding while making domain expertise, clear problem definition, and human judgement even more valuable. We close with practical ways to learn, contribute, and get involved in open-source work.

Why you should listen

If you work in statistics, health economics, or HTA, this conversation will help you assess where R could support your work. Together, we explore how to:

  • Recognise when a model’s complexity calls for a move beyond spreadsheets.
  • Connect statistical analyses and economic modelling within R.
  • Learn from an open-source community across academia, consultancies, and industry.
  • Use generative AI while keeping human judgement and domain expertise central.
  • Support junior colleagues as AI takes over more routine coding.
Episode highlights with timestamps
  • 02:25 — How Robert found his way into R and health economics
  • 03:54 — Why move beyond Excel?
  • 06:15 — The challenge of reviewing and maintaining spreadsheet models
  • 08:40 — Why R rather than Python?
  • 11:29 — What the R for HTA consortium brings together
  • 13:25 — Where the modelling work goes deeper
  • 15:47 — How to learn and get involved
  • 17:39 — Why industry supports open-source methods
  • 19:29 — How consultancies adapt their services
  • 20:51 — How generative AI changes model development
  • 23:17 — Why human judgement still drives the work
  • 25:08 — Start with a small contribution
Links and Resources:

🔗 Robert Smith on LinkedIn

🔗 Robert’s publications

🔗 R for HTA consortium

🔗 Dark Peak Analytics

🔗 R for Health Economics courses

🔗 Structured Expert Elicitation Platform

🔗 Learn more about PSI and become a member

🔗 The Effective Statistician Academy – I offer free and premium resources to help you become a more effective statistician.

🔗 My New Book: How to Be an Effective Statistician - Volume 1 – It’s packed with insights to help statisticians, data scientists, and quantitative professionals excel as leaders, collaborators, and change-makers in healthcare and medicine.

Join the Conversation:
Did you find this episode helpful? Share it with your colleagues and let me know your thoughts! Connect with me on LinkedIn and be part of the discussion.

Subscribe & Stay Updated:
Never miss an episode! Subscribe to The Effective Statistician on your favorite podcast platform and continue growing your influence as a statistician.

Todos os episódios de The Effective Statistician – in association with PSI

Configurações

Exibição

Idioma

Define quais estações você vê primeiro na página inicial.

Histórico

As rádios e episódios ouvidos recentemente e suas últimas buscas ficam só neste navegador.

Avisos

Um aviso rápido quando um podcast que você segue tem um episódio novo. Desative podcasts individuais pelo sino na página deles.

Conta

Salve favoritos – no app e no site.

Atalhos de teclado

/
Abrir busca
Espaço
Reproduzir ou pausar
← →
No player: voltar 15 s, avançar 30 s (episódios) · na fileira: próximo bloco
↑ ↓
Na fileira: alvo dentro do bloco
Home / End
Na fileira: primeiro ou último bloco
Esc
Fechar janela ou menu
?
Esta visão geral
Tocando agora

Ir para a estação

A seguir

    Adicione episódios com “A seguir” – eles tocam depois do episódio atual.