Search for question
Question

Part 2: You are a data analyst and have been tasked with determining whether residents of the state of Montana should expect the economic outlook for their state to be better than it was a year ago. You will use the "Poll" dataset to help you make this determination. The dataset contains demographic information from respondents along with information about their financial status. Additionally, the website includes the coding for dataset variables. For the STAT field, "0" indicates the state economic outlook will be better than a year ago, while a "1" indicates that the state economic outlook will not be better than it was a year ago. Provide a histogram of the STAT field. Then, perform an association analysis using the Apriori algorithm; use the KNIME Association Rule Learner node to perform the analysis. Experiment with the minimum confidence and minimum support settings in this node in order derive meaningful association rules. Note that we are only interested in rules in which STAT is the consequent. Note that a "Create Collection Column" node needs be placed between the Excel Reader node and the Association Rule Learner node. In the Create Collection Column node settings, ensure that the following boxes are checked: Create a collection of type 'set' (doesn't store duplicate values) ignore missing values Remove aggregated columns from table Also, ensure that all fields in the dataset are shown in the "Include" portion of the dialog box./nUse a Table node to see the derived association rules. In a 250-500-word summary, address the following: 1. Explain your approach to the problem. 2. Include screenshots of the histogram results of the STAT field and the Table node screen results of the derived association rules. Ensure that the rules are sorted by Lift, in descending order. 3. Interpret the relevant derived association rules by describing how you would explain the rules to someone who is unfamiliar with analytics techniques. 4. Summarize your overall conclusion about the data based upon the results of the analysis. Note that you are required to submit the completed KNIME *.knwf file to your instructor. Specifically, export your KNIME model to a KNIME workflow file. To perform this task in KNIME, ensure that your KNIME model is active (i.e., displayed). Then, go to File -> Export KNIME Workflow. In the "Destination workflow file name (.knwf)" area, browse to a specific location on your computer. Click "Save" and then click "Finish." Submit the Excel file, Word document, and the KNIME *.knwf workflow file.

Fig: 1

Fig: 2