Repeated measures design analysed with ANOVA tools in MS-Excel

Kód výsledku v IS VaVaI

<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F44555601%3A13450%2F13%3A43885034" target="_blank" >RIV/44555601:13450/13:43885034 - isvavai.cz</a>

Výsledek na webu

—

DOI - Digital Object Identifier

—

Jazyk výsledku

angličtina

Název v původním jazyce

Repeated measures design analysed with ANOVA tools in MS-Excel

Popis výsledku v původním jazyce

MS-Excel is not a typical statistical SW, it does not contain statistical tools for many concrete situations, as the specialised statistical SW do. There are three ANOVA tools in MS-Excel available: ANOVA 1-factor and ANOVA 2-factors with or without replications, but they all are intended for the situations with independent values, only. The aim of this contribution is to show, how to perform the analysis of the repeated measures, with the help of these Excel analytical ANOVA tools. Such designs are often used in practical trials. This contribution proves the validity of the approach and performs a practical manual, how to do it. The situations concerning single-factor and two-factor repeated measures data (balanced situation only), respectivelly, arediscussed. Concrete examples are solved as an illustration.

Název v anglickém jazyce

Repeated measures design analysed with ANOVA tools in MS-Excel

Popis výsledku anglicky

MS-Excel is not a typical statistical SW, it does not contain statistical tools for many concrete situations, as the specialised statistical SW do. There are three ANOVA tools in MS-Excel available: ANOVA 1-factor and ANOVA 2-factors with or without replications, but they all are intended for the situations with independent values, only. The aim of this contribution is to show, how to perform the analysis of the repeated measures, with the help of these Excel analytical ANOVA tools. Such designs are often used in practical trials. This contribution proves the validity of the approach and performs a practical manual, how to do it. The situations concerning single-factor and two-factor repeated measures data (balanced situation only), respectivelly, arediscussed. Concrete examples are solved as an illustration.

Druh

O - Ostatní výsledky

CEP obor

BB - Aplikovaná statistika, operační výzkum

OECD FORD obor

—

Projekt

<a href="/cs/project/NT14448" target="_blank" >NT14448: Změny frakční anizotropie, průměrné difuzivity a volumetrických hodnot u pacientů s normotenzním hydrocefalem.</a><br>

Návaznosti

P - Projekt vyzkumu a vyvoje financovany z verejnych zdroju (s odkazem do CEP)

Rok uplatnění

2013

Kód důvěrnosti údajů

S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů