Walkthrough: Adding a Random Parameter to Create a Stochastic Model
You can use the simulation framework in Solver Foundation to convert a model to a stochastic model. By adding a random parameter, you can create a more realistic model.
To add data to an Excel spreadsheet
-
In the Solver Foundation ribbon, click Model to display the Modeling Pane.
-
In the Excel worksheet, enter the following data. The following table lists the carrying capacity per month for each type of plane for each route (in thousands).
Route
ID
Miles
Demand
Std.Dev
Price
NY-LA
0
2475
250
5
520
NY-SF
1
2300
120
5
520
NY-Dallas
2
1381
180
5
280
NY-Houston
3
1439
90
2
280
NY-Boston
4
185
600
5
40
To add a random parameter to a model
-
Select the five rightmost columns, including the column name.
-
In the Sets tab, click New.
-
For the Name, type Route.
-
In the Parameters tab, click New, and then click Random Parameter, and then Distribution Parameter.
-
For the Name, type DemandRandom.
-
In the Distribution drop-down menu, select Normal.
-
Next to Binding, click the […] ellipsis button.
The Binding Editor appears.
-
Verify that the range in the Table/Range text box is correct.
-
In the Mean drop-down menu, select Demand.
-
In the Standard Deviation drop-down menu, select Std.Dev.
-
In the Set column, select Route.
-
In the Columns column, select ID.
-
Click OK.