Question: The following table has Olympic Games Host information; it includes the type and location data for Olympic Games from 1896 to 2024. (The middle years

The following table has Olympic Games Host information; it includes the type and location data for Olympic Games from 1896 to 2024. (The middle years have been removed in the image below for space-saving reasons, but assume all the data is included in the analysis.)

5.1 You want to show the number of times the Olympic Games have been hosted by each country. You put Country in the Rows area to show each of the countries. What field should you now drag to the Sum Values area to show the number of times each country hosted the Games? a. Country b. Type c. Year d. Any of these could be used

5.2 You created a pivot table to show the number of games hosted on each continent. You also want to show the % of games hosted on each continent. What should you choose to show the percentages? a. show as % of Column Total b. show as % of Row Total c. show as % of Grand Total d. show as % Difference From

The following table has Olympic Games Host

Number 1 Athens !! Year 1896 1900 1904 1908 1912 Olympic Games' Hosts Type City Summer Summer Paris Summer St. Louis Summer London Summer Stockholm Country Greece France United States United Kingdom Sweden Continent Europe Europe Americas Europe Europe III IV v - XXI 2016 Americas Rio de Janeiro Pyeongchang Tokyo XXXII XXIV XXXIII Summer Winter Summer Winter Summer 2018 2020 2022 2024 South Korea Japan China France Paris Europe 5.1 You want to show the number of times the Olympic Games have been hosted by each country. You put Country in the Rows area to show each of the countries. What field should you now drag to the Sum Values area to show the number of times each country hosted the Games? a. Country b. Type c. Year d. Any of these could be used P Pivot Table Fields FIELD NAME Q Search fields Number Year Type City Country Continent Country Australia Austria Belgium Brazil Canada China Empire of Japan Finland France Germany Greece Italy Japan Mexico Nazi Germany Netherlands Norway Russia South Korea Clinian Filters III Columns Rows Values Country 5.2 You created a pivot table to show the number of games hosted on each continent. You also want to show the % of games hosted on each continent. What should you choose to show the percentages? a. show as % of Column Total b. show as % of Row Total C. show as % of Grand Total d. show as % Difference From % of Games Hosted # of Games Hosted 13 Continent Americas Asia Europe Oceania 9 36 2

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 General Management Questions!

Please review the attached case of the London Olympics. We have to present all our findings using our preferred Risk Register. Next, we have to, IDENTIFY as many risks as we can find in the London...

Consider the following statement: Government-funded projects intended to serve as prestige project, such as the Sochi Olympics, should not be judged on the basis of cost. Do you agree or disagree...

CASE STUDY 8.2 Sochi OlympicsWhat's the Cost of National Prestige? The Olympics happen every two years and the focus 2. Vladimir Putin, President of Russia, had the goal is usually centered mostly on...

I need help with my assignment for accounting. It is to do with report analysis and hypothesis testing. A good knowledge of Excel is required for this task. Analytical review Golden Big Burgers Part...

The Olympics happen every two years and the focus is usually centered mostly on the athletes, but 2014 proved to be different. Instead, topics of overspending, terroris threats, graft and corruption...

MAV SACs 2017 CORE: DATA ANALYSIS APPLICATION TASK SHOT PUT A LOOK AT THE OLYMPIC SHOT PUT RESULTS The Olympic Games were first held in 1986 in Athens, Greece. Since then the competition has moved...

After reading the article from this module's Sport Tourism Learn material , answer the following questions: What are the practical applications of this research for sport event organizers? What...

Why is it so important to integrate marketing communications (IMC)? What are the benefits of IMC? How does Coca-Cola performs IMC? Explain with examples from the case. Although many companies are...

An Investigation into obesity rates Researchers have been interested in studying the obesity trends worldwide over the past 25 years. In 2014 the World Health Organization (WHO) declared there were....

For the exclusive use of A. Young NA0232 Daktronics (A): The U.S. Digital Signage Industry in 2010 Joseph Kavanaugh, Sam Houston State University Joshua Warne and Carol J. Cumber, South Dakota State...

What are the differences among direct mapping, associative mapping, and set associative mapping?

What product would you expect from reaction of 1 equivalent of methanol with a cyclic anhydride, such as phthalic anhydride (1, 2-benzenedicarboxylic anhydride)? What is the fate of the second ?half?...

A consumer reporting agency must also include a _ _ _ _ _ _ _ _ _ _ _ _ with the disclosure to the consumer. 1 . Insurance report 2 . Credit report 3 . Summary of rights 4 . None of the answers...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...