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

Please write an essay (2-2.5 pages) , Please write an essay (2-2.5 pages) b...

Please write an essay (2-2.5 pages) based on this paper You">http://www.nobelprize.org/nobel_prizes/economics/laureates/2001/akerlof-lecture.pdf You pick one over 6 macroeconomic

Fundamental unit of individual economic behaviour, Households: The fundamen...

Households: The fundamental unit of individual economic behaviour. Households offer labour supply to labour market, make consumer purchases,earn income (from employment and other s

Calculate the annual cost to entire industry from closures, 1.  National Ma...

1.  National Marine Fisheries Service is considering closing a large area of federal waters to fishing in Alaska due to negative interactions of fishing with endangered Steller sea

The world bank, THE WORLD BANK: The World Bank is another of the 'Bret...

THE WORLD BANK: The World Bank is another of the 'Brettonwoods Twin Sisters'. The World Bank, as it obtains presently, is an  umbrella organisation, under which five different

Derive a demand function, Zac consumes only pizza and chianti. He consumes ...

Zac consumes only pizza and chianti. He consumes these goods in fixed proportions: 2 slices of pizza for one glass of chianti. His income is $100 per week. a. Derive demand func

Price floor , Suppose that the U.S. Department of Agriculture (USDA) admini...

Suppose that the U.S. Department of Agriculture (USDA) administers the price floor for cheese, set at $0.17 per pound of cheese. (The price floor is officially set at $16.10 per hu

Market supply labour, use a graphical illustration to describe briefly what...

use a graphical illustration to describe briefly what the influence of each of the following be on the market supply of labour,(a) an increase in immigrants, (b) a reduction in wag

Supply and demand, #how do you draw a demand curve on excel

#how do you draw a demand curve on excel

Marginal product of a factor, Marginal Product (MP) of a Factor: From ...

Marginal Product (MP) of a Factor: From the above mentioned production function, immediately we can study the effect on total output when there is a variation in labour utlili

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