Employee Name
Ashley, Jane
Davidson Kaye
Ching, Kam Hoong
Collins,Giovanni
Corning,Sandra
Scott, Rex
Corovic,Jose
Lane, Brandon
Wei, Guang
Dixon,Eleonor
Lee,Brandon
Duong,Linda
Bosa, Victor
Drew, Richard
Adams, James
Lunden,Haley
UTran,Diem Thi
Dept
Mkt
A

Exercise 1
You are selling computers to customers. You offer quantity discounts to consumers who buy
more computers. Your pricing policy is based on the following table:
# of PCs
1-5
Price per PC
800
6 or more
755
For example, if a customer buys 9 PCs, sh

Northeast utilities (NEU) is in the business of generating and distributing electricity to the
customers in various North-eastern states in the USA. In order to address various issues related
to customer service, NEU operates a full-fledge call center. To

The sample test below is designed to give you some idea about the final exam. CAUTION:
the final exam will not be limited to this sample test. You will be responsible for everything
we covered in the class throughout the semester: lectures, assignments, p

K321 Practice- Exam 1
Note: The actual exam is composed of three sections: multiple choice, essay (short and long
answers) questions, and true-false questions.
This practice provides you a set of multiple choice questions that I am going to choose from.
E

Chapter 3: Data Understanding, Additional Practice
This file contains datasets to allow you to practice the concepts from Chapter 3: Data Un
Problems contained in this file:
1. Practicing Statistics & Histograms: Test_Scores worksheet
2. Practicing Correl

Parameters
Excel Functions
Normal Distribution
Mean
Standard Deviation
NORMINV(rand(), mean, st.dev)
Discrete Distribution
Individual
Probabilities
VLOOKUP (rand(), table, col #, true)
Values
Discrete Uniform Distribution
MinVal
MaxVal
RANDBETWEEN(min, ma

Microsoft Excel 15.0 Sensitivity Report
Worksheet: [ProdMix_Sensitivity.xlsx]prod mix
Report Created: 6/9/2015 1:50:41 PM
Variable Cells
Cell
$B$16
$C$16
$D$16
$E$16
Name
Frame Production
Frame Production
Frame Production
Frame Production
Final Reduced Ob

Last, First
Smith, Ted
Jones, Bob
Stevens, Jef
Johnson, Ann
Davis, Tifany
Haines, Sam
Orville, Joe
Zaimik, Sara
Larsen, Shelly
Adams, Abby
Bailey, Roald
Caddington, Charles
Everton, Dale
Farris, Fanny
Gibson, Deb
Hadley, Tim
King, Steve
Ladd, Julie
Moore,

Today's Exercise in Data Analysis:
In this file are the total team payrolls for all NFL (National Football League) & MLB (Major League Baseball) tea
for 2011. Also, provided are a listing of teams who have made the playoffs in the last three years, and th

Chapter 3: Data Understanding, Textbook Example Problems
This file contains the example problems as illustrated in Chapter 3: Data Unde
As you work through these example problems, you may wish to check your w
textbook.
Shape
Center
Spread
Histogram
Correl

K303
Technology and Business Analysis
Data Preparation
To err is human, but to really foul things up you need a
computer Paul R. Ehrlich
Chapter 4: Preparing Data for Analysis
Objectives:
Detect data quality issues
Fix data quality issues with robust, r

K303 Spring 2016 Project 4 (70 points)
You are hereby warned:
Canvas is the ONLY accepted environment for project submissions.
Not e-mail (no matter how close to the deadline you send the e-mail).
Not iu.box.com.
Nor any other environment.
If you fail

Product mix models
Production scheduling models
In a product mix model, we consider production quantities for a
number of different goods in one single production period.
In a production scheduling mod
over multiple ordering/produc
For example, we might m

Mean SAT Verbal and Math Scores by State - 1990 through 200
2002
STATE
New York
Connecticut
Massachusetts
New Jersey
New Hampshire
D.C.
Maine
Pennsylvania
Delaware
Georgia
Rhode Island
Virginia
North Carolina
Maryland
Florida
Vermont
Indiana
South Carolin

Introduction
We can use mathematical models to show the relationships of multiple variables in a situation. All models will con
outputs (mathematical formulae or functions), some will also have decision variables where one or more inputs ar
helps to deter

Part A: Boats
A manufacturer of fiberglass boats must produce during the winter in
preparation for the spring selling season. Notice the requirements by
products and the profit per unit. For example, a large sailboat requires 4
units of sailcloth of which

This unit, Data Preparation, will focus on preparing data for analysis. Data can come from
sources and can be prone to errors. These errors can cause problems in many ways. So,
using data in analysis, we need to learn to look for errors and repair them.
W

Chapter 3: Data Understanding, Additional Practice
This file contains datasets to allow you to practice the concepts from Chapter 3: Data Un
Problems contained in this file:
1. Practicing Statistics & Histograms: Test_Scores worksheet
2. Practicing Correl

This unit, Data Preparation, will focus on preparing d
sources and can be prone to errors. These errors ca
using data in analysis, we need to learn to look for e
We had some experience with this in the Jumpstart
complex issues and we'll be focusing on usi

In this exercise you will practice and master concepts from the first two days of class. There is extra emphasis in this exercis
data such that it can be used in analysis or is more legible
Skills:
Flash Fill
The TEXT function
The DATE function
Organizing

\
Parameters
Excel Functions
Normal Distribution
Mean
Standard Deviation
NORMINV(rand(), mean, st.dev)
Discrete Distribution
Individual
Probabilities
VLOOKUP (rand(), table, col #, true)
Values
Discrete Uniform Distribution
MinVal
MaxVal
RANDBETWEEN(min,

Text Date
Day of Week Month
Friday, January 11, 2013
Monday, January 14, 2013
Thursday, January 17, 2013
Sunday, January 20, 2013
Wednesday, January 23, 2013
Saturday, January 26, 2013
Tuesday, January 29, 2013
Friday, February 1, 2013
Monday, February 4,

Chapter 3: Data Understanding, Textbook Example Problems
This file contains the example problems as illustrated in Chapter 3: Data Unde
As you work through these example problems, you may wish to check your w
textbook.
Shape
Center
Spread
Histogram
Correl

K303
Module 1 Exam Review
Approximate point distribution:
Excel Jumpstart 35%
Data Understanding 55%
Chapter Concept Questions 10%
Jumpstart
Separate or restructure data using Flash Fill, Text to
Columns, or functions
Use pivot tables to summarize da