Elasticities and secondary axis graphs, Microeconomics

Assignment Help:

Create a chart with a secondary vertical axis to plot related data series with different scales.

Use the Combination Chart Fashion worksheet to create and format a combination chart exactly as illustrated in the picture provided in the Excel worksheet.  The two data series are net income and total assets.

First create a 2D column chart of total assets.  Please enter the series name.

Second click the active chart area to make it active then right click to get the menu, choose select data, and then add the net income as a data series.  Please enter the series name.

Also, add the fashion company names to the horizontal axis using the select data menu.

Third, you can plot data on a secondary vertical axis one data series at a time. In the chart, left click the data series that you want to plot on a secondary vertical axis in this case net income. In the design tab choose change chart type.  Find and select the option line with markers.

When the line is entered into the graph, left click on the net income line to make it active.  Make the layout menu tab active.  In the current selection box, select format selection, series option and select secondary axis. The secondary axis should be displayed.

Now, format the axis to the desired scale.  Left click on the left axis to make it active, right click and select format axis.  Choose the fixed options and use 0, 10000, and 2000 for minimum, maximum and major unit, respectively.

Calculate the Return on Asset (ROA) for each firm (using the appropriate formula listed below in cells B37, C37, D37, and E37. Format with a % sign). Using the ROA, rank the firms from highest to lowest. Why might a manager care about ROA?


Related Discussions:- Elasticities and secondary axis graphs

Chemistry, Write the formulas to show the reactants and products for the fo...

Write the formulas to show the reactants and products for the following reactions. Assume that solutions are aqueous unless otherwise indicated. Represent substances in solutions a

Absolute and comperitive advantage, If one person can produce 1 fish and 10...

If one person can produce 1 fish and 10 oranges per hour and works 5 hours a day.another person can produce 2 fish and 20 oranges per 2 hors and works 8 hurs a day then who has the

What is the adam smith view of invisible hand, What is the Adam smith view ...

What is the Adam smith view of "invisible Hand"?  Invisible hand is an unknown power which is working for the interest of total economy. In any economy, everybody cares for his

Strategic importance of supply chain management, Strategic Importance of Su...

Strategic Importance of Supply Chain Management This describes the scope of supply chain management (SCM), including the management of procurement, logistics and materials. It

Collective opinion method, This is also known as sales force Opinion Method...

This is also known as sales force Opinion Method. In this method instead of consumers the opinion of the salesmen is sought. It is sometimes referred as the grassroots approach as

Examine the factors that influence a country s exchange rate, Examine the f...

Examine the factors that influence a country s exchange rate. Suppose and define a floating exchange rate, the major issue here is to outline the factors influencing the supply

Money multiplier, Should the bank not have anyone to lend the demand deposi...

Should the bank not have anyone to lend the demand deposit to (like that will ever happen) would the size of the money multiplier decrease? If so, why?

Mangerial Economics, A portion of the demand schedule for wax candles (per ...

A portion of the demand schedule for wax candles (per case) is shown below. Px $50 $30 $10 Qx 500 600 700 What is the demand curve (straight line) that corresponds to the schedu

Oppurtunity cost, 1. Assume that Malaysia can produce cencaluk at 25 bottle...

1. Assume that Malaysia can produce cencaluk at 25 bottles per worker and belacan at RM5 per worker. Assume that Indonesia can produce 10 bottles of cencaluk per worker and 20 pack

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd