Using the SAS “income byzip njny metro” dataset, form seven clusters for Zip Codes based on the income distribution

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

You can use Word, Excel, PowerPoint, and SAS to answer the questions in this exam.  There are a total of five (5) multi-part questions, with point values noted for each question. 

Please show your calculations or the details of your program(s) for each problem. The SAS programs should be commented on so that each step is clearly explained.

Combine all your answers/files into a single zipped file and post the zipped file to “HW_Midterm” in CANVAS. 

1. Using the SAS “income_byzip_njny_metro” dataset, form seven clusters for Zip Codes based on the income distribution of the household.  For each Zip Code, use the percentage of tax filings (number of filings /total filings) in each “Adjusted Gross Income” category (agi_sub=1 to 6). (Use Kmeans).

Mike’s Falafel restaurant has been very successful at “MacDougal St, New York, NY 10012”. Mike is considering opening a new restaurant near Stevens Institute at “Washington Street, Hoboken, NJ 07030”. Based on your segmentation, do you think this is a good idea? Why? (20 points)

 2. Using the SAS “income_byzip_NJNY_metro” dataset, form seven clusters for Zip Codes based on the income distribution of the household.  For each Zip Code, use the percentage of tax filings (number of filings /total filings) in each “Adjusted Gross Income” category (agi_sub=1 to 6). (Use Hierarchical).

Mike falafel restaurant has been very successful at “MacDougal St, New York, NY 10012”. Mike is considering opening a new restaurant near Stevens at “Washington Street, Hoboken, NJ 07030”. Based on your segmentation, do you think this is a good idea? Why? (20 points)

The following table shows the results of the conjoint analysis on three brands of tires.

Perform the following analysis for:

3) Tradeoff analysis between price and hazard insurance  (20 points)

Brand	Price	Life	Hazard
GoodMonth	59.99	60,000	No
GoodMonth	59.99	60,000	Yes

 Market share analysis for the following Market definition (20 points)

Brand	Price	Life	Hazard
GoodMonth	99.99	70,000	Yes
Country	69.99	60,000	Yes
Micheal	59.99	50,000	No

5) Relative Importance analysis (20 points)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Brand: Brand of Tire

Price: Price per Tire

Life: Expected number of miles

Hazard: Include hazard insurance yes or no:

Data income_byzip_njny_metro

 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme