Please complete problems 1-5 using the first data set on this link -Advanced Automotive Concepts (AAC) - https://www.xldataanalyst.com/Datasets.html

ESQ-215054 Case 13.2 Your Integrated Case The Advanced Automobile Concepts Survey Differences Analysis Cory Rogers called a meeting with Nick Thomas, and Celeste Brown attended it. At the beginning of the meeting, Rogers '5 wife called with news that their five-yearold 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 dualcareer household. Celeste, sit with Nick for a bit and nd out what questions he has about the survey ndings. 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.\" After meeting for about twenty minutes, Brown understood that the Advanced Automobile Concepts divi- sion principals were encouraged by the ndings of the sur- vey 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 nancial 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 mar- ket 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 spe- cic and pinpointed will be the marketing strategy. For a rst cut at the market segment descriptions, the survey included the following commonly used demographic factors. Gender Marital status Age category Education category Income category Home town size category While the survey measured the likelihood of buying each hybrid type, Brown learned that Thomas considers prefer ences 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 ve possible hybrid models. 1. Super cycle oneaseat model; 120+ mpg city 2. Runabout sport two-seat 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 four-seat model; 60 mpg city, 80 mpg highway