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

Monopoly, what is the total cost if the price of 10,quantity demanded is 9...

what is the total cost if the price of 10,quantity demanded is 900000, at $20 it is 800000? The author is paid 2 million dollars to write a book, the marginal cost of publishing t

Product transformation curve, Production: - Firms should choose how muc...

Production: - Firms should choose how much of each to produce. - The alternative quantities can be illustrated by using product transformation curves. Product Transforma

Determine the cost minimizing capital labour ratio, The production function...

The production function for (a Music company ) their CDs is q= 25*K*L , where q is the number of CDs produced each month, K is the hours of equipment used, and L is the hours of la

Consumer equlbrim, how can a consumer get maximum Equlbrim

how can a consumer get maximum Equlbrim

Supply and demand, Explain the meaning of the statement "coffee and tea are...

Explain the meaning of the statement "coffee and tea are close substitutes".

Deviation, Deviation - Difference between the expected and actual payof...

Deviation - Difference between the expected and actual payoff -  Adjusting for the negative numbers -  The standard deviation measures square root of average of squa

Elasticity, You estimate that the price elasticity of demand for one-acre p...

You estimate that the price elasticity of demand for one-acre plots in Lusaka is -1.5 and that income elasticity of demand is 5. Land owners intend to increase the price of a one-a

Why a high level of labor force growth is correlated, Why a high level of l...

Why a high level of labor force growth is correlated A high level of labor force growth is correlated--even though less powerfully--with a low level of output per worker. The a

Crop patterns, CROP PATTERNS: Analysis of crop patterns in India shoul...

CROP PATTERNS: Analysis of crop patterns in India should relate to the following aspects:  a) The relative significance of different crops/crop groups in the overall area u

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