Excel 2016 for PC - Statistical Analysis

Rapid Skillz

Course

Online

£ 47.15 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

Microsoft® Excel® boasts a robust collection of statistical functions. This Excel 2016 for PC – Statistical Analysis online training series will demonstrate some of these functions from the simple to the complex, as well as how to perform more complex analysis by activating Excel’s Data Analysis ToolPak.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

In this in-depth Excel 2016 for PC – Statistical Analysis online training series presented by Dan Fanella, PhD, you’ll learn about describing data, comparing variables, tests of significance, performing a liar regression, and so much more. By the time you’ve completed this course, you’ll be an expert on topics such as creating a histogram, finding the linear slope, and finding the geometric mean.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Probability
  • MS Excel
  • PC training
  • PC
  • Excel
  • Data analysis
  • Conditional Formatting
  • Pivot tables
  • Advanced Formulas
  • Tables & Formatting
  • Advanced Charting
  • Pivot Reporting
  • VBA & Macros
  • Excel Productivty
  • Examining data

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

A. Describing Data
  • What you’ll learn in this training
  • Finding the arithmetic mean
  • AVERAGEA function
  • AVERAGEIF function
  • AVERAGEIFS function
  • Find the geometric mean
  • Find the median
  • Find the mode
  • Find the standard deviation
  • Use the STDEVA functions
  • Find the variance
  • Use the VARA functions
  • Find the kurtosis of a distribution
  • Find the skewness of a distribution
  • Find the confidence interval
  • Use the FREQUENCY function
  • Find the quartile of a data set
  • Ranking values
  • Finding a value’s standard score
B. Comparing Variables
  • Find the bivariate correlation coefficient
  • Find the values associated with a linear regression
  • Find linear slope
  • Find the y-intercept of a linear regression
  • Predict a future value using an existing value
  • TREND function
  • Find the values associated with an exponential regression
  • Predicting values along an exponential curve using existing values
C. Tests of Significance
  • Finding the probability of a one-tailed Z-Test
  • Finding the probability associated with a Student’s T-Test for paired samples
  • Finding the critical value of the Student’s T-Test for paired samples
  • Examining data for homogeneity of variance using F-TEST function
  • Finding the critical value of the F-test
  • Finding the probability associated with a student’s T-Test for independent samples
  • Finding the critical value of the student’s T-Test for independent samples
  • Finding the probability associated with a chi-squared test for independence
  • Finding the critical value of the chi-squared test for independence
D. Printing Options & Copying a Pivot Table
  • Printing a Pivot Table with column and row field
  • Insert page breaks after each row item
  • Copy a Pivot Table
E. Data Analysis ToolPak
  • Activating the data analysis ToolPak
  • Finding descriptive statistics
  • Create a histogram
  • Performing a T-test for paired or related samples
  • Examining data for homogeneity of variance
  • Performing a T-test for independent or unrelated samples
  • Performing a one-way analysis of variance (ANOVA)
  • Performing a factorial analysis of variance (ANOVA)
  • Performing a repeated measures analysis of variance (ANOVA)
  • Finding the correlation of two or more variables
  • Performing a linear regression

Additional information

LENGTH

1 hr 20 min

See related categories

Excel 2016 for PC - Statistical Analysis

£ 47.15 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all