Basic Marketing Research with Excel 3rd Edition by Alvin Burns,Ronald Bush

Exercise 4

Your Integrated Case
Advanced Automobile Concepts: Making a PowerPoint Presentation
Cory Rogers completed the report for Advanced Automobile Concepts. He decided he wanted to make some PowerPoint slides to use in his presentation of the findings. Working in Word, he wrote a title to his presentation: Advanced Automobile Concepts: A Marketing Research Study to Determine Car Model Preferences and Profile Market Segments. Then he wrote out several other comments that he wanted to include in the beginning of his presentation, such as the research objectives, and several issues dealing with the method used, such as the sample plan and the sample size. When Rogers wrote out a number of the statements that he thought would help him communicate the purpose and method of the study, he turned his attention to presenting the findings.
Rogers thought he would begin his presentation of the study with a description of the sample, often referred to as a "profile of the sample." He noticed that for Gender and Marital Status there were only two categories (male, female; and married, unmarried) for each question. He decided to just orally report the percentages of the categories. However, for some of the other variables, there were several categories of response and he felt he would communicate the results better by showing the frequency distribution table. He prepared a frequency distribution of the responses to these questions using XL Data Analyst. He continued by making several key analyses of the data using XL Data Analyst.
Using Excel, make a bar chart of the answers to the question regarding the variable, "Americans Use Too Much Gasoline." Experiment with the different options of bar charts available to you in Excel. Select a bar chart and import that chart into PowerPoint using copy and paste. Experiment with making edits on your slide.