Question
Need help with the formula to create the charts. Country Region 2011 Value 2012 Value 2013 Value 2014 Value Canada 1 $16,290.00 $15,395.00 $16,863.00 $17,064.00
Need help with the formula to create the charts.
Country
Region
2011 Value
2012 Value
2013 Value
2014 Value
Canada
1
$16,290.00
$15,395.00
$16,863.00
$17,064.00
Mexico
1
$2,611.00
$2,606.00
$2,202.00
$2,875.00
Brazil
1
$1,108.00
$1,053.00
$833.00
$741.00
Hong Kong
2
$8,109.00
$8,897.00
$9,310.00
$10,790.00
Israel
2
$5,133.00
$4,469.00
$5,226.00
$6,367.00
China
2
$4,459.00
$4,286.00
$5,033.00
$4,291.00
India
2
$2,748.00
$2,482.00
$2,026.00
$2,520.00
United Arab Emirates
2
$1,517.00
$1,636.00
$2,013.00
$1,921.00
Japan
2
$2,519.00
$2,254.00
$2,089.00
$1,902.00
Netherlands
2
$2,187.00
$1,505.00
$1,491.00
$1,279.00
Taiwan
2
$1,248.00
$997.00
$763.00
$844.00
Turkey
2
$744.00
$905.00
$761.00
$739.00
Thailand
2
$986.00
$517.00
$846.00
$502.00
Saudi Arabia
2
$597.00
$572.00
$599.00
$467.00
Australia
2
$987.00
$654.00
$932.00
$1,017.00
Switzerland
3
$5,007.00
$6,498.00
$10,042.00
$8,744.00
United Kingdom
3
$6,514.00
$6,549.00
$5,009.00
$6,217.00
Belgium
3
$2,896.00
$2,665.00
$2,909.00
$3,898.00
Germany
3
$2,839.00
$2,300.00
$1,977.00
$2,183.00
France
3
$1,728.00
$1,793.00
$1,720.00
$1,949.00
Korea, South
3
$1,967.00
$1,517.00
$1,283.00
$1,350.00
Singapore
3
$1,427.00
$1,206.00
$1,177.00
$1,108.00
Italy
3
$992.00
$997.00
$851.00
$1,024.00
Russia
3
$512.00
$672.00
$581.00
$388.00
Spain
3
$436.00
$398.00
$386.00
$366.00
1=North and South America
2=Asia & Middle East
3=Europe
The table above presents data on the top 25 trading partners of the State of New York from 2011 through 2014 in $Million.The countries have been classified into three World Regions.
Cut and paste the table into a Spreadsheet and Summarize, using tables
1.Total Value of Trade by Region by Year and Region and Plot a chart
2.The Percentage of each region's trade value to total trade for each year
3.Plot a chart of the percentage distribution of trade by region by year (Stacked Bar Chart)
4.Which Region is the largest Trading partner with New York State? Which is the smallest?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Energy, Foresight And Strategy
Authors: Thomas J Sargent
1st Edition
1317329686, 9781317329688
