Skip to content

IEMBA.Org

Interactive education for managerial business analytics

  • Home
  • Model Basics
    • Model Classification
  • Decision
    • Introduction to Decision Analysis
    • Sensitivity in Decision Analysis
    • Basic Probability
    • Leverage Information with Bayes Theorem
    • Use Rapid Strep Test for diagnosing Bacterial Infection
  • Data
    • Excel Basics
    • Data and Data Scale
    • Use SUMPRODUCT() to calculate weighted average
    • Pivot Table and Pivot Chart
    • Exponential Smoothing methods
    • Newsboy Simulation
  • Regression
    • Forecasting Models
    • Scatter Plot and Regression in Excel
    • Multiple Regression in Excel
    • Interpret Regression Output
  • About
    • About IEMBA.org
    • All about me.
    • About Interactive videos

Scatter Plot and Regression in Excel

On this page, we introduce two simulations that practice creating scatter plot and implement simple linear regression in Excel. Please use the attached file for practice.

Scatter plot

Click to open in a new window

Simple Regression in Excel

The correct way is to implement regression with Data Analysis ToolPak.

click the button to view full screen

  • Home
  • Model Basics
    • Model Classification
  • Decision
    • Introduction to Decision Analysis
    • Sensitivity in Decision Analysis
    • Basic Probability
    • Leverage Information with Bayes Theorem
    • Use Rapid Strep Test for diagnosing Bacterial Infection
  • Data
    • Excel Basics
    • Data and Data Scale
    • Use SUMPRODUCT() to calculate weighted average
    • Pivot Table and Pivot Chart
    • Exponential Smoothing methods
    • Newsboy Simulation
  • Regression
    • Forecasting Models
    • Scatter Plot and Regression in Excel
    • Multiple Regression in Excel
    • Interpret Regression Output
  • About
    • About IEMBA.org
    • All about me.
    • About Interactive videos

Recent Posts

  • Implement regression in Excel
  • Hello Business Analytics learners!

Recent Comments

  • A WordPress Commenter on Hello Business Analytics learners!
  • Home
  • Model Basics
    • Model Classification
  • Decision
    • Introduction to Decision Analysis
    • Sensitivity in Decision Analysis
    • Basic Probability
    • Leverage Information with Bayes Theorem
    • Use Rapid Strep Test for diagnosing Bacterial Infection
  • Data
    • Excel Basics
    • Data and Data Scale
    • Use SUMPRODUCT() to calculate weighted average
    • Pivot Table and Pivot Chart
    • Exponential Smoothing methods
    • Newsboy Simulation
  • Regression
    • Forecasting Models
    • Scatter Plot and Regression in Excel
    • Multiple Regression in Excel
    • Interpret Regression Output
  • About
    • About IEMBA.org
    • All about me.
    • About Interactive videos
IEMBA.Org Proudly powered by WordPress