BUS 341: Introductory business analytics

SCHEDULE

WEEK 1

1/14 (M): Class canceled

1/16 (W): Introduction

1/18 (F): Part 1: Excel Review | Basics

WEEK 2

1/21 (M): MLK Day | No class

1/23 (W): Class canceled

1/25 (F): Class canceled

WEEK 3

1/28 (M): Basic functions

1/30 (W): Class canceled

2/1 (F): Numeric functions | Fortune 500 Spreadsheet

WEEK 4

2/4 (M): Text functions

2/6 (W): Logical functions

2/8 (F): Part 2: Exploring Data | Categorical variables | vlookup function | Questionnaire Data | Supermarket Transactions

WEEK 5

2/11 (M): Summarizing categorical variables | Visualization first step

2/13 (W): Exam 1 | Exercise 1

2/15 (F): Numerical variables | Baseball Salaries

WEEK 6

2/18 (M): Summarizing numerical variables | A look at time series data | S&P 500 Daily

2/20 (W): Visualization of numerical variables | Crosstab | Smoking Drinking | Baseball Salaries Extra

2/22 (F): Relationship among numerical variables | Stock Return Correlations

WEEK 7

2/25 (M): Exam 2 | Exercise 2 | Commute Time | CEO Compensation | Golf Stats | Chicago Marathon

2/27 (W): Pivot table | Electmart Sales

3/1 (F): Pivot table

WEEK 8

3/11 (M): Pivot table | Gluten Free

3/13 (W): Part 3: Probability: Definition and fundamentals | Married Women

3/15 (F): Simulation of discrete events | Randomness of discrete variables

WEEK 9

3/18 (M): Continuous variables

3/20 (W):  Exam 3 | Exercise 3 | House Price | NBA | Gluten Free Filled | Missing

3/22 (F): Normal distribution

WEEK 10

3/25 (M): Normal distribution application | Oven Demand Simulation

3/27 (W): Binomial distribution | Airline Overbooking

3/29 (F): Part 4: Statistical Inference | Central Limit Theorem | Wheel of Fortune | Auditing Receivables

WEEK 11

4/1 (M): Point estimate and confidence interval | Fast Food Time

4/3 (W): Exam 4 | Exercise 4

4/5 (F): t-distribution & Confidence interval | Satisfaction Ratings

WEEK 12

4/8 (M): Flunk Day

4/10 (W): Part 5: Hypothesis Testing | Defects | Pizza Ratings | Light Bulbs

4/12 (F): p-value | One- and two-tail hypothesis testing | Thickness

WEEK 13

4/15 (M): Sample mean difference hypothesis testing | Food Expenditure | Exercises & Productivity

4/17 (W): Exam 5 | Exercise 5 | Professors | NFL Player Salary | New Product | Household Debts

4/19 (F): Part 6: Regression | Fitted lines and scatterplots | Drugstore Sales | Home Size and Power Usage

WEEK 14

4/22 (M):  Multiple regression | Movies | Home Prices | Bank Salaries

4/24 (W): Course evaluation | Interpretation of regression results

4/26 (F): 

WEEK 15

4/29 (M): Exam 6 | Exercise 6