Question: Compare and contrast, using a real-life practical scenario within the context of Business Administration, and using appropriate referencing: Value-at-Risk Expected shortfall Profit-at-risk Use Excel to
- Compare and contrast, using a real-life practical scenario within the context of Business Administration, and using appropriate referencing:
- Value-at-Risk
- Expected shortfall
- Profit-at-risk
Use Excel to compute the different measures and detail the steps clearly.
b) Clearly showing your work, and without the use of software, answer the following question:
The data in Table 1 gives the recorded profit in thousands of a company.
| 108 | 99 | 106 | 102 | 115 | 120 | 120 | 117 | 122 | 142 |
| 106 | 111 | 119 | 109 | 125 | 108 | 116 | 105 | 117 | 123 |
| 103 | 114 | 101 | 99 | 112 | 120 | 108 | 91 | 115 | 109 |
| 114 | 105 | 99 | 122 | 106 | 113 | 114 | 75 | 96 | 124 |
| 91 | 102 | 108 | 110 | 83 | 90 | 69 | 117 | 84 | 142 |
| 122 | 113 | 105 | 112 | 117 | 122 | 129 | 100 | 138 | 117 |
Table 1: Profit (000s) of a company.
- Make a frequency table with seven classes showing class limits, class boundaries, midpoints, frequencies and relative frequencies.
- Draw a histogram.
- Identify the shape of the distribution.
- Draw a stem and leaf and an ogive.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
