In: Statistics and Probability
Instructions: • Use the data sets, the length of major North America rivers, at end of this page and answer the following questions from 1 through to 10. • Do all your calculation and graphs on Excel spreadsheet, make sure that you give the title of each graph and identify axises. • Copy and paste your table and graphs in a word document. Explain your finding in a paragraph form.
Questions:
1. Organize the data set I with seven classes. Find frequency distribution that contains frequency, midpoints, class boundaries, relative frequency and cumulative frequency for the data set. Answer the following questions.
2. Make a Frequency Histogram. What is the shape of the distributions?
3. Graph frequency polygon, pie chart, bar graph and Ogive.
4. Find the mean, median and standard deviation of the data set.
5. Find the range in which at least 75% of data will lie. Use Chebyshev’s Theorem.
6. Is it possible to find a range that approximately 68% of data set fall in
7. Find the length of river that corresponds to the 45th percentile.
8. Find the length of river that corresponds to the 20th percentile.
9. Make a box and whisker graph. 1
10. The mean of the lengths of rivers on the South Island of New Zealand that flow to the Pacific Ocean is 131 kilometers with a standard deviation of 80 kilometers. Which data set is more consistent either the length of the South Island of New Zealand or the length of North America rivers?(varies less)
DATA SET
The length (in miles) of Major North American Rivers 729 610 325 392 524 1459 450 465 605 330 950 906 329 290 1000 600 1450 862 532 890 407 525 720 1243 850 649 730 352 390 420 710 340 693 306 250 470 724 332 259 2340 560 1060 774 332 3710 315 2540 618 1171 460 431 800 605 410 1310 500 790 531 981 460 926 375 1290 1210 1310 383 380 300 310 411 1900 434 420 545 569 425 800 865 380 445 538 1038 424 350 377 540 659 652 314 360 301 512 500 313 610 360 430 682 886 447 338 485 625 722 525 800 309 435
answers from 5 to 10 are not responded,
could I see them pls
SN | x | Freq | Cumulative frequency |
1 | 250 | 1 | 1 |
2 | 259 | 1 | 2 |
3 | 290 | 1 | 3 |
4 | 300 | 1 | 4 |
5 | 301 | 1 | 5 |
6 | 306 | 1 | 6 |
7 | 309 | 1 | 7 |
8 | 310 | 1 | 8 |
9 | 313 | 1 | 9 |
10 | 314 | 1 | 10 |
11 | 315 | 1 | 11 |
12 | 325 | 1 | 12 |
13 | 329 | 1 | 13 |
14 | 330 | 1 | 14 |
15 | 332 | 2 | 16 |
16 | 338 | 1 | 17 |
17 | 340 | 1 | 18 |
18 | 350 | 1 | 19 |
19 | 352 | 1 | 20 |
20 | 360 | 2 | 22 |
21 | 375 | 1 | 23 |
22 | 377 | 1 | 24 |
23 | 380 | 2 | 26 |
24 | 383 | 1 | 27 |
25 | 390 | 1 | 28 |
26 | 392 | 1 | 29 |
27 | 407 | 1 | 30 |
28 | 410 | 1 | 31 |
29 | 411 | 1 | 32 |
30 | 420 | 2 | 34 |
31 | 424 | 1 | 35 |
32 | 425 | 1 | 36 |
33 | 430 | 1 | 37 |
34 | 431 | 1 | 38 |
35 | 434 | 1 | 39 |
36 | 435 | 1 | 40 |
37 | 445 | 1 | 41 |
38 | 447 | 1 | 42 |
39 | 450 | 1 | 43 |
40 | 460 | 2 | 45 |
41 | 465 | 1 | 46 |
42 | 470 | 1 | 47 |
43 | 485 | 1 | 48 |
44 | 500 | 2 | 50 |
45 | 512 | 1 | 51 |
46 | 524 | 1 | 52 |
47 | 525 | 2 | 54 |
48 | 531 | 1 | 55 |
49 | 532 | 1 | 56 |
50 | 538 | 1 | 57 |
51 | 540 | 1 | 58 |
52 | 545 | 1 | 59 |
53 | 560 | 1 | 60 |
54 | 569 | 1 | 61 |
55 | 600 | 1 | 62 |
56 | 605 | 2 | 64 |
57 | 610 | 2 | 66 |
58 | 618 | 1 | 67 |
59 | 625 | 1 | 68 |
60 | 649 | 1 | 69 |
61 | 652 | 1 | 70 |
62 | 659 | 1 | 71 |
63 | 682 | 1 | 72 |
64 | 693 | 1 | 73 |
65 | 710 | 1 | 74 |
66 | 720 | 1 | 75 |
67 | 722 | 1 | 76 |
68 | 724 | 1 | 77 |
69 | 729 | 1 | 78 |
70 | 730 | 1 | 79 |
71 | 774 | 1 | 80 |
72 | 790 | 1 | 81 |
73 | 800 | 3 | 84 |
74 | 850 | 1 | 85 |
75 | 862 | 1 | 86 |
76 | 865 | 1 | 87 |
77 | 886 | 1 | 88 |
78 | 890 | 1 | 89 |
79 | 906 | 1 | 90 |
80 | 926 | 1 | 91 |
81 | 950 | 1 | 92 |
82 | 981 | 1 | 93 |
83 | 1000 | 1 | 94 |
84 | 1038 | 1 | 95 |
85 | 1060 | 1 | 96 |
86 | 1171 | 1 | 97 |
87 | 1210 | 1 | 98 |
88 | 1243 | 1 | 99 |
89 | 1290 | 1 | 100 |
90 | 1310 | 2 | 102 |
91 | 1450 | 1 | 103 |
92 | 1459 | 1 | 104 |
93 | 1900 | 1 | 105 |
94 | 2340 | 1 | 106 |
95 | 2540 | 1 | 107 |
96 | 3710 | 1 | 108 |
Answer(9): The Box and whisker plot is as below:
I hope I have made it clear, if you any doubt please ask in comment section.