Intermediate Statistics with Excel
Date:
04/12/2020
Organised by:
Royal Statistical Society
Presenter:
Ellen Marshall
Level:
Intermediate (some prior knowledge)
Contact:
Description:
Course Outline
Multiple linear regression is one of the most commonly used techniques in statistics and allows for the impact of multiple variables to be assessed simultaneously. The analysis of variance (ANOVA) is a related technique which allows the mean values of several groups to be compared. This course will equip participants with the skills necessary to undertake both types of analysis using free software, understand and interpret the output, check the assumptions that underpin each type of model, and present the results coherently.
Learning Outcomes
By the end of this course the attendees will:
-
Understand what is meant by the term Analysis of Variance (ANOVA) and the different ANOVA models available
-
Assess when it is appropriate to fit an analysis of variance
-
Interpret the result s of an analysis of variance
-
Assess model fit
-
Present the results of an analysis of variance
-
Understand what is meant by the term multiple linear regression
-
Assess when it is appropriate to fit a multiple linear regression model
-
Carry out a regression analysis using free software
-
Interpret the results of a multiple linear regression analysis
-
Assess model fit
-
Present the results of a multiple linear regression analysis
Topics Covered
The morning will start with a brief recap on the concepts of hypothesis testing and choosing the right test. This will include the basic use of Jamovi to carry out and interpret an independent t-test before progressing to the related technique ANOVA. Assumption checking, two-way ANOVA’s and interactions will conclude the morning.
The afternoon starts with correlation and simple linear regression to assess the relationship between two continuous variables before concentrating on multiple regression which allows multiple variables to be tested simultaneously. Both sessions will concentrate on producing and understanding outputs rather than mathematical content with regular exercises to reinforce learning.
Target Audience
This course is aimed at individuals who have some basic statistical knowledge and who wish to undertake analyses of quantitative data and who therefore wish to gain some insight into how to undertake these.
Cost:
Ranges from £377-£522 inc. VAT
Website and registration:
Region:
Greater London
Keywords:
Regression Methods, Linear regression, Excel, ANOVA
Related publications and presentations:
Regression Methods
Linear regression
Excel