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

Implications for the role of economic theory, Implications for the Role of ...

Implications for the Role of Economic Theory : Like the schedule for the marginal efficiency of capital, expectations about the future market rate of interest underlie the li

Monopsony, what are the pros and cons of monopsony

what are the pros and cons of monopsony

Inelastic, "price makers" never want to produce in the inelastic part of th...

"price makers" never want to produce in the inelastic part of their demand curve why

Returns from education, Returns from Education Monetary benefits from ...

Returns from Education Monetary benefits from education are called as returns. Such benefits accruing to an individual are called as private returns. The sum of all private re

Direct and indirect benefits, Direct and Indirect Benefits Life time e...

Direct and Indirect Benefits Life time earnings of an educated person is an instance of direct benefit from education. Skills produced in training or extension programmes in a

Microeconomics assignments, a severe restriction occurs to the availability...

a severe restriction occurs to the availability of consumer credit throughout the banking and finance system

Development administration, Development Administration: Since the Gove...

Development Administration: Since the Government has been entrusted to manage economic and business activities, it was found difficult to manage the economic policy with the t

Sample survey and test marketing, Sample Survey and Test Marketing: Under...

Sample Survey and Test Marketing: Under this method some representative households are selected on random basis as samples and their opinion is taken as the generalized opinio

External cost or external benefit, Explain externality, how can government ...

Explain externality, how can government intervene to achieve allocative efficiency in case of external cost or external benefit? Answer The term externalities refers to bot

What is market clearing level and public good, What is market clearing leve...

What is market clearing level and public good? Market clearing level is the price level current in the market at which consumer is willing to purchase a particular commodity f

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