Question: Using the same workbook, copy both datasets into one worksheet so that they can be used together in a pivot table. Transpose them using Paste

Using the same workbook, copy both datasets into one worksheet so that they can be used together in a pivot table. Transpose them using Paste Special Transpose.

a. Create a pivot table that shows the quarter over quarter change in both Sales and Total Assets.

b. Create a pivot line chart that shows the data from part

a. Does there appear to be a strong correlation between the two data series? Now put Sales on a secondary y-axis so that the scales are comparable.

Does that change your original answer?

c. Create a calculated field that shows Alphabet’s return on equity for each quarter.

d. Create a pivot line chart that shows the ROE over time. Does it appear that there is any trend in the ROE? If so, is it up or down?

e. Add a linear trend line to the pivot chart from part

d, and show the equation on the chart. Does this change or confirm your previous answer?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Financial Management Questions!

Questions 1 and 2, please show work in excel. 1. Using the data in the Alphabet Financials xlsx workbook that was used in the chapter: a. Convert the balance sheet into a format that is suitable for...

23 4900 32.748 9/30/2016 6/30/2016 3/31/2016 12/31/2015 9/30/2015 6/30/2015 3/31/2015 12/01/2014 9/10/2014 6/30/2014 Cash 9,253 13,399 14090 14.537 16 610 16,582 14,205 16,038 14,414 16,402 Short...

Using the data in the Alphabet FInancials.xlsx workbook that was used in the chapter: Using the same workbook, copy both datasets into one worksheet so that they can be used together in a pivot...

1. Using the data in the Alphabet Financials.xlsx workbook that was used in the chapter: (WORKBOOK POSTED BELOW) a. Convert the balance sheet into a format that is suitable for a pivot table by...

Using the same workbook, copy both datasets into one worksheet so that they can be used together in a pivot table. Transpose them using Paste Special Transpose. Data from Alphabet Financials.xlsx...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

I'm having such a hard time figuring out how to complete this excel workbook. Hoping to get a detailed step-by-step guide on how to complete steps 2-15. Thanks! File Home Insert Draw Page Layout...

NOTE: please just help me with what can be done and I can resubmit the rest into another question. Up to here is what I will like help on if possible the rest is just for more info and can resubmit...

Introduction "NYP," New York Paper Co., is using its financial results for August 2019 (Table 1) as a base for projecting the company's budget for the remaining four months of the year...

I need your help! Please help me! Total Students Average Rate Total Due TotalSessions FirstName Barrett Wang Daphne Irma Karen Leroy Ursa Ella Jena Zenia Stone Samantha Brenna Hiram Rate 15 10 1 7 1...

1. Consider the market for bananas at a local produce store. The manager has data on how much consumers will demand and how much his distributors will supply at various prices. (I have answered it...

The project manager for the project in Problem 1 has estimated the probabilities of not detecting the risks in time to react to them as follows, again on a seven-point scale: Threat 1: 4, Threat 2:...

12199. Starting from rest, the cable can be wound onto the drum of the motor at a rate of vA = (3t2) m>s, where t is in seconds. Determine the time needed to lift the load 7 m. D A C B Probs....

Phoenix Plastic Inc. has accumulated the following data over a six-month period: Separate the machine-related costs into their fixed and variable components, using the high-lowmethod. Machine Hours...