Answered step by step
Verified Expert Solution
Link Copied!

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

  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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Intelligence For Entrepreneurs What You Really Need To Know About The Numbers

Authors: Karen Berman, Joe Knight

1st Edition

1422119157, 9781422119150

More Books

Students also viewed these Accounting questions

Question

Would you investigate to learn more about this Club? How?

Answered: 1 week ago