Help me answer this please please save me. it would mean a lot please

I DO NOT INTEND TO SUBMIT THE WORK AS MY WORK

Community = CMA {Census Metropolitan Area], City or Town preferred. Your company is about to launch a new, malor productfprogram. As the Marketing Manager, it is your responsibility to identify a suitable test market where the new application would have the best chance of success. This Community must haye a higher Eroentaggi} of your Primary Target Customers than the Canadian average. Assignment Requirements: 1. Company Assigned with short description [1,12 page] IN YOUR OWN WORDS. 2. Primary Target Customer: a. Full explanation of the Demographic criteria used {2 minimum] to describe your Primary Target Customer b. Reasoning why these criteria suit your Company 3. Based upon the criteria selected above, identify a Community that you feel is suitable for this test, and explain why it is a good t for your Primary Target Customer. a. The Community chosen must have a percentage [5131 higher than the Canadian national average, not simply a higher overall number of consumers in this group. b. Defend your choice by providing the suitable calculations {EXCEL}. 4. Include a screen shot of the appropriate Statistics Canada chartlsl Raw Data - for this Community in comparison to the Canadian average that supports your choice. Highlight the information you are using to support your recommendation. 5. Provide the EXCEL spreadsheet that shows how your analysis supports your choice (calculation of percentages your chosen Community E the Canadian ayerage}. Ensure your spreadsheet and all columns are properly labelled. 6. Cautions when choosing a Community or Demographic Criteria: a. Do not use Toronto, Vancouver or Montreal. You can use smaller Communities within these areas (ex/ Vaughan, Toronto Centre, Abbottsford). b. Do not use a comparison of the average Canadian population density (3.9 persons [KM squared). c. If you are using an Age Range as a Demographic criteria, ensure the range is not too wide (ex/ ages 15-64) or too restrictive (ex/ 20-24 years) to be useful. MKTG 207 - Using Statistics Canada Census Information Creating Documents needed to Support your Recommendation Part A: Statistics Canada Census 2016 Raw Data Tables: 1. To locate the Statistics Canada Census Profiles 2016: http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/index.cfm?Lang=EPart A: Statistics Canada Census 2016 Raw Data Tables: 1. To locate the Statistics Canada Census Profiles 2016: http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/index.cfm?Lang=E or Statistics Canada/Home/Census/2016 Census Profile 2. To find the Census information for the Community you are researching, enter its name in the Place Name box and hit the Search button. 3. The Community chosen will appear benchmarked to the next largest type of community, such as the Province it is located in. To change this benchmark to Canada, hit the 'Change Geography' button under the far right title box. Type Canada into the Place Name box and hit the Search button. Choose Canada (Map) and hit the Search button. Your report should now show your Community's Census information lined up with Canada's overall figures. 4. In order to support your recommended Community with Census statistics, you must provide a screen shot of the appropriate Census 2016 report of Raw Data, showing the factors you are comparing to the Canadian average (ex/ CMA-X is younger than the Canadian average, using the information showing the breakdown of residents by age group). Do not picture the entire report. Use the drop-down menu in the top left-hand corner titled 'Select a View' to go from 'All Data' to the characteristic you are referencing. Hit 'Select'.The characteristic groupings available are: Aboriginal Peoples/ Education/ Ethnic Origin/ Families, Households & Marital Status/Housing/Immigration & Citizenship/Income/Journey to Work/Labour/Language/Language of Work/Mobility/Population*/Visible Minorities *Population includes age characteristics. 5. The screen shots of the RAW DATA tables comparing the Community chosen to the Canadian average is a required component of your assignment. Print it off and include it in your submission. Highlight those stats that are key to your recommendation. MKTG 207 - Using Statistics Canada Census Information Part B: Exporting Statistics Canada Census Information into EXCEL: 6. In order to download this information into an EXCEL spreadsheet: a. In the top right hand corner, hit DOWNLOAD. b. Choose Option 1 with File format = CSV. c. When saving, change the format to 'EXCEL workbook'.Part B: ortin Statistics Canada Census Information into EXCEL: E. In order to download this information into an EXCEL spreadsheet: a. In the top right hand corner, hit DOWN LOAD. b. Choose Option 1 with File format = CSV. c. When saying, change the format to \"EXCEL workbook'. 1 Using the information provided in the EXCEL spreadsheet that you haye built, support your recommendation that the CMAICity you have chosen would be a suitable test area for the product being tested. This means that for the criterials] you haye chosen, the CMAfCity has a higher 55 to total population of the characteristic you are looking for. 3. Ensure your EXCEL spreadsheet is properly labelled and easy to read. 9. This EXCEL spread sheet with your calculations supporting your reoommendation is a required component of your assignment. Print it off and include it in your submission. Dverall Professional Presentation including Bibliography = 1.0 marks Company Description + Description of Primary Target Customer = 1.0 marks Selection of Community [incl Rationale comparison to CD" averages! marks Statistics Canada Report [screen shots of Raw data tables] = 1.0 marks Excel Spreadsheet = 1.0 marks Assignment Presentation Requirements: - All reporu must include a tide page including: 0 Company Name, the name and section of this course, title of the assignment, Instructor's name, Student Name and Number, Due date. I This assignment requires students to analyze an actual company operating in Canada. At no time should a student use corporate materials without proper citations. In All reports must include a bibliography, listing all sources of information used. A regrt handed in without a bibliography will not be marked. Ir All reports must be submitted in soft copy using the Assignment Sheet provided on Blackboard. Assignments must be submitted by midnight of the due date provided