If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board),
It will show all calculations and formulas Automatically
Question:
14-11
The Rockwell Electronics Corporation retains a service crew to r
Quan 2020 Final Exam Practice Problem Set
1. I want to generate a set of random integers uniformly distributed between 3 and 19. What
Excel formula can I use to do this?
2. The table below represents the probability distribution of service times for indus
Microsoft Excel 11.0 Answer Report
Worksheet: [Win Big Gambling Club.xls]3-3
Report Created: 4/26/2009 7:34:50 PM
Target Cell (Max)
Cell
$F$6 Audience
Name
Adjustable Cells
Cell
Name
$B$5 Number of units TV spots
$C$5 Number of units Newspaper ads
$D$5 Nu
Fifth Avenue In
B1 Blen
B2
S
P
All
All
Blen
silk poly d-1 d-2
Number of units
Selling pr # # # #
Labor cos # # # #
Material c # # # #
Profit
# # # #
Constraints:
Yards of s 0.13
Yards of polyest 0.08 0.05 0.03
Yards of cotton
0.05 0.07
Maximum a 1
Maximum
Hong Kong Bank
F
Number of tellers
Cost
Constraints:
9am-10am needs
10am-11am needs
11am-Noon needs
Noon-1pm needs
1pm-2pm needs
2pm-3pm needs
3pm-4pm needs
4pm-5pm needs
Max full time
Part-time limit
FT
tellers
1.0
$90.00
1
1
0.5
0.5
1
1
1
1
1
P1
P2
P3
P
Homework problem 10-14
Distribution of tennis ball sales is normal, with mean weekly sales of 35
cases and a standard distribution of 5 cases. Only whole cases are sold, so
the distribution is discrete (only integer values). Profit per box is $50.00.
a. S
Chapter 9 Homework Solutions
Problem 9-11
Reading the problem carefully, we see that this is a single server system, with a Poisson
arrival distribution, and an exponential service distribution; in other words, this is an M/M/1
queuing system.
From the da
Quan 2020 Chapter 1 homework solutions (all problems)
Problem 1-20
This is "fixed -cost/variable-cost" type of problem, so use screenshot 1-2A (Bill Pritchett's
Shop) as the basis for creating a spreadsheet for this problem (it's as good a place to start
QUAN 2020 Chap 11 Worked homework problems
Problem 11-14
A college student's GPA for each of the past nine semesters is shown in the table below.
Year
Freshman
Sophomore
Junior
Semester
Fall
Winter
Spring
Fall
Winter
Spring
Fall
Winter
Spring
GPA
2.40
2.9
Homework problem 2-16
Objective function and constraints:
Number of units
Objective Function:
Minimize 4X + 7Y
Constraints:
a
b
c
X
24
Y
4
4
7
124
2
4
1
3
2
0
60
104
24
Solution: 4X + 7Y = 80
60
80
24
4X + 7Y = 80
Homework problem 2-22
Objective function
Homework problem 3-1
Decision variables: Number of each type of backpack to build. Specify these as C, P, N,
and L.
Objective function: Maximize total profit. First must calculate profit on each type of
backpack. For example, profit on a canvas pack is $3
QUAN 2020 Chap 11 Worked homework example problems
Problem 11-19
Sales of Hot-Blast heaters have grown during the past five years as shown:
Year
1
2
3
4
5
Sales
480
525
548
593
614
a. Using exponential smoothing constants of 0.35, 0.65, and 0.95,
develop
QUAN 2020
Chap 1 homework assignment
1-20
a)
No, the company should not do it. They will be loosing money if they
decide to.
b)
The current profit is $500 and the expected profit is $(3,500)
1-25
Delta:
$6/unit
Lakes:
Fixed - $23,000
Variable - $3.82
Volu
Problem 1-28
Manual Process:
Mechanized Process:
Known Parameters
Selling price per unit
Fixed Cost
Variable Cost per Unit
Known Parameters
$2.50
$43,400
$1.80
Variables
Number of Units, X
$2.50
$84,600
$1.30
Variables
70000
Results
Total Revenue
Fixed Co
Week 11 Intro
In Sections 13-1 and 13-3, we deal with interval variables; the parameter of interest is the
difference between two means. The best estimator of the difference between two population
means, , is the difference between two sample means, it is
QUAN 5500/5590 Homework Solutions Chapter 3
3.29
For this problem, a simple line chart is fine. You should get something like this:
3.32
The numbers of females and males are both increasing with the number of females increasing faster.
QUAN 5500/5590 Home
QUAN 5500/5590 Homework Solutions Chapter 2 section 2.1
2.2
a. Interval
b. Interval
c. Nominal
d. Ordinal
2.7
a Interval
b Nominal
c. Nominal
d Interval
e Interval
f Ordinal
QUAN 5500/5590 Homework Solutions Chapter 4
4.22
In order to determine variance and standard deviation, we must first calculate the mean, which comes out to -0.3.
Once this has been determined, setting up a table, either on paper or in Excel, is a good wa
QUAN 5500/5590 Homework Solutions Chapter 2 section 2.2
2.11
To create a chart in Excel, select the data set, including labels, and under the Insert options, select the type of chart
to create.
As a result, you should get something like this:
QUAN 5500/55
QUAN 5500/5590 Homework Solutions Chapter 2 section 2.2
2.11
To create a chart in Excel, select the data set, including labels, and under the Insert options, select the type of chart
to create.
As a result, you should get something like this:
QUAN 5500/55
QUAN 5500/5590 Homework Solutions Chapter 2 Section 2.3
2.41
Street crime has decreased while all the other categories have remained constant.
2.43
The first step in solving this problem is reformatting the list from nominal numerical values which corresp
QUAN 5500/5590 Homework Solutions Chapter 3
3.7
a. To create a Stem and Leaf Display, select the data range and open the Data Analysis Plus under the Add Ins tab.
Select the stem and leaf option and click ok.
b. To create a Histogram, go to the Data tab i
QUAN 5500/5590 Homework Solutions Chapter 2 Chapter Review
2.52
Similar to the prior problem, you will need to transpose the nominal and ordinal numerical responses into the
responses they represent. Again, I recommend using the LOOKUP function; you will
QUAN 5500/5590 Homework Solutions Chapter 3
3.92
a. Imports from Mexico
b. Exports to Mexico
c. Balance of Trade (Imports from Mexico exports to Mexico)
The easiest way to create this graph is just make a column with a function that subtracts the exports
QUAN 5500/5590 Homework Solutions Chapter 2 Chapter Review
2.52
Similar to the prior problem, you will need to transpose the nominal and ordinal numerical responses into the
responses they represent. Again, I recommend using the LOOKUP function; you will
QUAN 5500/5590 Homework Solutions Chapter 4
4.3
a. The simplest way to work this problem is to type the values into Excel, and select the Descriptive Statistics option
under Data Analysis, and check the Summary Statistics box. You should get an output tha
QUAN 5500/5590 Homework Solutions Chapter 1
1.3
a. The political choices of the 25,000 registered voters
b. The political choices of the 200 voters interviewed
c. Statistic. A statistic is a descriptive measure of a sample; a parameter would be a descript
QUAN 5500/5590 Solutions Section 13.5
13.93a
H 0 : (p1 p 2 )
=0
H 1 : (p 1 p 2 )
Rejection region:
z z z .05
= 1.645
=
(p1 p 2 )
z
0
= 4.31, p-value = 0. There is enough
(.56 .46 )
1
1
.518 (1 .518 )
1100 800
1
1
p(1 p)
n1 n 2
evidence to infer t
QUAN 5500/5590 Solutions Chapter 13 Chapter Review
13.129
H 0 : (1 2 )
H 1 : ( 1 2 )
=0
<0
Two-tail F test: F = .551, p-value = .0054; use unequal-variances t-test
t = 8.73, p-value = 0. There is enough evidence to conclude that men and women who suffer
h