statistics project

profileadmiration
new.zip
Home>Mathematics homework help>statistics project

New folder/data.xlsx

Sheet1

Forest Areaofwatershed IBI ns dbh groupnum ns dbh groupnum ew dbh groupnum Variety Length GroupNum
0 21 47 n 27.8 1 n 27.8 1 e 23.5 3 bihai 47.12 1
0 29 61 n 14.5 1 n 14.5 1 e 43.5 3 bihai 46.75 1
0 31 39 n 39.1 1 n 39.1 1 e 6.6 3 bihai 46.81 1
0 32 59 n 3.2 1 n 3.2 1 e 11.5 3 bihai 47.12 1
0 34 72 n 58.8 1 n 58.8 1 e 17.2 3 bihai 46.67 1
0 34 76 n 55.5 1 n 55.5 1 e 38.7 3 bihai 47.43 1
3 49 85 n 25 1 n 25 1 e 2.3 3 bihai 46.44 1
3 52 89 n 5.4 1 n 5.4 1 e 31.5 3 bihai 46.64 1
7 2 74 n 19 1 n 19 1 e 10.5 3 bihai 48.07 1
8 70 89 n 30.6 1 n 30.6 1 e 23.7 3 bihai 48.34 1
9 6 33 n 15.1 1 n 15.1 1 e 13.8 3 bihai 48.15 1
10 28 46 n 3.6 1 n 3.6 1 e 5.2 3 bihai 50.26 1
10 21 32 n 28.4 1 n 28.4 1 e 31.5 3 bihai 50.12 1
11 59 80 n 15 1 n 15 1 e 22.1 3 bihai 46.34 1
14 69 80 n 2.2 1 n 2.2 1 e 6.7 3 bihai 46.94 1
17 47 78 n 14.2 1 n 14.2 1 e 2.6 3 bihai 48.36 1
17 8 53 n 44.2 1 n 44.2 1 e 6.3 3 red 41.9 2
18 8 43 n 25.7 1 n 25.7 1 e 51.1 3 red 42.01 2
21 58 88 n 11.2 1 n 11.2 1 e 5.4 3 red 41.93 2
22 54 84 n 46.8 1 n 46.8 1 e 9 3 red 43.09 2
25 10 62 n 36.9 1 n 36.9 1 e 43 3 red 41.47 2
31 57 55 n 54.1 1 n 54.1 1 e 8.7 3 red 41.69 2
32 18 29 n 10.2 1 n 10.2 1 e 22.8 3 red 39.78 2
33 19 29 n 2.5 1 n 2.5 1 e 2.9 3 red 40.57 2
33 39 54 n 13.8 1 n 13.8 1 e 22.3 3 red 39.63 2
33 49 78 n 43.5 1 n 43.5 1 e 43.8 3 red 42.18 2
39 9 71 n 13.8 1 n 13.8 1 e 48.1 3 red 40.66 2
41 5 55 n 39.7 1 n 39.7 1 e 46.5 3 red 37.87 2
43 14 58 n 6.4 1 n 6.4 1 e 39.8 3 red 39.16 2
43 9 71 n 4.8 1 n 4.8 1 e 10.9 3 red 37.4 2
47 23 33 s 44.4 2 s 44.4 2 w 17.2 4 red 38.2 2
49 31 59 s 26.1 2 s 26.1 2 w 44.6 4 red 38.07 2
49 18 81 s 50.4 2 s 50.4 2 w 44.1 4 red 38.1 2
52 16 71 s 23.3 2 s 23.3 2 w 35.5 4 red 37.97 2
52 21 75 s 39.5 2 s 39.5 2 w 51 4 red 38.79 2
59 32 64 s 51 2 s 51 2 w 21.6 4 red 38.23 2
63 10 41 s 48.1 2 s 48.1 2 w 44.1 4 red 38.87 2
68 26 82 s 47.2 2 s 47.2 2 w 11.2 4 red 37.78 2
75 9 60 s 40.3 2 s 40.3 2 w 36 4 red 38.01 2
79 54 84 s 37.4 2 s 37.4 2 w 42.1 4 yellow 36.78 3
79 12 83 s 36.8 2 s 36.8 2 w 3.2 4 yellow 37.02 3
80 21 82 s 21.7 2 s 21.7 2 w 25.5 4 yellow 36.52 3
86 27 82 s 35.7 2 s 35.7 2 w 36.5 4 yellow 36.11 3
89 23 86 s 32 2 s 32 2 w 39 4 yellow 36.03 3
90 26 79 s 40.4 2 s 40.4 2 w 25.9 4 yellow 35.45 3
95 16 67 s 12.8 2 s 12.8 2 w 20.8 4 yellow 38.13 3
95 26 56 s 5.6 2 s 5.6 2 w 3.2 4 yellow 37.1 3
100 26 85 s 44.3 2 s 44.3 2 w 57.7 4 yellow 35.17 3
100 28 91 s 52.9 2 s 52.9 2 w 43.3 4 yellow 36.82 3
s 38 2 s 38 2 w 58 4 yellow 36.66 3
s 2.6 2 s 2.6 2 w 21.7 4 yellow 35.68 3
s 44.6 2 s 44.6 2 w 35.6 4 yellow 36.03 3
s 45.5 2 s 45.5 2 w 30.9 4 yellow 34.57 3
s 29.1 2 s 29.1 2 w 40.6 4 yellow 34.63 3
s 18.7 2 s 18.7 2 w 30.7 4
s 7 2 s 7 2 w 35.6 4
s 43.8 2 s 43.8 2 w 18.2 4
s 28.3 2 s 28.3 2 w 2.9 4
s 36.9 2 s 36.9 2 w 20.4 4
s 51.6 2 s 51.6 2 w 11.4 4
e 23.5 3 e 23.5 3
e 43.5 3 e 43.5 3
e 6.6 3 e 6.6 3
e 11.5 3 e 11.5 3
e 17.2 3 e 17.2 3
e 38.7 3 e 38.7 3
e 2.3 3 e 2.3 3
e 31.5 3 e 31.5 3
e 10.5 3 e 10.5 3
e 23.7 3 e 23.7 3
e 13.8 3 e 13.8 3
e 5.2 3 e 5.2 3
e 31.5 3 e 31.5 3
e 22.1 3 e 22.1 3
e 6.7 3 e 6.7 3
e 2.6 3 e 2.6 3
e 6.3 3 e 6.3 3
e 51.1 3 e 51.1 3
e 5.4 3 e 5.4 3
e 9 3 e 9 3
e 43 3 e 43 3
e 8.7 3 e 8.7 3
e 22.8 3 e 22.8 3
e 2.9 3 e 2.9 3
e 22.3 3 e 22.3 3
e 43.8 3 e 43.8 3
e 48.1 3 e 48.1 3
e 46.5 3 e 46.5 3
e 39.8 3 e 39.8 3
e 10.9 3 e 10.9 3
w 17.2 4 w 17.2 4
w 44.6 4 w 44.6 4
w 44.1 4 w 44.1 4
w 35.5 4 w 35.5 4
w 51 4 w 51 4
w 21.6 4 w 21.6 4
w 44.1 4 w 44.1 4
w 11.2 4 w 11.2 4
w 36 4 w 36 4
w 42.1 4 w 42.1 4
w 3.2 4 w 3.2 4
w 25.5 4 w 25.5 4
w 36.5 4 w 36.5 4
w 39 4 w 39 4
w 25.9 4 w 25.9 4
w 20.8 4 w 20.8 4
w 3.2 4 w 3.2 4
w 57.7 4 w 57.7 4
w 43.3 4 w 43.3 4
w 58 4 w 58 4
w 21.7 4 w 21.7 4
w 35.6 4 w 35.6 4
w 30.9 4 w 30.9 4
w 40.6 4 w 40.6 4
w 30.7 4 w 30.7 4
w 35.6 4 w 35.6 4
w 18.2 4 w 18.2 4
w 2.9 4 w 2.9 4
w 20.4 4 w 20.4 4
w 11.4 4 w 11.4 4

Sheet2

Sheet3

New folder/minitab file.MPJ