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

Use a ppf to explain the trade-offs that all economies face, Use a PPF to e...

Use a PPF to explain the trade-offs that all economies face. All countries must construct some sort of system whereby output, allocation and distribution of goods is decided.

Economics final paper analysis, This is what this paper should be about ...

This is what this paper should be about 1) In the first paragraph analyze what you most learned from the course to reflect on the statement below. 2) In each separat

Market competition., explain why policies for promoting market competition ...

explain why policies for promoting market competition are desireable

Natural research, Biochemistry is regarded a dull topic. Not many learners ...

Biochemistry is regarded a dull topic. Not many learners like to research it in school since it includes a thorough comprehension of issue and clinical changes in the framework, fr

Indifference curve and budget line, How does the indifference curve and bud...

How does the indifference curve and budget line for a neutral good look like?

Physical capital, Physical Capital: A tangible tool, machine, building or o...

Physical Capital: A tangible tool, machine, building or other productive asset that is used to produce other goods or services. Pollution: Many economic activities involve disch

Explain the phrase price rationing means, Explain what the phrase “price ra...

Explain what the phrase “price rationing” means. Price rationing is the method by which the market system assigns goods and services to consumers while quantity demanded exceeds

Indifference curve, application of indifference curve analysis to the probl...

application of indifference curve analysis to the problem of exchange

Dynamic changes in costs: the learning curve, Dynamic Changes in Costs: The...

Dynamic Changes in Costs: The Learning Curve *  The learning curve measures impact of worker's experience on costs of production. *  It describes relationship between a firm

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