Reference no: EM131541727

Landscaping

A local landscaping company that provides lawn-mowing, trimming and general landscape duties wants to get a jump on its competitionby determining which houses in a section of town would best respond to marketing materials.

A measure of which homeowners to approach would include their income, size of their yard and compare that against historical data on which homes have had landscaping services.

You were able to dig up a random sample of 30 households, given in the file Landscaping.xls. Using Excel, create a scatter plot of Lot Size vs. Income, color coded by the outcome variable Yes/No.

Make sure to obtain a well-formatted plot (remove excessive background and gridlines; create legible labels and a legend, etc.). Hint: First sort the data by the outcome variable, and then plot the data for each category as separate series.

Create the same plot, this time using Tableau. Compare the two processes of generating the plot in terms of effort as well as the quality of the resulting plots. What are the advantages of each? Explain.

Attachment:- landscaping.rar