Back To Busn 210 Home Page

 

Files To Download for Chapter 12:

Note: These videos and files are from another that class that I teach (BI 348), but we will use them for our Busn 210 Chapter 12 study of Simple Linear Regression:

Excel file: BI348-Chapter04.xlsm

PowerPoint file: BI348-Chapter04.pptx (We will use slide #1-62)

Data Set For Ch 09 Homework File # 7,11,14-16,19,20: DataSetsForHomeworkProblemsChapter12.xlsx

 

Videos To Watch:

Note: These videos and files are from another that class that I teach (BI 348), but we will use them for our Busn 210 Chapter 12 study of Simple Linear Regression:

Basic Excel Business Analytics #44: Intro To Linear Regression & Scatter Chart (15:45 min)

Basic Excel Business Analytics #45: Covariance and Correlation to Measure Linear Relationship (15:57 min)

Basic Excel Business Analytics #46: Slope & Intercept for Estimated Simple Liner Regression Equation  (18:28 min)

Basic Excel Business Analytics #47: SST = SSR + SSE & R Squared & Standard Error of Estimate  (30:23 min)

Basic Excel Business Analytics #48: Data Analysis Regression feature (06:36 min)

Basic Excel Business Analytics #49: LINEST Array Function for Simple Linear Regression (04:44 min)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Old:

 

Files To Download for Chapter 12:

Excel file: Excel2013StatisticsChapter12.xlsm

PDF file: Ch12PDFBusn210.pdf

Data Set For Ch 09 Homework File #7,11,14: DataSetsForHomeworkProblemsChapter12.xlsm

 

Videos To Watch:

 

Excel 2013 Statistical Analysis #62: Calculate Slope and Intercept for Regression Line  (14:28 min)

 

 

Excel2013StatisticsChapter12Full.xlsx
Hw-210-Ch12Full.xlsx
DataSetsForHomeworkProblemsChapter12Full.xlsx

Busn210-Ch12-SmallExampleForNotes.xlsm