In Chapters 13 and 14, you are introduced to the processes to follow when comparing data and trying to determine differences or relationships between groups and variables. Following the directions given in the example, locate other variables in the data, complete the ANOVA, and interpret the analysis. What is the information telling you that is important in the decision process?

Review the materials in Case 13:2. Choose two of the demographic variables listed in case. Then complete the differences analysis associated with two of the listed hybrid models. What conclusions can you draw from your analysis? Make sure to provide screen shots in your analysis output answer.

dataset link: www.pearsonhighered.com/burns: Basic Marketing Research with Excel (companion website) chapter 13

After meeting for about twenty minutes, Brown understood that the Advanced Automobile Concepts division principals were encouraged by the findings of the survey which indicate that there is substantial demand for the various types of high-mileage hybrid automobiles under consideration. Depending on development costs, prices, and other financial considerations, it seems that any one or a combination of the hybrid automobiles could be viable. The next step in their planning is to identify the target market for each hybrid automobile type under consideration. This step is crucial to market strategy as it is known that the more precise the target market definition is, the more specific and pinpointed will be the marketing strategy. For a first cut at the market segment descriptions, the survey included the following commonly used demographic factors. - Gender - Marital status - Age category - Education category - Income category - Hometown size category While the survey measured the likelihood of buying each hybrid type, Brown learned that Thomas considers preferences to be a better measure, because the hybrid model descriptions included seat size, mpg estimates, and styling notions. Your task is to apply appropriate differences analysis to your AAConcepts XL Data Analyst data set to determine the target market descriptions for each of the five possible hybrid models. 1. Super cycle one-seat model; 120+ mpg city 2. Runabout sport twoseat model; 90 mpg city, 120 mpg highway 3. Runabout with luggage two-seat model; 80 mpg city, 110 mpg highway 4. Economy four-seat model; 70 mpg city, 100 mpg highway 5. Standard fourseat model; 60 mpg city, 80 mpg highway Cory Rogers called a meeting with Nick Thomas, and Celeste Brown attended it. At the beginning of the meeting, Rogers's wife called with news that their fiveyearcld daughter was having a stomachache at school, and he was to pick her up and take her to the doctor. Rogers excused himself, saying, \"I am sorry about this, but these things happen when you are a dual-career household. Celeste, sit with Nick for a bit and find out what questions he has about the survey findings. Then take a shot at the analysis, and we'll meet about it tomorrow afternoon. I am sure that Cory Junior will be over his stomach ailment by then.\