Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Pollution.csv dataset provides age-adjusted mortality rate per 100,000people for 60 locations. Additional climate and demographic information for each location is available as well. Please

The Pollution.csv dataset provides age-adjusted mortality rate per 100,000people for 60 locations. Additional climate and demographic information for each location is available as well. Please refer to the list below for attribute data types and summary attribute descriptions.

Your task for this question is to analyze this data set by using the WEKA program to answer the following:

A.)Perform K-means analysis using 5 clusters on this data. Attach screenshots of WEKA output. Interpret your summary of findings in a Word Document in multiple paragraphs.

B.) Perform a linear regression using WEKA software and Excel data analysis. Attach screen shots of relevant information and Interpret your summary of findings and linear regression output in a WORD Format.

POPULATION DATA SET DESCRIPTORS:

Precipitation: Average annual precipitation in inches JanuaryF: Average January temperature in degrees F JulyF: Average July temperature in degrees F Ovr65: % of population aged 65 or older Household: Average household size Education: Median school years completed by those over 22 Housing: % of housing units which are sound & with all facilities Density: Population per sq. mile in urbanized areas NonWhite: % non-white population in urbanized areas WhiteCollar: % employed in white collar occupations

LowIncome: % of families with income < $3000 HC: Relative hydrocarbon pollution potential NOX: Relative nitric oxides pollution potential SO2: Relative sulphur dioxide pollution potential Humidity: Annual average % relative humidity at 1pm Mortality: Total age-adjusted mortality rate per 100,000

Precipitation JanuaryF JulyF >65 Household Education Housing Density NonWhite WhiteCollar LowIncome HC NOX SO2 Humidity Mortality
36 27 71 8.1 3.34 11.4 81.5 3243 8.8 42.6 11.7 21 15 59 59 921.87
35 23 72 11.1 3.14 11 78.8 4281 3.5 50.7 14.4 8 10 39 57 997.875
44 29 74 10.4 3.21 9.8 81.6 4260 0.8 39.4 12.4 6 6 33 54 962.354
47 45 79 6.5 3.41 11.1 77.5 3125 27.1 50.2 20.6 18 8 24 56 982.291
43 35 77 7.6 3.44 9.6 84.6 6441 24.4 43.7 14.3 43 38 206 55 1071.289
53 45 80 7.7 3.45 10.2 66.8 3325 38.5 43.1 25.5 30 32 72 54 1030.38
43 30 74 10.9 3.23 12.1 83.9 4679 3.5 49.2 11.3 21 32 62 56 934.7
45 30 73 9.3 3.29 10.6 86 2140 5.3 40.4 10.5 6 4 4 56 899.529
36 24 70 9 3.31 10.5 83.2 6582 8.1 42.5 12.6 18 12 37 61 1001.902
36 27 72 9.5 3.36 10.7 79.3 4213 6.7 41 13.2 12 7 20 59 912.347
52 42 79 7.7 3.39 9.6 69.2 2302 22.2 41.3 24.2 18 8 27 56 1017.613
33 26 76 8.6 3.2 10.9 83.4 6122 16.3 44.9 10.7 88 63 278 58 1024.885
40 34 77 9.2 3.21 10.2 77 4101 13 45.7 15.1 26 26 146 57 970.467
35 28 71 8.8 3.29 11.1 86.3 3042 14.7 44.6 11.4 31 21 64 60 985.95
37 31 75 8 3.26 11.9 78.4 4259 13.1 49.6 13.9 23 9 15 58 958.839
35 46 85 7.1 3.22 11.8 79.9 1441 14.8 51.2 16.1 1 1 1 54 860.101
36 30 75 7.5 3.35 11.4 81.9 4029 12.4 44 12 6 4 16 58 936.234
15 30 73 8.2 3.15 12.2 84.2 4824 4.7 53.1 12.7 17 8 28 38 871.766
31 27 74 7.2 3.44 10.8 87 4834 15.8 43.5 13.6 52 35 124 59 959.221
30 24 72 6.5 3.53 10.8 79.5 3694 13.1 33.8 12.4 11 4 11 61 941.181
31 45 85 7.3 3.22 11.4 80.7 1844 11.5 48.1 18.5 1 1 1 53 891.708
31 24 72 9 3.37 10.9 82.8 3226 5.1 45.2 12.3 5 3 10 61 871.338
42 40 77 6.1 3.45 10.4 71.8 2269 22.7 41.4 19.5 8 3 5 53 971.122
43 27 72 9 3.25 11.5 87.1 2909 7.2 51.6 9.5 7 3 10 56 887.466
46 55 84 5.6 3.35 11.4 79.7 2647 21 46.9 17.9 6 5 1 59 952.529
39 29 75 8.7 3.23 11.4 78.6 4412 15.6 46.6 13.2 13 7 33 60 968.665
35 31 81 9.2 3.1 12 78.3 3262 12.6 48.6 13.9 7 4 4 55 919.729
43 32 74 10.1 3.38 9.5 79.2 3214 2.9 43.7 12 11 7 32 54 844.053
11 53 68 9.2 2.99 12.1 90.6 4700 7.8 48.9 12.3 648 319 130 47 861.833
30 35 71 8.3 3.37 9.9 77.4 4474 13.1 42.6 17.7 38 37 193 57 989.265
50 42 82 7.3 3.49 10.4 72.5 3497 36.7 43.3 26.4 15 18 34 59 1006.49
60 67 82 10 2.98 11.5 88.6 4657 13.5 47.3 22.4 3 1 1 60 861.439
30 20 69 8.8 3.26 11.1 85.4 2934 5.8 44 9.4 33 23 125 64 929.15
25 12 73 9.2 3.28 12.1 83.1 2095 2 51.9 9.8 20 11 26 58 857.622
45 40 80 8.3 3.32 10.1 70.3 2682 21 46.1 24.1 17 14 78 56 961.009
46 30 72 10.2 3.16 11.3 83.2 3327 8.8 45.3 12.2 4 3 8 58 923.234
54 54 81 7.4 3.36 9.7 72.8 3172 31.4 45.5 24.2 20 17 1 62 1113.156
42 33 77 9.7 3.03 10.7 83.5 7462 11.3 48.7 12.4 41 26 108 58 994.648
42 32 76 9.1 3.32 10.5 87.5 6092 17.5 45.3 13.2 29 32 161 54 1015.023
36 29 72 9.5 3.32 10.6 77.6 3437 8.1 45.5 13.8 45 59 263 56 991.29
37 38 67 11.3 2.99 12 81.5 3387 3.6 50.3 13.5 56 21 44 73 893.991
42 29 72 10.7 3.19 10.1 79.5 3508 2.2 38.8 15.7 6 4 18 56 938.5
41 33 77 11.2 3.08 9.6 79.9 4843 2.7 38.6 14.1 11 11 89 54 946.185
44 39 78 8.2 3.32 11 79.9 3768 28.6 49.5 17.5 12 9 48 53 1025.502
32 25 72 10.9 3.21 11.1 82.5 4355 5 46.4 10.8 7 4 18 60 874.281
34 32 79 9.3 3.23 9.7 76.8 5160 17.2 45.1 15.3 31 15 68 57 953.56
10 55 70 7.3 3.11 12.1 88.9 3033 5.9 51 14 144 66 20 61 839.709
18 48 63 9.2 2.92 12.2 87.7 4253 13.7 51.2 12 311 171 86 71 911.701
13 49 68 7 3.36 12.2 90.7 2702 3 51.9 9.7 105 32 3 71 790.733
35 40 64 9.6 3.02 12.2 82.5 3626 5.7 54.3 10.1 20 7 20 72 899.264
45 28 74 10.6 3.21 11.1 82.6 1883 3.4 41.9 12.3 5 4 20 56 904.155
38 24 72 9.8 3.34 11.4 78 4923 3.8 50.5 11.1 8 5 25 61 950.672
31 26 73 9.3 3.22 10.7 81.3 3249 9.5 43.9 13.6 11 7 25 59 972.464
40 23 71 11.3 3.28 10.3 73.8 1671 2.5 47.4 13.5 5 2 11 60 912.202
41 37 78 6.2 3.25 12.3 89.5 5308 25.9 59.7 10.3 65 28 102 52 967.803
28 32 81 7 3.27 12.1 81 3665 7.5 51.6 13.2 4 2 1 54 823.764
45 33 76 7.7 3.39 11.3 82.2 3152 12.1 47.3 10.9 14 11 42 56 1003.502
45 24 70 11.8 3.25 11.1 79.8 3678 1 44.8 14 7 3 8 56 895.696
42 33 76 9.7 3.22 9 76.2 9699 4.8 42.2 14.5 8 8 49 54 911.817
38 28 72 8.9 3.48 10.7 79.8 3451 11.7 37.5 13 14 13 39 58 954.442

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Law Text and Cases

Authors: Kenneth Clarkson, Roger LeRoy Miller, Frank Cross

13th edition

1285185242, 978-1285185248

More Books

Students also viewed these Law questions

Question

Differentiate between inventoriable costs and period costs

Answered: 1 week ago