Skip to main content

Statistical Analysis and Modeling Using Excel


Development Academy of the Philippines
Enrollment is Closed

Course Overview

Statistics transforms data into meaningful information, enabling organizations to make better decisions and predictions. Hence, it is a valuable skill to learn in business or academia. This course will teach participants how to perform the most important and commonly used analytics and modeling techniques in Excel. Topics covered include descriptive, diagnostic, predictive, and prescriptive analytics. Participants will be trained using a case-based approach with either real or simulated data sets, to solidify their knowledge so they can apply the techniques that they have learned to their own work.

What You Will Learn

Upon completion of this course, the learners are expected to:

  • better understand what has happened to a business or organization, based on historical data, by performing foundational analytic techniques (e.g. aggregation-based analysis, descriptive statistics, profiling, and segmentation) using Excel’s basic functionalities;
  • leverage powerful statistical functions and add-ins of Excel to test business hypotheses or to make forecasts or predictions; and
  • use Excel’s What-If functionality to perform simulations, sensitivity analysis, and optimization that would support recommendation of preferred course of action.

Requirements

You will need a computer or laptop with Microsoft Excel installed. Computer or laptop requirements are:

  • For Windows: Core i3 or better, 4GB RAM or better, MS Excel 2007 or better
  • For MacBook: ideally MS Excel 2013 or newer should be installed (some functions require this version on the Mac). If the version of MS Excel is 2011, download and install StatPlus.

Note to SPARTA scholars: Upon enrollment, you will have 6 months to finish a SPARTA course. Failure to complete the course in 6 months and/or inactivity for 3 months will result in course access revocation.


Course Content

Week 1: Descriptive Analytics

8 Videos | 4 Activities

8 Videos

  • Welcome to the course!
  • What is a Data Value Chain?
  • Data Sources
  • Types of Analytics
  • What is Descriptive Analytics?
  • Descriptive Measures in Excel
  • Descriptive Analytics Use-Cases
  • Summary

4 Activities

  • Recall Activities
  • Quiz: Descriptive Analytics

Week 2: Diagnostic Analytics

8 Videos | 4 Activities

8 Videos

  • What is Diagnostic Analytics?
  • Function of Diagnostic Analytics
  • Association vs. Correlation
  • What is hypothesis testing?
  • Hypothesis Testing Terminologies
  • Chi-Square Test of Independence
  • T-Test
  • One-Way Analysis of Variation (ANOVA)

4 Activities

  • Recall Activities
  • Quiz: Diagnostic Analytics

Week 3: Predictive Analytics

4 Videos | 2 Activities

4 Videos

  • What is Predictive Analytics?
  • Predictive Analytics Process
  • Defining a Linear Regression Problem
  • Simple and Multiple Linear Regression
  • Splitting the Dataset
  • Coefficient of Determination (R-Squared)
  • Analysis of Variance
  • T-Tests
  • Model Interpretation
  • Forecast Accuracy Measures
  • Using Qualitative Predictors
  • Overview of Logistic Regression and Its Model Interpretation
  • Predictive Strength Measures
  • 3 Activities

    • Recall Activities
    • Quiz: Predictive Analytics

    Week 4: Prescriptive Analytics

    6 Videos | 2 Activities

    6 Videos

    • What is Prescriptive Analytics?
    • Simulation vs. Optimization
    • Goal Seek
    • Data Table
    • Scenario Manager
    • Solver

    2 Activities

    • Recall Activities
    • Quiz: Prescriptive Analytics

    Week 5: Capstone Project

    1 Video | 1 Activity

    1 Video

    • Key Takeaways

    1 Activity

    • Capatone: Data-Driven Solution using Excel
    1. Course Number

      SP801
    2. Classes Start

      TBA
    3. Classes End

    4. Estimated Effort

      1-2 hours/week (10 hours)
    5. Price

      Php1000
    6. Prerequisites

      Development Academy of the Philippines SP101

      You must successfully complete Development Academy of the Philippines SP101 before you begin this course.