DSC 2008 Business AnalyticsData and Decisions Tutorial 2 (Assignment 1) (2012-08)
This assignment is to be completed individually, and carries 10% of the final grade.
You may discuss with anyone, including lecturer and tutors, but cannot look at any other

Section A (45 marks)
Circle the most appropriate answer to the following questions:
The HR group for a company collected data detailing the educational level of the companys
employees. They found that 170 have no degree (None), 38 have a polytechnic diplo

DSC 2008 Business AnalyticsData and Decisions Tutorial 1 (Answers)
This first tutorial is longer than usual, because it covers 2 weeks of lecture.
Since there are frequently no definitive answers to some parts of tutorial questions, please only take
these

DSC 2008 Business AnalyticsData and Decisions Tutorial 3 (answers)
This covers some topics missed by Assignment 1 last week. Q2 & 6 for tutorial discussions; answers
for rest already included.
(1) 4e: P 505, 5e: P 451, 6e: P406, problem 52, using Tut3-Q1-

DSC 2008 Business AnalyticsData and Decisions Tutorial 1 (Answers)
Only Q1 & 6 are for tutorial discussions; answers for the rest are already provided.
(1) The data below contains family incomes (in millions of wons) for a set of 50 families; sampled in
1

DSC 2008 Business AnalyticsData and Decisions Tutorial 4 (answers)
Q1 & Q5 are for tutorial discussions; answers for the rest are already included. Again, BACT offers
useful consulting before each tutorial class.
(1) Price of Beef. How is the price of bee

ARMA model and Unit Root
Chen Ying
Department of Statistics & Applied Probability
Faculty of Science
Department of Statistics & Applied Probability
ARMA models
A model may have both autoregressive and moving average
components. Autoregressive Moving Avera

Peters Pizza Problem
DSC2008
LECTURE 3 RECAP/SUMMARY
Peter's Pizza Problem
OLD
NEW
Peter's Pizza Problem
100 randomly selected
customers
Includes old style and new style
pizza
Rate the difference
-10 (old)
0 (neutral)
+10 (new)
Peter's Pizza Problem
N

MR Methods
&
Smoothing Methods
Authored by Chen Ying
Used by Li Jialiang
Department of Statistics & Applied Probability
Faculty of Science
Department of Statistics & Applied Probability
1.Collect relevant time series data,
either from a survey, from compa

Introduction to Time Series
Authored by Chen Ying
Used by Li Jialiang
Department of Statistics & Applied Probability
Faculty of Science
Department of Statistics & Applied Probability
Big Data
Lots of data is being collected and warehoused
Web data, e-comm

DSC2008 Business Analytics Data and Decisions
SEM 2, AY2014/2015
Tutorial 8 - Answer
Question 1.
Unemployment rate is calculated as a percentage by dividing the number of
unemployed individuals by all individuals currently in the labor force. During
perio

Bicycle Computer (CatEye)
Using only data for 26" tires:
hand-copied
26 x 7/8 1920
26 x 1(59) 1913
26 x 1(65) 1952
26 x 1.25 1953
26 x 1-1/8 1970
26 x 1-3/8 2068
26 x 1-1/2 2100
26 x 1.40 2005
26 x 1.50 2010
26 x 1.75 2023
26 x 1.95 2050
26 x 2.00 2055
26

City
Albany-Schenectady-Troy, NY
Albuquerque, NM
Atlanta, GA
Austin, TX
Bakersfield, CA
Baltimore, MD
Beaumont, TX
Boston, MA
Boulder, CO
Brownsville, TX
Buffalo-Niagara Falls, NY
Charlotte, NC
Chicago, IL-Northwestern, IN
Cincinnati, OH-KY
Cleveland, OH

Sample Salesperson Reports Workbook
How to Use This Workbook
How to use this workbook
This workbook contains several examples of PivotTable reports, including the source data from which the reports were made. You can follow the
steps in the article 25 Eas

University Guide 2014
The Times and Sunday Times University League Tables
University
University of Cambridge
University of Oxford
London School of Economics and Political Science
University of St Andrews
Imperial College London
Durham University
Universit

Fortune Top 100 companies to work for (2011)
Rank Company
1 SAS
2 Boston Consulting Group
3 Wegmans Food Markets
4 Google
5 NetApp
6 Zappos.com
7 Camden Property Trust
8 Nugget Market
9 Recreational Equipment (REI)
10 DreamWorks Animation SKG
11 Edward Jo

DSC2008 Business Analytics Data and Decisions
SEM 2, AY2014/2015
Tutorial 6
Review the Excel output of the Whole Food Sales analysis. Familiar with Excel
Regression analysis and interpret the output.
1. R2, adjusted R2
2. MR coefficients interpretation
3.

DSC2008 Business Analytics Data and Decisions
SEM 2, AY2014/2015
Tutorial 10 - Answer
Question 1.
The car data set T10_car.xlsx is from Chambers, Cleveland, Kleiner and Tukey
(1983). It consists of 13 variables measured for 74 car types. The variables are

DSC2008 Business Analytics Data and Decisions
SEM 2, AY2014/2015
Tutorial 7
Question 1.
According to a Morgan Stanley report in March 2008, the annual demand for
hybrid cars in the US is expected to reach 1.2 million in 2015; this estimate
also included 2

ARMA model and Unit Root
Authored by Chen Ying
Used by Li Jialiang
Department of Statistics & Applied Probability
Faculty of Science
Department of Statistics & Applied Probability
ARMA(1,1) model
ACF and PACF of ARMA(1,1) models
the
For
ARMA(1,1),
both th

AutoRegressive (AR) Models
Authored by Chen Ying
Used by Li Jialiang
Department of Statistics & Applied Probability
Faculty of Science
Department of Statistics & Applied Probability
Review: Smoothing methods
Data: STI daily close prices from 1987/12/28 to

DSC2008 BUSINESS ANALYTICS DATA & DECISIONS
(Semester 2 AY2011/2012)
Section A (40 marks)
It is possible to get full marks on a question without answering exactly as outlined here.
Circle the most appropriate answer to the following questions:
1. Which fo

DSC2008
NATIONAL UNIVERSITY OF SINGAPORE
DSC2008 BUSINESS ANALYTICS DATA & DECISIONS
(Semester 1 AY2012/2013)
Time Allowed: 2 Hours
INSTRUCTIONS TO CANDIDATES
1. This examination paper comprises Fifteen (15) printed pages.
2. Answer ALL questions. Write l