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.
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
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F79bd8cbe-0fff-4491-b108-2bca08685b95%2F9548b6d4-63ba-480b-9636-7cfbc6a8c2d2%2F7ik2qvs.jpeg&w=3840&q=75)
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,](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F79bd8cbe-0fff-4491-b108-2bca08685b95%2F9548b6d4-63ba-480b-9636-7cfbc6a8c2d2%2F9h3g6kl_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
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 |
Step by step
Solved in 3 steps with 8 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman