**Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates**

For This or a Similar Paper Click To Order Now

In Chapters 11 and 12, you were introduced to the process to follow when summarizing and generalizing your data using XL Data Analyst. It is now time to fine tune your skills. Begin by summarizing two different sets of data from the AAConcepts Data Set. Following the directions on p. 248 and pp. 253-254, provide summarization data for the following variables: Age and Size of Household.

In your analysis:

Identify the type of variable (categorical or metric)

Identify the summary statistics that apply to that variable type

Provide all of the applicable summary information in terms of central tendency and variability (percentage, frequency, average, range, etc.) as it applies to each variable.

In your answer, demonstrate your ability to interpret the chart by identifying the largest group, the smallest group, and the group that you are associated with in terms of the two variables.

Using a confidence interval analysis, answer the following question: What is the percentage range of respondents that travel to work using a carpool? How does that compare to the number of people who use public transportation? Interpret and explain the results of your analysis.