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

  1. Compare and contrast, using a real-life practical scenario within the context of Business Administration, and using appropriate referencing:
    1. Value-at-Risk
    2. Expected shortfall
    3. 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.

  1. Make a frequency table with seven classes showing class limits, class boundaries, midpoints, frequencies and relative frequencies.
  2. Draw a histogram.
  3. Identify the shape of the distribution.
  4. Draw a stem and leaf and an ogive.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!