Country Region 2011 Value 2012 Value 2013 Value 2014 Value 1=North and South Canada 1 $16,290.00 $15,395.00 $16,863.00 $17,064.00 America Mexico 1 $ 2,611.00 $ 2,606.00 $ 2,202.00 $ 2,875.00 2=Asia & Middle Brazil 1 $ 1,108.00 $ 1,053.00 833.00 2$ 741.00 East Нong Kong $ 8,109.00 $ 8,897.00 $ 9,310.00 $10,790.00 3=Europe Israel $ 5,133.00 $ 4,469.00 $ 5,226.00 $ 6,367.00 $ 4,459.00 $ 2,748.00 $ 5,033.00 $ 2,026.00 $ 4,286.00 $ 4,291.00 $ 2,520.00 China India $ 2,482.00 United Arab Emirates 2. $ 1,517.00 $ 1,636.00 $ 2,013.00 $ 1,921.00 2. 2. 2. 2.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
%24
%24
T
%24
3.
3.
2.
5
2.
2.
2.
R
%24
3.
23
316 Business &
PIC
Spreadsheet Assignment
2012 Value
2013 Value
2014 Value
1=North
Country
Region
2011 Value
and South
Canada
1.
$16,290.00
$15,395.00
$16,863.00
$17,064.00
America
$ 2,611.00
$ 2,606.00
$ 2,202.00
$ 2,875.00
2-Asia &
$ 741.00
2$
$10,790.00
$ 1,108.00 $ 1,053.00
$ 833.00
zea
Hong Kong
East
$ 8,109.00
$ 8,897.00
$ 9,310.00
3=Europe
Israel
$ 5,133.00
$ 4,469.00
$ 5,226.00
$ 6,367.00
$ 4,286.00
$ 2,482.00
$ 4,291.00
$ 2,520.00
China
$ 4,459.00
$ 5,033.00
2.
India
$ 2,748.00
$ 2,026.00
2.
United Arab Emirates
$1,517.00
$ 1,636.00
$ 2,013.00
$ 1,921.00
Japan
$ 2,519.00
$2,254.00
$ 2,089.00
$1,902.00
2.
Netherlands
$ 2,187.00
$ 1j505.00
$1,491.00
$ 1,279.00
2.
Taiwan
$ 1,248.00
763.00
844.00
744.00
905.00
24
761.00
846.00
Turkey
739.00
Thailand
24
502.00
467.00
517.00
Saudi Arabia
597.00
572.00
24
Australia
987.00
2$
$ 6,498.00
932.00
$1,017.00
Switzerland
$ 5,007.00
$10,042.00
$ 8,744.00
3.
United Kingdom
$ 6,514.00
$ 6,549.00
$6,217.00
Belgium
$ 2,896.00
$ 2,665.00
$ 2,909.00
3.
Germany
3.
3
S 2,839.00
$1,977 00
$ 2j183.00
$1,728.00
$1,720.00
Korea, South
$ 1,517.00
S 1,283.00
3.
Singapore
$ 1,427.00
$ 1,177.00
S 1,108.00
3.
Italy
851.00
$ 1,024.00
Russia
512.00
581.00
3.
Spain
366.00
3.
DFocus
nere to search
a.
37°F
: 直
2)
dy
f2
f3
f4
f5
f6
83
f12
64
Oly
4.
7.
00
6
H 9
Transcribed Image Text:%24 %24 T %24 3. 3. 2. 5 2. 2. 2. R %24 3. 23 316 Business & PIC Spreadsheet Assignment 2012 Value 2013 Value 2014 Value 1=North Country Region 2011 Value and South Canada 1. $16,290.00 $15,395.00 $16,863.00 $17,064.00 America $ 2,611.00 $ 2,606.00 $ 2,202.00 $ 2,875.00 2-Asia & $ 741.00 2$ $10,790.00 $ 1,108.00 $ 1,053.00 $ 833.00 zea Hong Kong East $ 8,109.00 $ 8,897.00 $ 9,310.00 3=Europe Israel $ 5,133.00 $ 4,469.00 $ 5,226.00 $ 6,367.00 $ 4,286.00 $ 2,482.00 $ 4,291.00 $ 2,520.00 China $ 4,459.00 $ 5,033.00 2. India $ 2,748.00 $ 2,026.00 2. United Arab Emirates $1,517.00 $ 1,636.00 $ 2,013.00 $ 1,921.00 Japan $ 2,519.00 $2,254.00 $ 2,089.00 $1,902.00 2. Netherlands $ 2,187.00 $ 1j505.00 $1,491.00 $ 1,279.00 2. Taiwan $ 1,248.00 763.00 844.00 744.00 905.00 24 761.00 846.00 Turkey 739.00 Thailand 24 502.00 467.00 517.00 Saudi Arabia 597.00 572.00 24 Australia 987.00 2$ $ 6,498.00 932.00 $1,017.00 Switzerland $ 5,007.00 $10,042.00 $ 8,744.00 3. United Kingdom $ 6,514.00 $ 6,549.00 $6,217.00 Belgium $ 2,896.00 $ 2,665.00 $ 2,909.00 3. Germany 3. 3 S 2,839.00 $1,977 00 $ 2j183.00 $1,728.00 $1,720.00 Korea, South $ 1,517.00 S 1,283.00 3. Singapore $ 1,427.00 $ 1,177.00 S 1,108.00 3. Italy 851.00 $ 1,024.00 Russia 512.00 581.00 3. Spain 366.00 3. DFocus nere to search a. 37°F : 直 2) dy f2 f3 f4 f5 f6 83 f12 64 Oly 4. 7. 00 6 H 9
Saudi Araba
597.00
572.00
599.00
467.00
Australia
987.00
2$
654.00
932.00
$ 1,017.00
$ 8,744.00
Switzerland
$ 5,007.00
$ 6,498.00
$10,042.00
United Kingdom
$ 6,514.00
$ 2,896.00
$ 2,839.00
3.
$ 6,549.00
$ 5,009.00
$ 6,217.00
$ 3,898.00
$ 2,183.00
Belgium
3
$2,665.00
$ 2,909.00
Germany
3.
$ 2,300.00
$ 1,977.00
France
3.
$ 1,728.00
$ 1,793.00
$ 1,720.00
$1,949.00
Когea, South
$ 1,967.00
S 1,427.00
$ 1,517.00
$ 1,283.00
$ 1,350.00
$ 1,108.00
Singapore
3
$ 1,206.00
$ 1,177.00
Italy
3.
24
992.00
997.00
851.00
$1,024.00
Russia
512.00
672.00
24
581.00
388.00
Spain
3
436.00
398.00
24
386.00
366.00
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
Total Value of Trade by Region by Year and Region and Plot a chart
The Percentage of each region's trade value to total trade for each year
3. Plot a chart of the percentage distributlon of trade by region by year (Stacked Bar Chart)
4. Which Region is the largest Trading partner with New York State? VWhich is the smallest?
All charts must be on a clear background (No background colors)
Submit your assignment through the Blackboard link.
%24
23
3,
Transcribed Image Text:Saudi Araba 597.00 572.00 599.00 467.00 Australia 987.00 2$ 654.00 932.00 $ 1,017.00 $ 8,744.00 Switzerland $ 5,007.00 $ 6,498.00 $10,042.00 United Kingdom $ 6,514.00 $ 2,896.00 $ 2,839.00 3. $ 6,549.00 $ 5,009.00 $ 6,217.00 $ 3,898.00 $ 2,183.00 Belgium 3 $2,665.00 $ 2,909.00 Germany 3. $ 2,300.00 $ 1,977.00 France 3. $ 1,728.00 $ 1,793.00 $ 1,720.00 $1,949.00 Когea, South $ 1,967.00 S 1,427.00 $ 1,517.00 $ 1,283.00 $ 1,350.00 $ 1,108.00 Singapore 3 $ 1,206.00 $ 1,177.00 Italy 3. 24 992.00 997.00 851.00 $1,024.00 Russia 512.00 672.00 24 581.00 388.00 Spain 3 436.00 398.00 24 386.00 366.00 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 Total Value of Trade by Region by Year and Region and Plot a chart The Percentage of each region's trade value to total trade for each year 3. Plot a chart of the percentage distributlon of trade by region by year (Stacked Bar Chart) 4. Which Region is the largest Trading partner with New York State? VWhich is the smallest? All charts must be on a clear background (No background colors) Submit your assignment through the Blackboard link. %24 23 3,
Expert Solution
Step 1
  Country Region 2011 2012 2013 2014
1 Canada 1 16290 15395 16863 17064
2 Mexico 1 2611 2606 2202 2875
3 Brazil 1 1108 1053 833 741
4 Hong kong 2 8109 8897 9310 10790
5 Israel 2 5133 4469 5226 6367
6 China 2 4459 4286 5033 4291
7 India 2 2748 2482 2026 2520
8 United Arab Emirates 2 1517 1639 2013 1921
9 Japan 2 2519 2254 2089 1902
10 Netherlands 2 2187 1505 1491 1279
11 Taiwan 2 1248 997 763 844
12 Turkey 2 744 905 761 739
13 Thailand 2 986 517 846 502
14 Saudi Arabia 2 597 572 599 467
15 Australia 2 987 654 932 1017
16 Switzerland 3 5007 6498 10042 8744
17 United Kingdom 3 6514 6549 5009 6217
18 Belgium 3 2896 2665 2909 3898
19 Germany 3 2839 2300 1977 2183
20 France 3 1728 1793 1720 1949
21 Korea South 3 1967 1517 1283 1350
22 Singapore 3 1427 1206 1177 1108
23 Italy 3 992 997 851 1024
24 Russia 3 512 672 581 388
25 Spain 3 436 398 386 366
steps

Step by step

Solved in 3 steps with 8 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman