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.
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
Related questions
Question

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.

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman