tralia 24 987.00 654 tzerland $ 5,007.00 $ 6,498. ited Kingdom $ 6,514.00 $ 6,549. $ 2,665. Igium $ 2,896.00 $ 2,839.00 $ 1,728.00 3 ermany 3. $ 2,300. ance $ 1,793.0 %24 3. 3. 3.

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
3.
3.
3.
3.
%24
%23
00.660
$ 1,017.00
$ 8,744.00
572.00
EIger pnes
932.00
654.00
24
$ 6,498.00
Australia
2.
00 286
$ 5,007.00
$10,042.00
$ 6,514.00
$ 6,549.00
$ 5,009.00
$ 6,217.00
United Kingdom
$ 3,898.00
$ 2,909.00
$ 1,977.00
$ 2,896.00
$ 2,665.00
Belgium
3.
$ 2,839.00
$ 2,300.00
$ 2,183.00
Germany
3.
$1,728.00
$ 1,793.00
$ 1,720.00
$ 1,949.00
France
3.
$ 1,517.00
$ 1,283.00
$1,350.00
Korea, South
3.
$1,108.00
$ 1,427.00
$ 1,206.00
$1,177.00
Singapore
851.00
$ 1,024.00
Italy
3.
388.00
581.00
3.
Spain
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 foreach
3. Plot a chart of the percentage distribution of trade by region by year (Stacked Bar Chart)
ear
4. Which Region is the largest Trading partner with New York State? Which is the smallest?
All charts must be on a clear background (No background colors)
Submit your assignment through the Blackboard link.
a.
to search
2)
# 五
山
f6
61
f5
84
f2
f3
f4
十吉
米
)
00
6.
4.
9
3.
R.
Transcribed Image Text:%24 3. 3. 3. 3. %24 %23 00.660 $ 1,017.00 $ 8,744.00 572.00 EIger pnes 932.00 654.00 24 $ 6,498.00 Australia 2. 00 286 $ 5,007.00 $10,042.00 $ 6,514.00 $ 6,549.00 $ 5,009.00 $ 6,217.00 United Kingdom $ 3,898.00 $ 2,909.00 $ 1,977.00 $ 2,896.00 $ 2,665.00 Belgium 3. $ 2,839.00 $ 2,300.00 $ 2,183.00 Germany 3. $1,728.00 $ 1,793.00 $ 1,720.00 $ 1,949.00 France 3. $ 1,517.00 $ 1,283.00 $1,350.00 Korea, South 3. $1,108.00 $ 1,427.00 $ 1,206.00 $1,177.00 Singapore 851.00 $ 1,024.00 Italy 3. 388.00 581.00 3. Spain 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 foreach 3. Plot a chart of the percentage distribution of trade by region by year (Stacked Bar Chart) ear 4. Which Region is the largest Trading partner with New York State? Which is the smallest? All charts must be on a clear background (No background colors) Submit your assignment through the Blackboard link. a. to search 2) # 五 山 f6 61 f5 84 f2 f3 f4 十吉 米 ) 00 6. 4. 9 3. R.
%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
$ 1,505.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
$ 1,017.00
2$
$ 6,498.00
932.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
$2,183.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 $ 1,505.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 $ 1,017.00 2$ $ 6,498.00 932.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 $2,183.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
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE 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