Quantitative Business Analysis:

Statistics and Operations Research

ISDS 361B - 34

Schedule #21606

Fall 2017

Syllabus

Instructor:Dr. Z. Goldstein

Class time:Tuesday, Thursday,4:00 p.m.– 5:15p.m.

Classroom:SGMH 2101.

Prerequisite:ISDS 361A

Instructor’s Office:SGMH - 4198

Department office:SGMH - 4113

Office hours:T, R, 12:00 p.m.– 12:30p.m., and by appointment

Telephone:(714) 278-2284 – Instructor’s office

(714) 278-2221 – Department office

Website address:

Academic dishonesty - University Policy: Academic dishonesty, when detected, will result in a lower letter grade for the work at hand, and may result in an "F" for the course, plus additional university level disciplinary action. Please refer to the current university catalog for the official university policy on this subject.

Testing Procedures:

  • Course Score = Three midterms’ Exam Average
  • There is no final exam; only three midterms. The third midterm takes place at the date when the final exam is scheduled by the school.

Exam datestime, and location:

Exam 1 – Th., 9/28; class time; Location – classroom
Exam 2 – Th., 11/2; class time; Location – classroom
Exam 3 – T., 12/12, 5 p.m., Location - classroom.

Exams- general information:

Exams are…

  • Closed book
  • Written in bluebooks.
  • Computational; Any notes are allowed.
  • The first two midterms take place in the lab during class time.
  • The third midterm takes place during the examination week. Location will be announced later.
  • Note: the duration of the third midterm is 75 minutes (not 110 minutes, since it is not a final exam).
  • Based, in part at least, on data analysis made with Excel.

Grade Chart:A100-90

B 89-75

C 74-60

D 59-50

FBelow 50

Textbook:
Essentials of Business Analytics 2e, by Camm, Cochran, Fry, Ohlman Anderson,
Sweeney, and Williams.

Software used in the course:Excel - Data Analysis; Excel – Solver;
Excel – specialized templates

General Remarks:

  • Make-up exams policy: N/A
  • Use the course website; go to "Course material" to obtain homework assignments, solutions, and additional supportive material.
  • Power point presentations…
  • For the statistical part of the course can be used or downloaded off the website (go to “Course Material”);
  • For the MS part of the course appear on the text CD.
  • A friendly advice: take your homework assignment very seriously. Although assignments are not graded, passing the course without constantly work on the homework assignments (on lecture by lecture basis) is highly unlikely.


COURSE OUTLINE

Topic Chapter

  1. Simple linear regression (review) 7.2, 7.3

2.Multiple Regression7.4 – 7.6

3.Multiple Regression – Model Building7.7 (Optional)

4.Logistic Regression (Optional)

Exam #1

------

4.Forecasting Models – Stationary models, Trend models, seasonal model 8.1 – 8.4

5.Spreadsheet ModelingInfluence Diagram, Building a model with Excel Functions10.1 – 10.3
(SUM, IF, SUMPRODUCT, VLOOKUP, COUNTIF, SUMIF)

6.Linear programming – Introduction, Graphical presentation, Modeling, Software, 11.1 – 11.3

Sensitivity Analysis11.5

Linear Programming – more applications11.6
Integer programming12

Exam #2

------

7.Inventory Models – Introduction, the EOQ model, The (Q,R) Service level model
Quantity discount, Production lot size, Planned shortage,

Single period inventory model

8.Queueing ModelsThe M/M/1; M/M/k; M/G/19

9. SimulationProcesses with random events14
Generating random numbers with different distributions
Building Simulation models with Excel

10.Decision Analysis Decision Analysis without and with probability,
Expected value of information, Decision tree. 15

Exam #3

Classroom Emergency Preparedness Guide

InformationprovidedbytheUniversityPoliceEmergencyManagementCoordinator

Emergency Preparedness for: ISDS 361B-06, Business Analytics.

On thefirst day of every semester:

•Know the emergencyexitsand evacuationareas foreveryclassroom.

•Devise"buddysystems" sothateveryoneisaccounted for inanevacuation.

•Evaluatethechallengesthat youmightface during an evacuationandspeakwithyour instructor.

•AddtheCSUFEmergencyInformationnumber –877-278-1712–toyour cellphoneto hear recordedinformationregardingcampusconditionsor closure.

•Personal Preparation website

EmergencyCommunication

Campusemergencycommunicationisdone viaa voicemessage,textand/or anemail. Gotoyour Portaltoreview your contactinformation.A guide to update your personal information

Evacuations– Drillsorreal

•Youmaynot know ifthisisadrill or not, sotake everycall toevacuateseriously.

•Takeyour personalbelongingsandimmediatelyleavethebuilding.

•Know wherethe evacuation areaisfor everybuilding.A map of all campus evacuation areas

•Re-enterbuildingsonlywhendirectedbyBuildingMarshals or other campusauthority.

•Leavethecampusonlyifinstructed.

For this class, the closest 2 exitsare: note closest exits

Wewill meet at: note class meeting place

Earthquake

As soonas you feel shaking, DROP, COVER and HOLD ON: Immediately seek shelter (under a deskor table) cover yourheadandhold on.Evacuateif directed,or you feel it is safetodoso.

Fire

•Whenyouseesmoke or fire,immediatelyevacuate thebuilding.

•If notalreadyactivated,pullthefire alarm switchtoalertothers of thesituation.

•Useafire extinguisheronlyif youknowhow touseitandthefireissmall.

Shelter inPlaceorDangerousSituation

•If directed,oryoufeel itisbest todoso, seekshelter inaroom with alock.

•Turnoffthelightsandsilenceallcellphones.

•Hideasbestas possible until the allclear signal hasbeengiven by authorities.

•If possible,moveawayfrom the dangeroussituation asfast asyoucan.

•If you cannotsafelyhide orescape,bepreparedto take action to protectyourself.

•See some helpful videos on sheltering in place

Whenyou need helpImmediately or to report a dangerous situation, CALL 911.

University Policenon-emergency line: (657) 278-2515

Formoreinformation

Ask yourinstructor,orgotoCampus Preparedness website