BUS 430 Business Analytics
144 videos • 3,684 views • by The Stats Files - Dawn Wright Ph.D.
Short tutorials for BUS430. Excel and add-ins
1
How to buy PHStat - a Statistical Add in for Excel For PC & Mac
The Stats Files - Dawn Wright Ph.D.
Download
2
Using PHStat to Solve a Hypothesis Test for Single Sample t-test for the mean - Evans Chapter 5.
The Stats Files - Dawn Wright Ph.D.
Download
3
Using Solver with Excel 2016 for Linear Optimization Problems - Part 2 -Evans Chapter 13
The Stats Files - Dawn Wright Ph.D.
Download
4
8.2.11 T-test for Difference in 2 Means, unequal variances Excel PHStat
The Stats Files - Dawn Wright Ph.D.
Download
5
Using Excel 2016 Solver to Find the Optimum Value of Alpha for an Exponential Smoothing Forecast
The Stats Files - Dawn Wright Ph.D.
Download
6
6. Comparing Excel, PHStat, and StatCrunch Solutions to a Confidence Interval for a Mean
The Stats Files - Dawn Wright Ph.D.
Download
7
How to Set Up a Two Variable Data Table in Excel
The Stats Files - Dawn Wright Ph.D.
Download
8
7. Using Excel with PHStat to Solve an Autoregressive Forecast Problem
The Stats Files - Dawn Wright Ph.D.
Download
9
How to Use Excel to Calculate MAD, MSE, RMSE & MAPE
The Stats Files - Dawn Wright Ph.D.
Download
10
How to set up a linear optimization problem using Excel Solver 2016 - Part 1- Evans Chapter 13
The Stats Files - Dawn Wright Ph.D.
Download
11
Diagnosing Problems with Excel Solver model. - Evans Chapter 13
The Stats Files - Dawn Wright Ph.D.
Download
12
How to Install TreePlan in Excel 2016 - Evans Chapter 11
The Stats Files - Dawn Wright Ph.D.
Download
13
How to set up a 2 variable data table in Excel 2016.
The Stats Files - Dawn Wright Ph.D.
Download
14
[Private video]
Download
15
7.2.36 Using Excel and PHStat for Single Sample Mean z-test Hypothesis Test Sigma Known
The Stats Files - Dawn Wright Ph.D.
Download
16
Solving Normal Distribution Problems using Excel
The Stats Files - Dawn Wright Ph.D.
Download
17
How to build a decision model in Excel
The Stats Files - Dawn Wright Ph.D.
Download
18
How to use Excel Goal Seek, Solver, and Scenario Manager to solve a business decision model.
The Stats Files - Dawn Wright Ph.D.
Download
19
Review of M5A1 using Excel What If and Solver
The Stats Files - Dawn Wright Ph.D.
Download
20
8.1.11 two sample z Excel PHStat and StatCrunch to Solve a Difference of Two Means Hypothesis Test
The Stats Files - Dawn Wright Ph.D.
Download
21
8.3.10 Paired Sample Hypothesis Test with Raw Data using PhStat and Excel
The Stats Files - Dawn Wright Ph.D.
Download
22
9.2.19 Simple Linear Regression and prediction using Excel & PHStat
The Stats Files - Dawn Wright Ph.D.
Download
23
Relative Frequency Histogram using Basic Excel Functions
The Stats Files - Dawn Wright Ph.D.
Download
24
Guidance on column charts in Excel
The Stats Files - Dawn Wright Ph.D.
Download
25
Tableau-Wealth distribution
The Stats Files - Dawn Wright Ph.D.
Download
26
PHStat Workaround
The Stats Files - Dawn Wright Ph.D.
Download
27
5.3.28M How to solve a Normal Probability problem with Excel and PHStat
The Stats Files - Dawn Wright Ph.D.
Download
28
Organize Your Excel Assignment File
The Stats Files - Dawn Wright Ph.D.
Download
29
Hangout 2-1-17 bus 430
The Stats Files - Dawn Wright Ph.D.
Download
30
Excel PHStat Expected Monetary Value & Expected Value of Perfect Information Tool
The Stats Files - Dawn Wright Ph.D.
Download
31
Hangout 4-7-17-part 1
The Stats Files - Dawn Wright Ph.D.
Download
32
Hangout 4 7 17-1
The Stats Files - Dawn Wright Ph.D.
Download
33
Secret to Installing PHStat Add-in in Excel Updated 2021
The Stats Files - Dawn Wright Ph.D.
Download
34
Find Joint and Marginal Probabilities Using Pivot Table in Excel 2016
The Stats Files - Dawn Wright Ph.D.
Download
35
BUS 430 Example Report
The Stats Files - Dawn Wright Ph.D.
Download
36
BUS 430 Excel Forecasting problem using linear regression
The Stats Files - Dawn Wright Ph.D.
Download
37
How to Evaluate MAD, MSE, RMSE, and MAPE for an Excel Forecast
The Stats Files - Dawn Wright Ph.D.
Download
38
BUS 430 Scenario Summary Setup
The Stats Files - Dawn Wright Ph.D.
Download
39
How to Build a Histogram Using Basic Excel Functions.
The Stats Files - Dawn Wright Ph.D.
Download
40
BUS 431 Monte Carlo Make vs Buy Problem Using Excel Only Part 2
The Stats Files - Dawn Wright Ph.D.
Download
41
How to create a Monte Carlo simulation dynamic histogram with Excel
The Stats Files - Dawn Wright Ph.D.
Download
42
Monte Carlo Simulation: Basic Decision Model in Excel Part 1
The Stats Files - Dawn Wright Ph.D.
Download
43
Review of Excel-PHStat Multiple Regression
The Stats Files - Dawn Wright Ph.D.
Download
44
Excel Expected Monetary Value (EMV) Payoff Table
The Stats Files - Dawn Wright Ph.D.
Download
45
Excel only Monte Carlo Simulation with Multiple Random variables Part 4
The Stats Files - Dawn Wright Ph.D.
Download
46
Excel Monte Carlo Simulation Triangular Distribution Calculator
The Stats Files - Dawn Wright Ph.D.
Download
47
Deric Simquick
The Stats Files - Dawn Wright Ph.D.
Download
48
Adding confidence intervals to a scatter plot in Excel 2016
The Stats Files - Dawn Wright Ph.D.
Download
49
Adding Confidence Intervals to Scatter Plot of Means in Excel 2016
The Stats Files - Dawn Wright Ph.D.
Download
50
Excel and PHStat Find Confidence and Prediction Intervals for a Forecast Value
The Stats Files - Dawn Wright Ph.D.
Download
51
8.3.17 Paired Sample t-test using Excel/ PHStat & Data Analysis
The Stats Files - Dawn Wright Ph.D.
Download
52
4.2.21 Binomial Distribution using Excel with the PHStat Add-in
The Stats Files - Dawn Wright Ph.D.
Download
53
Using Excel and PHStat for Single Sample Proportion Problem
The Stats Files - Dawn Wright Ph.D.
Download
54
Durbin-Watson Statistic using Excel with PHStat
The Stats Files - Dawn Wright Ph.D.
Download
55
Cumulative Frequency Chart using Excel Data Analysis Histogram Tool
The Stats Files - Dawn Wright Ph.D.
Download
56
Exponential Smoothing Forecast Excel 2016 Data Analysis Toolpak
The Stats Files - Dawn Wright Ph.D.
Download
57
Setting up Decision Models in Excel for Optimization with binary constraints using Solver
The Stats Files - Dawn Wright Ph.D.
Download
58
Finding outliers: use Excel functions and formulas and create a box & whisker plot.
The Stats Files - Dawn Wright Ph.D.
Download
59
Hot to Find Outliers Using Excel
The Stats Files - Dawn Wright Ph.D.
Download
60
Normal and Empirical Probabilities using Excel
The Stats Files - Dawn Wright Ph.D.
Download
61
Using Excel to Find Normal and Empirical Probabilities
The Stats Files - Dawn Wright Ph.D.
Download
62
Binomial Distribution using Excel
The Stats Files - Dawn Wright Ph.D.
Download
63
SimQuick Process Simulation for Excel Part 1 Overview
The Stats Files - Dawn Wright Ph.D.
Download
64
SimQuick Process Simulation for Excel Setup Part 2
The Stats Files - Dawn Wright Ph.D.
Download
65
Excel Expected Monetary Value and Value of Perfect Information using PHStat
The Stats Files - Dawn Wright Ph.D.
Download
66
M7 TreePlan for Excel-Decision Tree Basics
The Stats Files - Dawn Wright Ph.D.
Download
67
[Private video]
Download
68
Data Analysis Toolpak Activation in Excel 2016
The Stats Files - Dawn Wright Ph.D.
Download
69
Add Cumulative Frequency Data Curve to a Histogram in Excel
The Stats Files - Dawn Wright Ph.D.
Download
70
How to link an Excel Chart and Table to Word
The Stats Files - Dawn Wright Ph.D.
Download
71
How to use Excel and PHStat to create z and t Confidence Intervals
The Stats Files - Dawn Wright Ph.D.
Download
72
10.1.15 Chi-square Goodness Test of Fit uniform distribution using basic Excel functions
The Stats Files - Dawn Wright Ph.D.
Download
73
Using Excel Pivot Tables to Find Data
The Stats Files - Dawn Wright Ph.D.
Download
74
Decision Model Basics for Excel Solver Optimization
The Stats Files - Dawn Wright Ph.D.
Download
75
Why do we say Fail to Reject the Null Hypothesis? Why can't I accept the Null Hypothesis?
The Stats Files - Dawn Wright Ph.D.
Download
76
Use Excel Pivot Table to Find Office Department Counts
The Stats Files - Dawn Wright Ph.D.
Download
77
One sample z test for Mean using Excel Calculator
The Stats Files - Dawn Wright Ph.D.
Download
78
M3A1- 4 Histogram Excel
The Stats Files - Dawn Wright Ph.D.
Download
79
M3A1-4 Empirical Count Probabilities using Excel
The Stats Files - Dawn Wright Ph.D.
Download
80
M3A1-3 Pivot Table Common Mistake
The Stats Files - Dawn Wright Ph.D.
Download
81
Copy and Paste Decision Model in Excel
The Stats Files - Dawn Wright Ph.D.
Download
82
M7A1 Named Cells - Excel
The Stats Files - Dawn Wright Ph.D.
Download
83
Linear Programming Transportation Problem with Excel Solver - Optimization
The Stats Files - Dawn Wright Ph.D.
Download
84
M7A1 Goal Seek 2- Excel
The Stats Files - Dawn Wright Ph.D.
Download
85
Excel 2016 Pivot Tables Part 1 Overview
The Stats Files - Dawn Wright Ph.D.
Download
86
Excel 2016 Pivot Tables Part 3 Build the Report
The Stats Files - Dawn Wright Ph.D.
Download
87
Excel 2016 Pivot Table Overview Part 4: Select & Extract Records
The Stats Files - Dawn Wright Ph.D.
Download
88
Two-sample t-test using Excel Data Analysis ToolPak
The Stats Files - Dawn Wright Ph.D.
Download
89
How to fix a No Connection Pivot Table Slicer?
The Stats Files - Dawn Wright Ph.D.
Download
90
How to Format a chart Axis in an Excel Chart
The Stats Files - Dawn Wright Ph.D.
Download
91
How to take a random sample using Excel
The Stats Files - Dawn Wright Ph.D.
Download
92
How to make a Histogram using Basic Excel functions to find Bin Upper and Lower Limits
The Stats Files - Dawn Wright Ph.D.
Download
93
How to do a 2-way Chi-square Test for Independence (contingency table) using free Excel calculator
The Stats Files - Dawn Wright Ph.D.
Download
94
How to get the data into the one-sample z-test calculator
The Stats Files - Dawn Wright Ph.D.
Download
95
How to make a Scatter Chart for Linear Regression using the Excel Data Analytics Tool
The Stats Files - Dawn Wright Ph.D.
Download
96
Module 1 Assignment old
The Stats Files - Dawn Wright Ph.D.
Download
97
Example Report
The Stats Files - Dawn Wright Ph.D.
Download
98
Excel Scatter Plot
The Stats Files - Dawn Wright Ph.D.
Download
99
Excel Simple Linear Regression
The Stats Files - Dawn Wright Ph.D.
Download
100
Excel Trendline and Equation
The Stats Files - Dawn Wright Ph.D.
Download
101
Multiple Regression with Categorical Data
The Stats Files - Dawn Wright Ph.D.
Download
102
Multiple Regression with Interaction
The Stats Files - Dawn Wright Ph.D.
Download
101
Multiple Regression with Categorical Data
The Stats Files - Dawn Wright Ph.D.
Download
102
Multiple Regression with Interaction
The Stats Files - Dawn Wright Ph.D.
Download
103
Two sample t test mean difference
The Stats Files - Dawn Wright Ph.D.
Download
104
Using Pivot Tables to find data
The Stats Files - Dawn Wright Ph.D.
Download
105
Excel 2016 Forecast Tool
The Stats Files - Dawn Wright Ph.D.
Download
106
Excel Forecast Basics
The Stats Files - Dawn Wright Ph.D.
Download
107
Excel Forecasts Moving Average
The Stats Files - Dawn Wright Ph.D.
Download
108
Plot Two Data Sets on One Graph
The Stats Files - Dawn Wright Ph.D.
Download
109
Seasonality and Trend - Final Forecast
The Stats Files - Dawn Wright Ph.D.
Download
110
Seasonality and Trend
The Stats Files - Dawn Wright Ph.D.
Download
111
Seasonality
The Stats Files - Dawn Wright Ph.D.
Download
112
Simple Exponential Smoothing
The Stats Files - Dawn Wright Ph.D.
Download
113
Basic Monte Carlo Simulation Data Table Construction in Excel
The Stats Files - Dawn Wright Ph.D.
Download
114
Copy Model
The Stats Files - Dawn Wright Ph.D.
Download
115
How to create a Data Table in Excel
The Stats Files - Dawn Wright Ph.D.
Download
116
Decision Models in Excel
The Stats Files - Dawn Wright Ph.D.
Download
117
Decision Models with Uncertainty
The Stats Files - Dawn Wright Ph.D.
Download
118
Enabling Solver in Excel 2016
The Stats Files - Dawn Wright Ph.D.
Download
119
Goal Seek
The Stats Files - Dawn Wright Ph.D.
Download
120
Histogram Using Basic Excel Functions
The Stats Files - Dawn Wright Ph.D.
Download
121
Making Histogram Dynamic
The Stats Files - Dawn Wright Ph.D.
Download
122
Normally Distributed Random Variable
The Stats Files - Dawn Wright Ph.D.
Download
123
Random Variable with Discrete Distribution
The Stats Files - Dawn Wright Ph.D.
Download
124
Scenario Manager
The Stats Files - Dawn Wright Ph.D.
Download
125
Solver Basics
The Stats Files - Dawn Wright Ph.D.
Download
126
Uniformly Distributed Random Variable
The Stats Files - Dawn Wright Ph.D.
Download
127
Using Monte Carlo Simulation Output
The Stats Files - Dawn Wright Ph.D.
Download
128
M8 Assignment Intro
The Stats Files - Dawn Wright Ph.D.
Download
129
M2 Assignment Intro
The Stats Files - Dawn Wright Ph.D.
Download
130
0.1 BUS 431 Intro
The Stats Files - Dawn Wright Ph.D.
Download
131
M3 Assignment Intro
The Stats Files - Dawn Wright Ph.D.
Download
132
M4 Assignment Intro
The Stats Files - Dawn Wright Ph.D.
Download
133
M5 Assignment Intro
The Stats Files - Dawn Wright Ph.D.
Download
134
M6 Assignment Intro
The Stats Files - Dawn Wright Ph.D.
Download
135
M2 Task 1
The Stats Files - Dawn Wright Ph.D.
Download
136
Conditional Probabilities using Excel
The Stats Files - Dawn Wright Ph.D.
Download
137
BUS 431 Introduction
The Stats Files - Dawn Wright Ph.D.
Download
138
How to Add Data to an Existing Excel Chart
The Stats Files - Dawn Wright Ph.D.
Download
139
How to Copy and Paste to Add new Data To Excel Chart
The Stats Files - Dawn Wright Ph.D.
Download
140
How to Product Mix Problem: Maximize profit using Linear Optimization/Programming Excel and Solver
The Stats Files - Dawn Wright Ph.D.
Download
141
How to create custom x-axis labels in Excel
The Stats Files - Dawn Wright Ph.D.
Download
142
Module 3 Two sample t test for Mean
The Stats Files - Dawn Wright Ph.D.
Download
143
M4A1-7-4 Single Factor ANOVA
The Stats Files - Dawn Wright Ph.D.
Download
144
Setting up Hypothesis Tests
The Stats Files - Dawn Wright Ph.D.
Download