Develop a model to predict the assessed value of houses (in $thousands), using the size of the houses (in
thousands of square feet) and/or the age of the houses (in years) from the excel sheet provided.
1.) Develop a simple linear regression model to pred
Develop a model to predict the assessed value of houses (in $thousands), using the size of the houses (in
thousands of square feet) and/or the age of the houses (in years) from the excel sheet provided.
1.) Develop a simple linear regression model to pred
MBA662 HW6
Dr. Nuo Xu
1) A Type II error is committed when
A) you reject a null hypothesis that is true.
B) you don't reject a null hypothesis that is true.
C) you reject a null hypothesis that is false.
D) you don't reject a null hypothesis that is false
MBA662 Test 1 Name 50/117011
Dr. Nuo Xu
Part | Multiple Choices (24%)
1. Which of the following constraints does not contribute to defining the feasible region?
in.) #2
a) X1 + X2 S 10 LO) - I [a Fjt
@ x1 x2 3 10 Rhee; / L?)
c) X1+3X2520 (obit-"en/
f,
2
MBA662 Sample Test 1
Dr. Nuo Xu
Name_
Part I Multiple Choices (24%)
1. Which of the following constraints does not contribute to defining the feasible region?
a)
b)
c)
d)
X1 + X2 10
X1 X2 10
X1 + 3X2 20
X1 , X2 0
2. The feasible region does not include:
a
Probability Distribution II
Dr. Nuo Xu
1. Probability and Distribution for Continuous Variables
2. How to use Function to describe them
3. Galton Machine
1. Probability Distribution for a continuous variable
Discrete vs. Continuous
Points vs. intervals
Co
MBA662 M5P1 Solutions
Dr. Nuo Xu
1.
B7=IF(RAND()>$C$2,0,1)
Rand() returns a random number from a continuous uniform distribution with the uniform (i.e., same)
density value between (0, 1).
IF(logical_test, value_if_true, value_if_false); therefore, if the
MBA662 HW5
Dr. Nuo Xu
Simulation for Taks
Taks Home Furnishing sales 18 cubic-foot Whirlpool refrigerators, which come in three colors, white,
almond and harvest gold. Each day, the store expects between 0 and 4 customers interested in buying a
refrigerat
MBA662 HW4
Dr. Nuo Xu
1.
Let us define a random variable Y as the sum of number of dots from tossing two fair dice. For example,
if we roll a 2 and a 3, then Y=5.
a) Tabulate the probability distribution and cumulative distribution of Y.
b) Graph them.
c)
Probability Distribution I
Dr. Nuo Xu
Statistics
The study of modeling uncertainty mathematically and its applications;
The conception of uncertainty is inspired by our daily observations of natural phenomena.
There seem to be two components to these unce
MBA662 M4P1
Dr. Nuo Xu
Let us use the variable X to represent number of dots from tossing a fair die.
a. Tabulate the probability and cumulative distribution of X
b. Calculate P(X<=3), P(X>=4), P(X>4), P(X=1.5), P(X<=1.5), P(X=7) and P(X<=7)
c. Calculate
MBA662 M4P1
Dr. Nuo Xu
Let us use the variable X to represent number of dots from tossing a fair die.
a. Tabulate the probability and cumulative distribution of X
b. Calculate P(X<=3), P(X>=4), P(X>4), P(X=1.5), P(X<=1.5), P(X=7) and P(X<=7)
c. Calculate
_ _ _ . _A, ., g. /._,_-_-._.H_ .-_._n_.n;_.
-=n=-n-._n-_ah_.-=a_=.-_ _.
a
a
if
-I
l
]
Ballston.xls
Ballston-net.xls
4.4 Assignment Networks 209
As we see from the right side of this screen, the optimal solution is to follow
the shipping pattern below t
@156 n .xls
Cariton-net.x|s
4.2 Transportation Networks 191
TREES/SPANNING TREES
If the arcs of a series of connected nodes do not contain any cycles, as in Figure 4.54,
the resulting gure is called a tree. A tree that connects all the nodes in a ne
MBA662 HW3 Solutions
Dr. Nuo Xu
1. & 2.
The following three pages and the excel file 1: Jones Investment.
3.
The excel file 2: Jones Investment reformulated
*adapted from Lawrence and Pasternack
MBA662 HW3
Dr. Nuo Xu
Carefully read the case in the next page and complete the following tasks.
1. Assuming that Frank will invest all $100,000, develop a linear programming model to determine the
amount to be placed in each investment so that the total
MBA662 M3P1
Dr. Nuo Xu
*adapted from Lawrence and Pasternack, Problem Chapter 4.30.
PrimeBeef.com supplies four major restaurant chains (Ponderosa, Ranchero, Bar H, and Tex Mex) in the
Oklahoma City area with top grade steaks prepared and stored in three
MBA662 M3P2
Dr. Nuo Xu
*adapted from Lawrence and Pasternack, Problem Chapter 4.2.
The city of Beckley, West Virginia, has solicited bids from interested construction firms for five projects it
wishes to complete during this fiscal year. Six firms have su
MBA662 M3P1 Solution
Dr. Nuo Xu
First, divide pounds by 400 to change the unit to truckloads;
Xij = truckloads of beef shipped from warehouse i to restaurant j
Where: i = 1 (north), 2 (south), 3 (west)
and j = 1 (pon), 2 (ran), 3 (bar), 4(tex)
MINIMIZE
90
FIGURE 2.1 1
Shadow Price: Calculated by
the Difference in Objective
Function Values When the
Right-Hand Side ofa
Constraint ls Increased by1
/2.4 The Role of Sensitivity Analysis of the Optimal Solution 67
X2 "Shadow Pack;
500
2x1+1x2=1ooo
'. Rex,+1x2=1o
58 CHAPTER 2 Linear and Integer Programming Models
Adding these two equations gives us 3X1 = 1350, or X1 = 450. Substituting X1 =
450 into the second equation gives 450 2 = 350, or X2 = 100. Thus, this ex
treme point is X1 = 450, X2 = 100. Similarly, the
2.4 The Role of Sensitivity Analysis of the Optimal Solution 53
Having more than one optimal solution allows the decision maker to consider sec
ondary criteria in selecting an optimal strategy. For example, one optimal solution
may have more of the decisi
MBA662 HW2 Solutions
Dr. Nuo Xu
a)
Refer to the graph in the next page.
The wood equation 9X1 + 3X2 = 2250 passes (250,0) and (0,750).
The cushions equation 1X2=500 is a horizontal line at the height of 500.
The equation of lower bound of chair/table rati
MBA662 HW1 Solutions
Dr. Nuo Xu
a.
D.V.
X1 = Number of tables produced weekly
Profit = $300 - 9($10) - $45 = $165
Where $300 is the price each table
Each table uses 9 linear feet of mahogany, each foot costing $10
$45 other hardware cost associated to a t
MBA662 HW2
Dr. Nuo Xu
Continuing from HW1 on A&B Woodworks and given the correct formulation in HW1 solution.
a) Use the method of line of same profit to find the optimal solution graphically.
b) Use Excel Solver to produce the optimal solution and sensit
50 CHAPTER 2 Linear and Integer Programming Models
2.2 A Linear Programming Model
W
In this section we illustrate the procedure used to construct linear programming
models by considering the situation faced by Galaxy Industries. Although this pro
toty
2.3 A Graphical Analysis of Linear Programming 55
2.3 A Graphical Analysis
El' E .
Exactly what production combinations of Space Rays and Zappers are possible for
Galaxy Industries? And, of these possible production values, which maximizes the
objective f
A Quick Recap of Analytic Geometry
MBA662 Dr. Nuo Xu
1. A few words on the history of Analytic Geometry
Analytic Geometry links algebra to geometry, the invention of which is credited to Rene
Descartes.
The epiphany of Descartes.
It was 10 November 1619 D
1.3 Mathematical Modeling 7
HI 'IEIII'
Many problems requiring managerial decisions lend themselves to quantitative or
management science analyses. Throughout this text numerous decision problems,
each with specic objectives and restrictions, are presen