Name For all problem you need to show me your work ON A SEP

Name: ______________________________ For all problem you need to show me your work, ON A SEPARATE PAGE. Problem 3 You are a distributor of outdoor picnic furniture (benches, picnic tables, litter receptacles, etc.). You want to understand the attributes of customers that are correlated with profit per customer. The possible attributes include: Whether they order on the web site or call in their orders (WebYN = 1 for web site ordering, 0 if they call in orders) Whether they are located in a coastal or inland state (CoastalState = 1 for located in a state bordering an ocean or gulf, 0 for inland) How much sun the state this customer is in receives (SunPct) How many employees in the company (EmpCount) The average income of the zip code that this customer is located within (ZipInc) The population of the zip code that this customer is located within (ZipPop) Problem 3: Create a multiple regression model with all six attributes (WebYN, CoastalState, SunPct, EmpCount, ZipInc and ZipPop) 1. Write out the regression equation 2. How much variation is explained by the regression equation (answer in %)? Is this good or bad, and how would you use this information?

Here is the data set

Solution