Create a pivot table for all months for each industry

Assignment Help Other Subject
Reference no: EM132419406

INSTRUCTIONS -

Visualizing Data - Using the Draft created in Activity 3.2 during Week3, continue developing your report

Step 1: Conditional Format Main Data Set

Create a three color scale Conditional format for the currency figures using all dollar amounts in the data table.

Step 2: Add four insights to your Summary worksheet

On your summary sheet include (4 different insights):

- Which industry has the highest average rates in the most recent two years?

- Which industry has the lowest average rates in the most recent two years?

- Are at least two industries similar in pay? If so, which industries?

- Describe at least one additional insight you had from your analysis.

Attached is a screenshot of a sample Summary sheet to this point. Your Industries may differ.

Step 3: Create the Pivot Table 1

Go back to main data set

Create a pivot table for all months for each industry.

All values should be changed to "Average" and be in a currency format with two decimals.

Apply a three color scale conditional format for each industry's column individually.

Step 4: Add two insights for Pivot Table 1 to Summary Sheet

On your summary sheet, describe at least one insight you found from applying the conditional format on the comparisons for each industry by month.

Are there any months that are consistently high or consistently low among the industries?

Step 5: Create Pivot Table 2

Go back to the main data set.

Create a second pivot table for all years for each industry.

Place this pivot table below your first pivot table (use "Existing sheet" option).

Create a three-color scale conditional format for each industry individually.

Step 6: Add insights for Pivot Table 2 to Summary Sheet

On your summary sheet, describe at least one insight you found from applying the conditional format on the comparisons of individual industries for all years.

Step 7: Format the document for printing

Apply "Repeat Row1 at Top" to the main data set (see Week3 Tutorial if you need help on this task).

Format the workbook for printing. Ensure data does not break across pages horizontally.

Apply worksheet design guidelines (Note: Page Layout view will not be completed on the main data set due to Freeze Panes; however, it should be applied to both your pivot table worksheet and summary worksheet).

Step 8: Save to PDF and Submit both files

A sample of the final Assignment appearance is shown below.

You will submit: One Excel workbook with 3 worksheets and One PDF file with 4-5 pages.

Attachment:- Assignment Files.rar

Reference no: EM132419406

Questions Cloud

COM101B Computer Programming Assignment : COM101B: Computer Programming Assignment Help and Solution - Brick Shooter Game, Ankara University, Turkey. Your job is going to create brick shooter game
Project alternatives for mac assignment : Project alternatives for Mac Assignment helps and solutions:-Define each, and explain what these tools are best used for.What activities or tasks will be needed
Vacation policy change to be distributed to staff assignment : Vacation policy change to be distributed to staff Assignment help and solutions:-Create a one to two paragraph email with five to seven sentences th
Financial analysis on company using public information : Prepare a financial analysis on the company using public information such as the company's annual report, SEC 10-Q and 10-K.
Create a pivot table for all months for each industry : Create a pivot table for all months for each industry. All values should be changed to "Average" and be in a currency format with two decimals
Create process proposal for organization with guidelines : Read the case study entitled You be the Ethicist, presented at the end of Chapter 3 (Guido textbook). What are the compelling rights that this case addresses?
Describe the kinds of evidence that a plaintiff can present : Describe the kinds of evidence that a plaintiff can present in order to establish a negligent act. What defenses can a defendant present in order to refute a.
Auditing vs monitoring : Provide an annotated reference list at the end. Annotations consist of two paragraphs of at least five sentences each about each of at least five references
Explain how the essential will be used to improve quality : Explain why you selected this Essential; and Explain how this Essential will be used to improve quality in your future professional nursing career.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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