This course is the first hands-on module in the sequence giving participants experience in building a dataset and running statistical analysis using regressions through Excel.

Learning Objectives
  • Discover how to gather data via the Federal Reserve’s Excel Add-in
  • Recognize the basic structure of datasets in Excel
Last updated/reviewed: August 26, 2023
Course Search
7 Reviews (23 ratings)

Reviews

3
Member's Profile
Great introduction to tools available, however, would have expected more coverage on the actual data regression topic itself vs. all of the data gathering process.
4
Member's Profile
This course had good examples for understanding what is available to perform data analysis and how and why the different tools are used.
3
Anonymous Author
A little more generic than expected, although I did not previously know what exponential smoothing was and when it could be used.
5
Member's Profile
excellent presentantion please keep on sharing good stuff like this
4
Anonymous Author
Course wan't what I was expecting, but it was a good introduction.
4
Member's Profile
The video screens were not clear on a few of the presentations.
4
Anonymous Author
I was not aware of the FRED add-in for Excel.
Prerequisites
Course Complexity: Intermediate

Viewers should have completed all prior modules in the certification program before advancing to the hands on portion.

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
  Course Overview CPE
Course Syllabus
Introduction and Overview
  Introduction to Doing Data Analytics in Excel00:44
  Model 1 to Data Analysis in Excel7:36
  Model 2 Data Analysis in Excel11:47
CONTINUOUS PLAY
  Doing Data Analysis in Excel (Hands-on Module)20:28
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam