1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Alenkasestr [34]
3 years ago
11

Mr. Ibanez has shared a spreadsheet with his students. The first column is blank. The second column contains names in random ord

er in cells B3:B13. Additional data is located in columns C and D. He asks the students to alphabetize the names in descending order while maintaining the correlating data. The students correctly highlight cell range B3:D13 and then:
Business
1 answer:
kati45 [8]3 years ago
8 0

Answer:

Sort by Column B, ZA

Explanation:

The spreadsheet is the software which enables the accountants and business managers to handle complex calculation with ease. Mr.Ibanez has asked students to organize the spreadsheet with names according to descending order. The names are listed in column B. The student should select the area and then click sort option. The dialogue box will appear which will ask to sort according to ascending or descending.

You might be interested in
Arbor Systems and Gencore stocks both have a volatility of 33%. Compute the volatility of a portfolio with 50% invested in each
fiasKO [112]

Answer:

<h3>In case of b, c, d ,e volatility is less than that of original stock</h3>

Explanation:

The formula to compute the volatility of a portfolio

=\sqrt{W_1^2\sigma_1^2+W_2^2\sigma_2^2+2W_1W_2\sigma_1\sigma_2*c}

Here,

The standard deviation of the first stock is σ₁

The standard deviation of the second stock is σ₂

The weight of the first stock W₁

The weight of the second stock W₂

The correlation between the stock c

a) If the correlation between the stock is +1

=\sqrt{W_1^2\sigma_1^2+W_2^2\sigma_2^2+2W_1W_2\sigma_1\sigma_2*c}

=\sqrt{(0.5\times0.33)^2+(0.5\times0.33)^2+(2\times(0.5\times 0.33)\times(0.5\times0.33)\times1} \\\\=0.33

Hence, the volatility of the portfolio is 0.33 0r 33%

b) If the correlation between the stock is 0.50

=\sqrt{W_1^2\sigma_1^2+W_2^2\sigma_2^2+2W_1W_2\sigma_1\sigma_2*c}

=\sqrt{(0.5\times0.33)^2+(0.5\times0.33)^2+(2\times(0.5\times 0.33)\times(0.5\times0.33)\times0.5} \\\\=0.29

Hence, the volatility of the portfolio is 0.29 0r 29%

c) If the correlation between the stock is 0.00

=\sqrt{W_1^2\sigma_1^2+W_2^2\sigma_2^2+2W_1W_2\sigma_1\sigma_2*c}

=\sqrt{(0.5\times0.33)^2+(0.5\times0.33)^2+(2\times(0.5\times 0.33)\times(0.5\times0.33)\times0.0} \\\\=0.23

Hence, the volatility of the portfolio is 0.23 0r 23%

d) If the correlation between the stock is -0.50

=\sqrt{W_1^2\sigma_1^2+W_2^2\sigma_2^2+2W_1W_2\sigma_1\sigma_2*c}

=\sqrt{(0.5\times0.33)^2+(0.5\times0.33)^2+(2\times(0.5\times 0.33)\times(0.5\times0.33)\times-0.5} \\\\=0.17

Hence, the volatility of the portfolio is 0.17 or 17%

e) If the correlation between the stock is -1

=\sqrt{W_1^2\sigma_1^2+W_2^2\sigma_2^2+2W_1W_2\sigma_1\sigma_2*c}

=\sqrt{(0.5\times0.33)^2+(0.5\times0.33)^2+(2\times(0.5\times 0.33)\times(0.5\times0.33)\times-1} \\\\=0

Hence, the volatility of the portfolio is 0

<h3>In case of b, c, d ,e volatility is less than that of original stock</h3>

4 0
3 years ago
Reports how much the company is worth to the owners at the
SashulF [63]
I really want to say income statement
6 0
3 years ago
The following information pertains to the West Division of Burger Company:
GenaCL600 [577]

Answer:

D) $4,550

Explanation:

Contribution margin = Net Sales - Total Variable cost

Net sales                             $6,000

Les: Variable costs:

Cost of merchandise sold  $1,000

Operating expenses          <u> $450  </u>

Contribution Margin            $4,550

All other costs are fixed cost which are not used in contribution margin calculation.

So the correct answer is D) $4,550.

3 0
3 years ago
Christopher has a collection of 20 video games and will buy 4 more each month. Peter has a collection of 92 video games and will
Anton [14]

Answer:

It would be 8 months and they each would have 52 games.

Explanation:

8 0
2 years ago
What is a service technology? Are different types of service technologies likely to be associated with different structures? Exp
Soloha48 [4]

Explanation:

it refers to the use of services for software development, where a service is an autonomous, platform agonstic software component that operate within an ecosystem of services

7 0
3 years ago
Other questions:
  • Over a decade ago, survivor premiered as a nighttime reality tv show during the summer season when tv ratings are normally low a
    6·1 answer
  • What are the most important elements of Toyota's organizational structure
    12·2 answers
  • When the balance of an equity account, like Capital Stock, increases, it means that the account has been: Multiple Choice Deposi
    9·1 answer
  • Economic leverage occurs when a business uses it economic power to:
    11·1 answer
  • A firm will not shut down in the longminus?run as long as the firms? revenue:
    10·1 answer
  • Managers can achieve effective cross-cultural interaction by ________.
    14·1 answer
  • Building a foundation in the knowledge of consumer needs and interests will help you to
    11·1 answer
  • Botosan Factory has budgeted factory overhead for the year at $453,120, and budgeted direct labor hours for the year are 384,000
    9·2 answers
  • A newspaper story discussing high profits and low unemployment indicates a strong economy
    15·1 answer
  • You won the lottery and may choose between Prize 1, which would pay you $50,000 today and $200,000 at the end of 10 years OR rec
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!