Here's the information you sent me before in the template format. Everything now in the template was in the original document, but all of the explanations on how to do the analyses are left out.

In the section at the beginning called "Population drawn from", I think you're also supposed to add why you're interested in this data. I can't answer that for you, but you could say that you're interested in business, so this data is relevant to that.
---------------------------------------------------------

Deliverable 1: Descriptive Statistics

Sampling Methodology:

Description of how the random sample was drawn: The data used here are total United States exports from 2003 by industry (from http://ita.doc.gov/td/industry/otea/usfth/aggregate/ H03T41.html). There are over 450 industries listed, so 50 were chosen at random by generating 50 random numbers (using a random number generator found here: http://graphpad.com/quickcalcs/randomN1.cfm) and only keeping the industries assigned to those numbers (as determined by the row number in the Excel file).

Population drawn from: The population is total US exports in 2003 separated by industry. The variable analyzed here is the value (in millions of dollars) of exports in the different industries.

Sample size: n = 50

Sample data:

Table 1: Sample Data
Units = millions of dollars
1 515 11 254 21 2,790 31 724 41 1,257
2 1,520 12 123 22 7,495 32 1,767 42 4,486
3 462 13 61 23 12 33 439 43 1,592
4 321 14 306 24 332 34 193 44 24,231
5 223 15 12 25 398 35 9,457 45 1,182
6 888 16 156 26 58 36 7,969 46 148
7 501 17 648 27 383 37 2,484 47 160
8 260 18 13,633 28 1,304 38 1,146 48 1,936
9 574 19 817 29 998 39 2,276 49 243
10 669 20 512 30 741 40 22,299 50 6,564

Numeric descriptive statistics:

Table 2: Numeric statistics
Statistic
Mean ( )
2550 million dollars
Median 659 million dollars
Mode 12 million dollars
Standard Deviation 5073 million dollars
Q1 272 million dollars
Q3 1723 million dollars
Range 2429 million dollars

Graphical descriptive statistics:

Histogram

There are many industries with exports worth less than $3500 million annually, and few industries worth more than that annually. There are many intervals that have a frequency of zero. This highlights the face that there are a few outliers with exports worth much more than the normal annual value. If the interval width was made wider to decrease the number of empty intervals, this would de-emphasize the outlying data and also remove some of the detail from the left side of the histogram.

Stem and Leaf

0| 012, 012, 058, 061, 123, 148, 156, 160, 193, 223, 243, 254, 260, 306, 321, 332, 383, 398, 439, 462, 501, 512, 515, 574, 648, 669, 724, 741, 817, 888, 998
1| 146, 182, 257, 304, 520, 592, 767, 936
2| 276, 484, 790
3|
4| 486
5|
6| 564
7| 495, 969
8|
9| 457
10|
11|
12|
13| 633
14|
15|
16|
17|
18|
19|
20|
21|
22| 299
23|
24| 231
As in the histogram, the stem-and-leaf plot shows that there are many industries with exports worth less than $3500 million annually, and few industries worth more than that annually. In fact, the majority of industries in this sample have annual exports worth less than $1 billion. The industries with the most valuable exports are the aircraft, automobile, and pharmaceutical preparation industries).

Ogive

The ogive shows that most of the industries in this sample have an annual export on the lower end of the range. As the export value increases, there are fewer and fewer industries that have exports worth that much.

Boxplot

The boxplot shows that the data are very skewed. Most of the values (75%) are below the Q3 value of $1723 million, while 25% of the data are between $1723 million and $24,231 million.

Appendix

Data: Total U.S. Exports in 50 industries in 2003

# NAIC Product Millions of Dollars
1 111332--GRAPES 515
2 111335--TREE NUTS 1,520
3 111940--HAY, ALFALFA HAY, AND CLOVER 462
4 111998--OTHER MISCELLANEOUS AGRICULTURAL PRODUCTS 321
5 1123XX--POULTRY AND EGGS 223
6 311514--DRY,CONDENSED & EVAPORATED DAIRY PRODUCTS 888
7 311930--FLAVORING EXTRACTS & SYRUPS 501
8 312120--MALT AND BEER 260
9 313111--YARNS 574
10 313221--NARROW FABRICS 669
11 316991--LUGGAGE 254
12 316992--WOMEN'S HANDBAGS & PURSES 123
13 316993--PERSONAL LEATHER GOODS (EXC PURSE) 61
14 321219--RECONSTITUTED WOOD PRODUCTS 306
15 323116--MANIFOLD BUSINESS FORMS 12
16 324122--ASPHALT SHINGLE & COATING MATERIALS 156
17 325110--PETROCHEMICALS 648
18 325412--PHARMACEUTICAL PREPARATIONS 13,633
19 325520--ADHESIVES 817
20 325910--PRINTING INKS 512
21 325992--PHOTO FILMS, PAPERS, PLATES & CHEMICALS 2,790
22 326199--ALL OTHER PLASTICS PRODUCTS 7,495
23 327410--LIME & CALCINED DOLOMITE 12
24 331311--ALUMINA REFINING 332
25 331411--PRIMARY SMELTING & REFINING OF COPPER 398
26 332322--SHEET METAL WORKS 58
27 332420--METAL TANKS (HEAVY GAUGE) 383
28 332992--SMALL ARMS AMMUNITION 1,304
29 333220--PLASTICS & RUBBER INDUSTRY MACHINERY 998
30 333292--TEXTILE MACHINERY 741
31 333294--FOOD PRODUCT MACHINERY 724
32 333512--MACHINE TOOLS (METAL CUTTING TYPES) 1,767
33 333514--SPECIAL DIES/TOOLS, DIE SETS, JIGS & FIXTURES 439
34 333995--FLUID POWER CYLINDERS & ACTUATORS 193
35 333999--OTH MISC GENERAL PURPOSE MACHINERY 9,457
36 334111--ELECTRONIC COMPUTERS 7,969
37 334417--ELECTRONIC CONNECTORS 2,484
38 334418--PRINTED CIRCUIT ASSEMBLIES (ELECTRONIC ASSEMBLIES) 1,146
39 335929--COMMUNICATION & ENERGY WIRE, NESOI 2,276
40 336111--AUTOS & LIGHT DUTY MOTOR VEHICLES, INCL CHASSIS 22,299
41 336330--MOTOR VEHICLE STEERING & SUSPENSION PARTS 1,257
42 336350--MOTOR VEHICLE TRANSMISSION & POWER TRAIN PARTS 4,486
43 336370--MOTOR VEHICLE METAL STAMPINGS 1,592
44 336411--AIRCRAFT 24,231
45 336991--MOTORCYCLES, BICYCLES & PARTS 1,182
46 337214--OFFICE FURNITURE (EXCEPT WOOD) 148
47 339914--COSTUME JEWELRY & NOVELTIES 160
48 339920--SPORTING & ATHLETIC GOODS 1,936
49 339941--PENS & MECHANICAL PENCILS 243
50 910000--WASTE AND SCRAP 6,564

Please use this google drive link to download the answer file.       

https://drive.google.com/file/d/1TcBhCJMQoTU1hA3C_3udodAmV0pDCxwX/view?usp=sharing

Note: If you have any trouble in viewing/downloading the answer from the given link, please use this below guide to understand the whole process. 

https://helpinhomework.org/blog/how-to-obtain-answer-through-google-drive-link