Help to code the following on R-Script:

Pharmaceutical Industry. An equities analyst is studying the pharmaceutical industry and would like your help in exploring and understanding the financial data collected by her firm. Her main objective is to understand the structure of the pharmaceutical industry using some basic financial measures.

Financial data gathered on 21 firms in the pharmaceutical industry are available in the file Pharmaceuticals.csv. For each firm, the following variables are recorded:

1. Market capitalization (in billions of dollars) 2. Beta 3. Price/earnings ratio 4. Return on equity 5. Return on assets 6. Asset turnover 7. Leverage 8. Estimated revenue growth 9. Net profit margin 10. Median recommendation (across major brokerages) 11. Location of firm's headquarters 12. Stock exchange on which the firm is listed

Use cluster analysis to explore and analyze the given dataset as follows:

1 - Use only the numerical variables (1 to 9) to cluster the 21 firms. Justify the various choices made in conducting the cluster analysis, such as weights for different variables, the specific clustering algorithm(s) used, the number of clusters formed, and so on.

2 - Interpret the clusters with respect to the numerical variables used in forming the clusters. 3 - Is there a pattern in the clusters with respect to the categorical variables (10 to 12)? (those not used in forming the clusters) 4 - Provide an appropriate name for each cluster using any or all of the variables in the dataset.

A B C D E F G H K M N Symbol Name Market_Cap Beta PE_Ratio ROE ROA Asset_Turnover Leverage Rev_Growth Net_Profit_Margin Median_Recommendation Location Exchange 2 ABT Abbott Lat 68.44 0.32 24.7 26.4 11.8 0.7 0.42 7.54 16.1 Moderate Buy US NYSE 3 AGN Allergan, I 7.58 0.41 82.5 12.9 5.5 0.9 0.6 9.16 5.5 Moderate Buy CANADA NYSE 4 AHM Amershan 6.3 0.46 20.7 14.9 7.8 0.9 0.27 7.05 11.2 Strong Buy UK NYSE 5 AZN AstraZene 67.63 0.52 21.5 27.4 15.4 0.9 15 18 Moderate Sell UK NYSE 6 AVE Aventis 47.16 0.32 20.1 21.8 7.5 0.6 0.34 26.81 12.9 Moderate Buy FRANCE NYSE 7 BAY Bayer AG 16.9 1.11 27.9 3.9 1.4 0.6 -3.17 2.6 Hold GERMANY NYSE 8 BMY Bristol-My 51.33 0.5 13.9 34.8 15.1 0.9 0.57 2.7 20.6 Moderate Sell US NYSE 9 CHIT Chattem, I 0.41 0.85 26 24.1 4,3 0.6 3.51 6.38 7.5 Moderate Buy US NASDAQ 10 ELN Elan Corp .78 1.08 3.6 15.1 5.1 0.3 1.07 34.21 13.3 Moderate Sell IRELAND NYSE 11 LLY Eli Lilly an 73.84 0.18 27.9 31 13.5 0.6 0.53 6.21 23.4 Hold US NYSE 12 GSK GlaxoSmit 122.11 0.35 18 62.9 20.3 0.34 21.87 21.1 Hold UK NYSE 13 IVX IVAX Corp 2.6 0.65 19.9 21.4 6.8 0.6 1.45 13.99 11 Hold US AMEX 14 JNJ Johnson & 173.93 0.46 28.4 28.6 16.3 0.9 0.1 9.37 17.9 Moderate Buy US NYSE 15 MRX Medicis PI 1.2 0.75 28.6 11.2 5.4 0.3 0.93 30.37 21.3 Moderate Buy US NYSE 16 MRK Merck & C 132.56 0.46 18.9 40.6 15 1.1 0.28 17.35 14.1 Hold US NYSE 17 NVS Novartis A 96.65 0.19 21.6 17.9 11.2 0.5 0.06 -2.69 22.4 Hold SWITZERL NYSE 18 PFE Pfizer Inc 199.47 0.65 23.6 5.6 19.2 0.8 0.16 25.54 25.2 Moderate Buy US NYSE 19 PHA Pharmaci 56.24 0.4 56.5 13.5 5.7 0.6 0.35 15 7.3 Hold US NYSE 20 SGP Schering-I 34.1 0.51 18.9 22.6 13.3 0.8 8.56 17.6 Hold US NYSE 21 WPI Watson PI 3.26 0.24 18.4 10.2 6.8 0.5 0.2 29.18 15.1 Moderate Sell US NYSE 22 WYE Wyeth 48.19 0.63 13.1 54.9 13.4 0.6 1.12 0.36 25.5 Hold US NYSE 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37