Please complete the following questions using the first dataset listed on the link labeled "Advanced Automobile Concepts (AAC)

https://www.xldataanalyst.com/Datasets.html

Case 12.2 Your Integrated Case The Advanced Automobile Concepts Survey Generalization Analysis Cory Rogers was pleased with Celeste Brown's descriptive analysis. Brown had done all of the proper descriptive analyses, and she had copied the relevant tables and findings into a Word document with notations that Rogers could refer to quickly. Rogers says, "Celeste, this is great work. I am going to Nick Thomas in an hour to show him what we have found. In the meantime, I want you to look a bit deeper into the data. I have jotted down some items that I want you to analyze. This is the next step in understanding how the sample findings generalize to the population of the United States. I also have some hypotheses that I want you to test." In the way of background, the data set for the Advanced Automobile Concepts survey has fifty variables that pertain to the following topics. Demographics Vehicle ownership Probabilities of buying various types of hybrid vehicles in the next three years Preferences for specific types of hybrid vehicles Lifestyle Favorite television show type Favorite radio genre Favorite magazine type Favorite local newspaper section The XL Data Analyst data set, called AAConcepts.xism, is comprised of 1,000 respondents who are a representative sample of American households. There is an estimated 14,825,428 American households (U.S. Census, 2010 estimate). Your task here is to again take the role of Celeste Brown, marketing analyst. Using the Advanced Automobile Concepts data set, perform the proper analysis and interpret the findings for each of the following questions specified by Rogers\f