The purpose of this assignment is to employ data editing and descriptive analysis techniques.Please Note: You will be developing and implementing a Marketing Research Project throughout the course culminating in a Market Research Report and Presentation in Week 8. The focus of the project will be on collecting, analyzing, and presenting data and information about a current marketing problem faced by a real business. Through a series of four assignments, you will identify your research problem and associated objectives, design a survey and conduct data collection, and you will prepare and analyze the data using Microsoft Excel. You will use a process described in the text (Burns and Bush, Basic Marketing Research, 3rd Ed.). Refer to the text, pages 49 to 56, for a description of the steps to the Marketing Research Process.The following Assignments will comprise the majority of the information needed to complete your Market Research Report:Topic 2 Writing Assignment: Research Problem and ObjectivesTopic 4 Writing Assignment: Survey DesignTopic 5 Paper: Collecting DataTopic 7 Paper: Data AnalysisTo begin this assignment, you must first compile your survey data (responses to the questions from the survey you designed in Week 4) into a spreadsheet for data editing and preparation for descriptive analysis techniques. For the purposes of our class, we are not going to conduct an actual survey, rather we will be "simulating" the responses.Don't sweat or overthink this. To Simulate your survey responses, we will be using a sample size of 384 (the magic number from our sample size calculator). This means that you will have 384 responses to each question. If you still have open-ended questions in your survey, this would be a good time to modify them into scaled-response questions (it will make this assignment and the Market Research Report much simpler to work with). To "simulate" these responses, your "most likely" response will be the most common answer (use logic when you simulate your responses). You should have a few some outliers, but nothing too crazy. Use the following as an example: What is your age?25 or younger (20 responses)26 to 35 (85 responses)36 to 45 (174 responses)46 to 55 (80 responses)56 or older (25 responses)Create a spreadsheet table for each question and its responses (and the counts). Now you have the data available to apply data editing and analysis techniques to complete the assignment.DO NOT submit your Spreadsheet. Instead, you will copy the tables and analyses created in your spreadsheet into tables and include them as an appendix at the end of this paper.Then write a 1,000-1,200 Word Description following APA Style addressing the following criteria:Description of the data editing techniques used.Explanation of the results for each variable in the spreadsheet using descriptive analysis techniques. Use appropriate tables and charts for each variable.Explanation of the results for each inferential analysis technique to determine generalizations from the sample to the population. Describe how hypothesis testing was used in this data collection and how it advances the accomplishment of the research objectives.Explanation of the results for each inferential analysis technique to determine differences between groups in the sample, or the percentages or means of two or more variables (two sample test of means, Chi-square test, or ANOVA). Describe how hypothesis testing was used in this data collection and how it advances the accomplishment of the research objectives.Explanation of the results for each inferential analysis technique to determine relationships between or among variables (correlation or regression analysis). Describe how hypothesis testing was used in this data collection and how it advances the accomplishment of the research objectives.Your Description must include at least 2 Scholarly References (and associated in-text citations) from sources such as trade journals, academic journals, and websites from professional marketing associations (including the course text).Prepare this assignment according to the APA guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.This assignment uses a rubric and has a template, along with a spreadsheet. Please review the rubric, template, and spreadsheet prior to beginning the assignment to become familiar with the expectations for successful completion.Additional Note: In-text citations MUST BE USED and have corresponding references in accordance with APA Style rules! Generally speaking, most every paragraph should have At Least one in-text citation. Remember, this assignment should reference and cite at least 2 Scholarly Sources (one should be the course text).Wikipedia IS NOT a scholarly source and is an inappropriate reference for 400-Level College writing.A Note on Direct Quotes: This is a Senior-level class. Direct quotes should be used sparingly (only when absolutely necessary to maintain the original meaning). Paraphrasing (with in-text citations) is preferred as this substantiates your thoughts and ideas while demonstrating your ability to analyze and evaluate the information you are researching and still credits your sources (vs. your ability to copy and paste).

the excel spreadsheets have to be done on a windows computer and follow the directions that are listed.