Elasticities and secondary axis graphs, Microeconomics

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?

Posted Date: 4/12/2013 3:45:19 AM | Location : United States







Related Discussions:- Elasticities and secondary axis graphs, Assignment Help, Ask Question on Elasticities and secondary axis graphs, Get Answer, Expert's Help, Elasticities and secondary axis graphs Discussions

Write discussion on Elasticities and secondary axis graphs
Your posts are moderated
Related Questions
b) Sally’s firm produces granola bars with a fixed cost of 10 (this cost is already sunk). Her variable cost function is VC = q2 + 2q. Assuming the market for granola bars is comp

Ask quesIn your own words describe how a market would adjust in situations of: a) Excess Demand b) Excess Supply c) Equilibrium As a follow up you might think about what effects

Visit to a village panchayat for agriculture based project

Asian Crisis: Between 1997-98, several of the East Asian tiger economies suffered a severe economic and financial crisis. it had big consequences in the global financial markets, t

Balancing Needs and Resources planning is a balancing act. It involves the balancing of needs with resources towards set goals. Likewise, educational planning involves the bal

Which assumption of Classic OLS does this model violate?

Engel Curves -Engel curves relate quantity of good consumed to income. -If good is a normal good, Engel curve is sloping upward. -If good is an inferior good, the Engel c

Explain the Demand Pull Inflation Demand Pull Inflation:    Occurs when aggregate demand exceeds aggregate supply. If there is an excess level of demand in the economy, this w

Economic Growth: Economic Growth refers to an increase in real aggregate output (real GDP) reflected in increased real per capita income. A country is said to experience econo

what do you understand by linear break-even point? in what way is it useful in managerial economics? what are the assumptions underlying the analysis?