Using Data Tables

1
Using Data Tables

• Henry C. Co
• Technology and Operations Management,
• California Polytechnic and State University

2
Known Demand

• Based on
• G.D.Eppen, F.J.Gould, C.P.Schmidt, Jeffrey H.
  Moore, and Larry R. Weatherford, Introductory
  Management Science Decision Modeling with
  Spreadsheets, 5th Edition, Prentice Hall, ISBN
  0-13-907536-4, pages 518-532.

3
Note F20NPV(H4,G18J18)F18
4
Demand with Discrete Distribution
5
G10VLOOKUP(RAND(),B4C10,2,1) copy and
paste onto H10J10
6
Data Tables (Sampling)

• Generating 100 Trials using Data Table

7
B2 Simulated NPV value from the Random Demand
Worksheet.
Select the range A2B101
8
RAND() is volatile. Convert the formulas to
values by copying and pasting the range A2B101,
as shown
Click the Data menu and select Table.
In the Table Dialog box, enter C1 as shown.
9
Data Analysis(Descriptive Statistics)
10
(No Transcript)
11
(No Transcript)
12
Confidence Interval

• 95 Confidence Interval Mean ? (1.96 Standard
  Deviation/Sqrt (count)
• E21E4-1.96E8/SQRT(E16)
• E22E41.96E8/SQRT(E16)

13
Histogram
14
(No Transcript)