You can use Word, Excel, Power Point and SAS to answer the questions in this exam. There are a total of six (6) 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 so that each step is clearly explained.
Combine all your answers/files into a single zipped file and post the zipped file to “HW_Final_Exam”in CANVAS.
- Using the SAS “income_byzip_NJNY_metro” dataset form 5 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 hclust).
(15 points)
Stevens is planning to compare the economic activities of Hoboken businesses in zip code 07030 to the other zip codes in the New Jersey-New York area. Based on population income distribution, which zip codes are similar to 07030? Why?
- Repeat the above analysis using Kmeans.
Stevens is planning to compare the economic activities of Hoboken businesses in zip code 07030 to the other zip codes in the New Jersey-New York area. Based on population income distribution, which zip codes are similar to 07030? Why?
(15 points)
The following table shows the results of the conjoint analysis on three brands of cars.
| Intercept | 9.5 |
| Brand Cruise | 0.6667 |
| Brand Tesla | 5 |
| Brand Zoox | -5.6667 |
| Price $60,000 | 0.1667 |
| Price $70,000 | -1.1667 |
| Price $80,000 | 1 |
| Fuel_Type Electric | -0.9444 |
| Fuel_Type Hybrid | 0.9444 |
Perform the following analysis for:
3) Tradeoff analysis between price and fuel type (15 points)
| Brand | Fuel Type | Price |
| Tesla | Electric | $60,000 |
| Tesla | Hybird | $60,000 |
- Market share analysis for the following Market definition (15 points):
| Brand | Fuel Type | Price |
| Cruise | Electric | $70,000 |
| Tesla | Electric | $70,000 |
| Zoox | Electric | $70,000 |
- Relative importance of the features (15 points):
- Using the “Sales” dataset in CANVAS, develop price elasticity models for quantity vs. price and logquant vs. logprice (log-log model) (25 points).
The post SAS programs should be commented appeared first on My Assignment Online.
