Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started