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