Sales Case Analyze the Pharmdata data | My Assignment Tutor

Prescription Drug Sales Case Analyze the Pharmdata data.. DATA Pharmacy Sales Floor Space Prescription Pct Parking Income Shopping Center 1 22 4900 9 40 18 Yes 2 19 5800 10 50 20 Yes 3 24 5000 11 55 17 Yes 4 28 4400 12 30 19 No 5 18 3850 13 42 10 No 6 21 5300 15 20 22 Yes 7 29 4100 20 25 8 No 8 15 4700 22 60 15 Yes 9 12 5600 24 45 16 Yes 10 14 4900 27 82 14 Yes 11 18 3700 28 56 12 No 12 19 3800 31 38 8 No 13 15 2400 36 35 6 No 14 22 1800 37 28 4 No 15 13 3100 40 43 6 No 16 16 2300 41 20 5 No 17 8 4400 42 46 7 Yes 18 6 3300 42 15 4 No 19 7 2900 45 30 9 Yes 20 17 2400 46 16 3 No Above is a copy of the data that is in the Excel file called PreSales. Each row represents one pharmacy store, where: Sales: average weekly prescription sales over the past year (in units of $1000) Floor Space: total floor space (in square feet) Pct: % of floor space allocated to the prescription department Parking: # of parking spaces available to the store Income: the weekly per capita income for the surrounding community (in units of $100) Shopping Center: Yes—located in a shopping center; No—it is not located in a shopping center Assignment Analyze this data, i.e., calculate descriptive statistics–mean, standard deviation, and so on, and create tables and graphs. WARNING: Before starting, develop a “game plan” to analysis the data, i.e., ask yourself what is the goal of your analysis. The goal should be to identify (grade/sort/rank) the pharmacies. The managerial report should summarize the results of your analysis. Look at the Case Guidelines document. The report should only contain the key statistical information, in non-technical terms. Try to include tables, figures, graphs as part of the report. AND talk to the graphs/figures/tables–i.e., what is in them that’s so important?? Use bullets!! Include the other frequency distributions, descriptive statistics not in the report in an appendix. Can you please show me the analytics work in excel and a few bullet points on what it means? I want to understand how to do a similar assignment on my own. Thanks!!