Question: Consider the spreadsheet simulation model (see the tab costs). In class, Column F shows the profits over 100 trials. It is required to collect a
Consider the spreadsheet simulation model (see the tab costs). In class, Column F shows the profits over 100 trials. It is required to collect a statistic of frequency percentile of profits per an interval. Specifically, ranging from -$1,000,000 to $2,500,000 with an increment of $250,000. Hence, the total number of intervals is 14. (Hint: set up lower and upper bounds for each interval in Columns K and L, respectively) (a) Provide randomly observed frequency percentile for each interval in Column L. (b) Draw a bar chart showing the frequency percentiles over all intervals with a horizontal axis of upper bounds of intervals and a vertical axis of frequency percentiles.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
