solved For this assignment you will be using Modeler to re-create
For this assignment you will be using Modeler to re-create the stream pictured below and write a brief interpretation of the results.Create a stream that:Imports data from the MS Excel file ‘demo_data_working_with_modeler.xls.’Outputs a Table and a Data AuditSelects records from the imported Excel file with two different parameters (male and female). Page 2-11 explains the select node which can be used to select women or men for the analysis. Be sure to go to Settings and select “Include†and remember that Select is case sensitive. So in the Formula section, put GENDER = “FEMALE” or GENDER = “MALE” to selectCreates a Statistical analysis for the two continuous variables, age and dropped calls, by gender.Creates a Histogram graph showing, for males and females separately, their age by whether or not they have churned.Use Annotation Fields to label your work.Write a brief interpretation of the results. What does the data in the table tell you? How do you interpret the data audit? How do men and women differ by age, number of dropped calls and whether or not they churn? Can you make recommendations to the telecommunications company in this example based on these results?Data file:demo_data_working_with_modeler.xlsxYou will be submitting a Word file which will include a screen capture of your stream as well as a 2-3 paragraph interpretation of the results.Submit your assignment as a Word document.Including visuals (graphs, tables, etc.) your paper should not exceed 2 (two) pages. Please use APA style, including Times New Roman font, 12 pt., double-spaced.