![Online Business Analytics](/img/default-banner.jpg)
- 102
- 160 773
Online Business Analytics
United States
เข้าร่วมเมื่อ 28 มี.ค. 2019
Hello, World! Welcome to my channel. This is Xiaohui Chang (pronounced as Shao-Way Chung). I have a Ph.D. in Statistics from the University of Chicago and am currently a tenured professor at Oregon State University. My channel is still at its early stage and most of the videos were created for my students taking classes online or remotely.
I have been teaching business analytics and statistics classes at the university level since 2006. Besides classroom teaching, my academic research is mostly on the application of advanced statistical or machine learning methods to important problems that arose in business, finance, or the environment.
If you're interested in learning more about me, check out these pages:
business.oregonstate.edu/users/xiaohui-chang
www.researchgate.net/profile/Xiaohui_Chang/research
www.linkedin.com/in/xhchang/
Cheers!
I have been teaching business analytics and statistics classes at the university level since 2006. Besides classroom teaching, my academic research is mostly on the application of advanced statistical or machine learning methods to important problems that arose in business, finance, or the environment.
If you're interested in learning more about me, check out these pages:
business.oregonstate.edu/users/xiaohui-chang
www.researchgate.net/profile/Xiaohui_Chang/research
www.linkedin.com/in/xhchang/
Cheers!
How to Change the Baseline Level in Linear Regression using XLSTAT
#statistics #analytics #businessanalyticscourse #businessanalytics #linearregression #regression #forecasting #binaryvariables #xlstat #excel
In this video, we will discuss how to change the baseline level (aka the reference level) in linear regression using XLSTAT. The dataset used in this video can be downloaded here: docs.google.com/spreadsheets/d/1Vd35ezgCvToHqalCrgqQqTdKyMMUueAL/edit?usp=sharing&ouid=104829375952669411079&rtpof=true&sd=true
👩🏫 Lecture Videos
➡ Linear Regression with Categorical Variables: th-cam.com/video/EJMMA5dzsXQ/w-d-xo.html
➡ For All Linear Regression videos: th-cam.com/play/PLVfkLzKIXfrGgGRi5lZeZSsOSiwaZjafd.html
➡ For other Business Statistics videos: th-cam.com/play/PLVfkLzKIXfrFjZMKNGPswQMXCZmScnRb6.html
➡ Business Simulation (using @Risk): th-cam.com/play/PLVfkLzKIXfrFOcr-pw8DD-S4H7idNT2Rb.html
➡ Decision Analysis (using PrecisionTree): th-cam.com/play/PLVfkLzKIXfrFXJqVsFgryneIn8eTGDFc3.html
➡ Linear Programming (using Lingo): th-cam.com/play/PLVfkLzKIXfrHd2P9TXn-IVbgROhCWLIDz.html
💻 XLSTAT Walkthrough Videos
➡ Simple Linear Regression using XLSTAT: th-cam.com/video/DlLeVNv9zLU/w-d-xo.html
➡ All my XLSTAT tutorials: th-cam.com/play/PLVfkLzKIXfrENQu8c5QrsjcuS8JUuaww4.html
In this video, we will discuss how to change the baseline level (aka the reference level) in linear regression using XLSTAT. The dataset used in this video can be downloaded here: docs.google.com/spreadsheets/d/1Vd35ezgCvToHqalCrgqQqTdKyMMUueAL/edit?usp=sharing&ouid=104829375952669411079&rtpof=true&sd=true
👩🏫 Lecture Videos
➡ Linear Regression with Categorical Variables: th-cam.com/video/EJMMA5dzsXQ/w-d-xo.html
➡ For All Linear Regression videos: th-cam.com/play/PLVfkLzKIXfrGgGRi5lZeZSsOSiwaZjafd.html
➡ For other Business Statistics videos: th-cam.com/play/PLVfkLzKIXfrFjZMKNGPswQMXCZmScnRb6.html
➡ Business Simulation (using @Risk): th-cam.com/play/PLVfkLzKIXfrFOcr-pw8DD-S4H7idNT2Rb.html
➡ Decision Analysis (using PrecisionTree): th-cam.com/play/PLVfkLzKIXfrFXJqVsFgryneIn8eTGDFc3.html
➡ Linear Programming (using Lingo): th-cam.com/play/PLVfkLzKIXfrHd2P9TXn-IVbgROhCWLIDz.html
💻 XLSTAT Walkthrough Videos
➡ Simple Linear Regression using XLSTAT: th-cam.com/video/DlLeVNv9zLU/w-d-xo.html
➡ All my XLSTAT tutorials: th-cam.com/play/PLVfkLzKIXfrENQu8c5QrsjcuS8JUuaww4.html
มุมมอง: 645
วีดีโอ
Art Gallery Example using Linear Programming
มุมมอง 353ปีที่แล้ว
#statistics #analytics #businessanalyticscourse #businessanalytics #simulation #linearprogramming #decisionmaking Here is an interesting application of linear programming where the decision variables are integers, more precisely binary. The software used is LINGO. 💻 Other Linear Programming Videos (mostly examples) ➡ Introduction to Linear Programming: th-cam.com/video/tDn4j5mPWdo/w-d-xo.html ➡...
Shortest Path Example using Linear Programming
มุมมอง 15Kปีที่แล้ว
#statistics #analytics #businessanalyticscourse #businessanalytics #simulation #linearprogramming #decisionmaking This video demonstrates how linear programming, more specifically, integer linear programming can be used for routing types of problems. The software used is LINGO. 💻 Other Linear Programming Videos (mostly examples) ➡ Introduction to Linear Programming: th-cam.com/video/tDn4j5mPWdo...
Integer Programming Introduction
มุมมอง 503ปีที่แล้ว
#statisticsvideolectures #analytics #businessanalyticscourse #businessanalytics #simulation #linearprogramming #decisionmaking This video introduces a type of linear programming problem where the decision variables can’t be any numbers, but only integers. In the first part of the video, we focus on integer decision variables. In the second part, we consider a special type of integer decision va...
Portfolio Selection Example using Linear Programming
มุมมอง 2.6Kปีที่แล้ว
#statistics #analytics #businessanalyticscourse #businessanalytics #simulation #linearprogramming #decisionmaking This video demonstrates how to set up and solve a portfolio selection example using linear programming. This type of example is common in finance. The software used is LINGO. 💻 Other Linear Programming Videos (mostly examples) ➡ Introduction to Linear Programming: th-cam.com/video/t...
Media Selection and Blending Examples using Linear Programming
มุมมอง 1.1Kปีที่แล้ว
#statistics #analytics #businessanalyticscourse #businessanalytics #simulation #linearprogramming #decisionmaking This video demonstrates two examples of linear programming applications. One of them comes from the Marketing application andthe other one from the Operations Management application. The software used is LINGO. 💻 Other Linear Programming Videos (mostly examples) ➡ Introduction to Li...
Logistics Example using Linear Programming
มุมมอง 1.6Kปีที่แล้ว
#statistics #analytics #businessanalyticscourse #businessanalytics #simulation #linearprogramming #decisionmaking This video demonstrates how to set up and solve a logistics examples using linear programming. This type of example is common in Operation Management, under Transportation Planning. The software used is LINGO. 💻 Other Linear Programming Videos (mostly examples) ➡ Introduction to Lin...
Linear Programming Introduction
มุมมอง 1.2Kปีที่แล้ว
#statistics #analytics #businessanalyticscourse #businessanalytics #simulation #linearprogramming #decisionmaking This video introduces decision-making under certainty through linear programming. Using a motivating example, we describe the four steps in linear programming. The software used is LINGO that is demonstrated in both PC and Mac. 💻 Other Linear Programming Videos (mostly examples) ➡ I...
Walkthrough Multistage Decision Problem using PrecisionTree
มุมมอง 654ปีที่แล้ว
#analytics #simulation #riskanalysis #decisiontree #decisionmaking #decisionanalysis This video demonstrates how to set up a multistage decision problem using PrecisionTree. See another video on Multistage Decision Problems here: th-cam.com/video/_EFlyFMv2xM/w-d-xo.html 💻 Decision Analysis videos ➡ Intro to Decision Analysis: th-cam.com/video/LaLfnMTHbtY/w-d-xo.html ➡ Single Stage Decision Rule...
Walkthrough Expected Monetary Value EMV Calculation in Decision Analysis
มุมมอง 10Kปีที่แล้ว
#analytics #simulation #riskanalysis #decisiontree #decisionmaking #decisionanalysis This video covers two exercises. Exercise (1): we calculate EMV and discuss how much we should pay for the "perfect" information. Exercise (2): How to read a complex multistage decision tree. 💻 Decision Analysis videos ➡ Intro to Decision Analysis: th-cam.com/video/LaLfnMTHbtY/w-d-xo.html ➡ Single Stage Decisio...
Regression with Categorical Independent Variables
มุมมอง 688ปีที่แล้ว
#statistics #analytics #businessanalyticscourse #businessanalytics #linearregression #regression #forecasting #timeseries #binaryvariables #dummyvariable #xlstat #excel We discuss a special type of linear regression where the independent variable X is a categorical variable. We also discuss how we may use linear regression for forecasting. XLSTAT is demonstrated in this video. Two datasets used...
Understanding EVSI and EVPI in Decision Analysis
มุมมอง 2.2Kปีที่แล้ว
#analytics #simulation #riskanalysis #decisiontree #decisionmaking #decisionanalysis #expectedvalue This video introduces EVSI (Expected Value of Sample Information) and EVPI (Expected Value of Perfect Information) which are important concepts in decision analysis. 💻 Decision Analysis videos ➡ Intro to Decision Analysis: th-cam.com/video/LaLfnMTHbtY/w-d-xo.html ➡ Single Stage Decision Rules: th...
Multistage Decision Problems in Decision Analysis
มุมมอง 1.1Kปีที่แล้ว
#analytics #simulation #riskanalysis #decisiontree #decisionmaking #decisionanalysis This video considers the multistage decision problems. See the walkthrough video on how to set up a multistage decision problem using PrecisonTree here: th-cam.com/video/HoF0imQJd5Q/w-d-xo.html 💻 Decision Analysis videos ➡ Intro to Decision Analysis: th-cam.com/video/LaLfnMTHbtY/w-d-xo.html ➡ Single Stage Decis...
Single Stage Decision Rules in Decision Analysis
มุมมอง 605ปีที่แล้ว
#analytics #simulation #riskanalysis #decisiontree #decisionmaking #decisionanalysis This video considers the simplest decision analysis where only one decision is needed. Rules including maximax, maximin, minimax, expected monetary value EMV, and expected opportunity loss EOL, are introduced. See the walkthrough video on EMV here: th-cam.com/video/ZVjMHSFHsfc/w-d-xo.html 💻 Decision Analysis vi...
Using PrecisionTree for Decision Analysis
มุมมอง 1.3Kปีที่แล้ว
#analytics #simulation #riskanalysis #decisiontree #decisionmaking #decisionanalysis This video introduces Palisade's PrecisionTree, a software program that is used to construct decision trees and perform decision analysis. Palisade's videos on PrecisionTree can be found here: Step 1: th-cam.com/video/RA1orvEy14o/w-d-xo.html Step 2: th-cam.com/video/MettNcrWKZo/w-d-xo.html Step 3: th-cam.com/vi...
Walkthrough Monte Carlo Simulation using @Risk
มุมมอง 281ปีที่แล้ว
Walkthrough Monte Carlo Simulation using @Risk
Generate Numbers using @Risk (Monte Carlo Business Simulation)
มุมมอง 301ปีที่แล้ว
Generate Numbers using @Risk (Monte Carlo Business Simulation)
Stock Portfolio Example in Business Monte Carlo Simulation @Risk
มุมมอง 408ปีที่แล้ว
Stock Portfolio Example in Business Monte Carlo Simulation @Risk
Software Development Example in Business Monte Carlo Simulation @Risk
มุมมอง 583ปีที่แล้ว
Software Development Example in Business Monte Carlo Simulation @Risk
Donation Example in Business Monte Carlo Simulation @Risk
มุมมอง 337ปีที่แล้ว
Donation Example in Business Monte Carlo Simulation @Risk
Business Monte Carlo Simulation Introduction @Risk
มุมมอง 572ปีที่แล้ว
Business Monte Carlo Simulation Introduction @Risk
Simple Linear Regression Model Diagnostics
มุมมอง 484ปีที่แล้ว
Simple Linear Regression Model Diagnostics
Type I and Type II Errors in Hypothesis Testing
มุมมอง 154ปีที่แล้ว
Type I and Type II Errors in Hypothesis Testing
Hello again,today I noticed on my dashboard course an announcement 80% completed.What does this mean?Thank you in advance miss
I am not sure about this. It could mean you've completed 80% of the coursework, but I'm not really sure. Could you send a screenshot to your instructor?
@@OnlineBusinessAnalytics Good morning.Unfortunately I cannot send anything to my instructor,that test was a trial of a business recruitment .I think that this could mean that there is an additional part of the test(speaking)and till now,it is not available.According to the progress,they will let me complete the test.Does this make any sense to you miss?
Hello I took an exam yesterday(proctorio chrome) and suddenly a new tab opened (any desk).Due the fact I was stressed,I chose accept.Then the screen became black as well as a message was at the top said that(this option will exclude you out of the test)while counting backwards,30 sec.)Then I closed the new tab and continued the test till the end where I submitted successfully.Does this mean anything bad for me?Please help me because Iam in a mess
I don't think anything bad will happen if you manage to complete the test. The worst that could happen is that your video might be flagged, and the instructor could review it later to check for any suspicious activity-which you didn’t engage in. So, no need to worry!
@@OnlineBusinessAnalytics Thank a ton God bless you
Hello again,today I noticed on my dashboard course an announcement 80% completed.What does this mean?Thank you in advance miss
Thank you for the example - it is great and explains the problem well in a general way! For this specific problem, there's a simple way of viewing it as "For each store, how much money will I save by using Warehouse B instead of Warehouse A?" Store 1 saves $2 per item, Store 2 saves $4 per item, Store 3 saves $3 per item. So to save the most money, use Warehouse B where it saves us the most money: first Store 2, then Store 3, then Store 1. It so happens you can fully satisfy Stores 2 and 3 with Warehouse B and still have 40 units left in Warehouse B for Store 1. This shortcut works for this specific problem but may not in the general case. Thought I'd share as it helped me understand the solution!
Yes, you're absolutely correct. I appreciate how you solved this specific problem, and thank you for sharing your thought process with us!
Would you mind sharing what tool you used to draw on your slides/document? That will be very helpful. Thanks you!
No problem. I first saved my slides as PDF documents and then imported them to Goodnotes on my iPad. I also used an Apple Pencil for note-taking during the class. Hope this helps.
Great explanation!
SO this proctorio extention must be turned on when you do any online exam, correct? SO this extention can be used with any online exam and what you are showing us is an exam youve done?
Where can I get the latest crack version of XLSTAT? Can anyone send me the link ??
The XLSTAT free version, called XLSTAT-Free, actually has ANOVA in it.
12000/2=6000 is not 600. Thank u for the video it really help
You don't need XLstat to do this lol! Excel already has linera regression.
Thanks a lot. Great explanation.
Glad that you found the video helpful!
This was very helpful! Thank you so much!
You're welcome. Glad to hear that you found it helpful.
Can i ask u how to conduct anova with one independent variable and many dependent variables? thanks
I am not aware if this is feasible in XLSTAT.
I learned something today. Thank you! 🙂
Glad that you found it useful!
Thanks for the explanation..
Thanks for the explanation tmrw I got an exam and this is gonna be really helpful ❤❤
you're the best!
I wish you hadn't hardcoded it. I was looking for your formulation.
Oh my gosh! Thank you for this! I have a exam tomorrow using proctorio and I am so new to this program!
@@OnlineBusinessAnalyticsmam I want to clear fiitzee scholarship mam on 19 may have my exam and iam so worried about it 😢
@@spiritraghav3919 Good luck!!!
Hello I took an exam yesterday(proctorio chrome) and suddenly a new tab opened (any desk).Due the fact I was stressed,I chose accept.Then the screen became black as well as a message was at the top said that(this option will exclude you out of the test)while counting backwards,30 sec.)Then I closed the new tab and continued the test till the end where I submitted successfully.Does this mean anything bad for me?Please help me because Iam in a mess
Very clear and straight forward, thank you!!
Thank you for the feedback. I am very glad to hear that you find the video helpful.
Thank you, this helped a lot!
Thank you! Glad to hear this.
Hello, for my admissions test I had to install proctorio a day before, and they asked me for permission to see my camera, my screen, and my microphone. However, when I connected to take the official exam, they didn't ask me for permission, I couldn't see the small square with your camera at the corner, and the green light next to my camera never appeared. I just took the test like a normal google forms, and I was able to put music and open other tabs during the test. They never asked me to stop anything at any moment, and when I finished, they nothing happened to let me know if the supervision was over (before, nothing notified me if the supervision started either). I don't know if I was supervised at all, how can I know? Could I have been automatically supervised without asking for my permissions, without the light of my camera turning on, and without the notification of "sharing screen"? I don't know if they were supervising me or not, so please if you could help me understand, I would really appreciate it. Thank you so much.
From my experience, students will be asked for permission every time they use Proctorio. And the screen that was monitored will have a red border. From your description, it sounds like you were not supervised. Sometimes the instructor may not have Proctorio set up properly. It definitely has happened to me a few times. I only fixed the issue after several students emailed me. Could you message the test administrator? They will be able to look up your recordings if Proctorio was used properly during the test. Hope this helps and good luck!
Well explained, Thank you!!
Glad that you found this video helpful!
Cheers for this example! Helps my understanding
Is websites visited in precheck meaning web traffic?
Web traffic means any websites that you have visited during the test will be recorded and shared with the test administers. Hope this helps.
great video
Thanks for the explanation
thanks for this video I got the overview of linear programming in optimization
您在哪儿教
I'm at Oregon State University.
@@OnlineBusinessAnalytics I see, am being a foreigner studying mba in Tianjin University. Are you Chinese or Taiwanese ?
what a beautiful voice you have, I love it
Correction: Time Stamp 5:30, 100-16-16 = 68, not 64. The Empirical Rule indicates that 68% of the observations fall within +/- 1 standard deviation of the mean. Everything else in the video is accurate, except 64%. I misspoke here. The text solution posted in Canvas is also accurate. My apologies!
Thank you!
Glad that you found this video helpful. 😊
Excellent video. One question, how the risk measure per dollar are determined? Or which factors are considered? Thank you for teaching.
Correction for the XLSTAT screenshot at 15:54 (or Slide 30). When we use XLSTAT to do predictions, under the Prediction tab, please select cells from B15 to B18 for Quantitative, not Column J. This means that we should select 13, 14, 15, and 16 for Time Index. Please leave a comment if this is not clear.
Correction: Time Stamp 3:58, to find B, the p-value for a two-tailed test, we should use 2*(1-T.DIST(11.026, 18, TRUE)). To find D, we use 2*T.DIST(-7.96, 18, TRUE). Both p-values are close to 0. This is because the area to the left of -7.96, a negative number, is indeed one of the two corners we need to find the p-value, so we can just multiply the corner by 2 to get the p-value. However, the area to the left of 11.026, which is a positive number, is not one of the two corners; and we use 1 - T.DIST to find one corner first and then multiply it by 2. I'd recommend drawing a bell curve and labeling where the test statistic is to visualize the two corners. My apologies!
讲解的颇透彻,谢谢分享!
Hi! How can I obtain the standard deviation?
Is it for general standard deviation or related to ANOVA? For general sample standard deviation in Excel, please use Excel function "stdev.s" There is another similar Excel function, "stdev.p", which calculates the population standard deviation. Hope this helps.
Wouldn't the denominator be 12?
Professor, could you provide a link to the excel worksheet you are working on?
Sorry for my delayed response. I just uploaded this dataset here: docs.google.com/spreadsheets/d/1mAECdBK345ptXW2_T7MwC4Vq5_8MLHwa/edit#gid=1901898382
@@OnlineBusinessAnalytics thanks
Thank you so much this helped me alot i would love for you to help me sometime with my spreadsheet
can they know when you are mirroring to another screen?
One of the exam settings prevents multiple screens, which means a student can't connect to two monitors when this setting is selected. If you'd like to view two applications or two documents side by side, you could still do that using one screen unless the instructor select "force fullscreen", which is another setting in Proctorio. Hope this helps.
Is the microphone turned on during the exam?
Mostly yes. This depends on the Proctorio settings selected by the teacher.
Thank you for walking me through this. I've never had to use it and I have an exam coming up.
Glad to hear that you find it helpful.
Fuck this. It’s spyware and it kicked me off my exam immediately, this should not be legal.
informative
Before the test begins, does Procturio ask you to show your surroundings to the camera as well?
In every time I clicked “except” the last choice to begin the exam they take me back to the first page and make me repeat all the steps
These guys will help you with proctored exams th-cam.com/video/hrY5UcxI1Rs/w-d-xo.html .They do help with proctored exams and I've used them several times. Thank me later
Very helpful but this is spyware
thank you! this helped alot since I'm taking my first proctored exam tomorrow. :)
You're welcome. Glad that you found this video helpful and best of luck in your exam tomorrow!!! Remember that you should be able to chat with Proctorio's customer support if you run into any technical issues. Sometimes restarting Chrome and/or your computer may help too. :)