Question: Project: The data has been saved in the Excel workbook catsvdogs.xlsx.
1. Create a Pareto chart of the top 10 states with the largest number of households.
2. Create a relative frequency distribution histogram for the "percentage of households with pets" for all 50 states. Comment on the shape of the distribution.
3. Create a cumulative frequency line plot for the "percentage of households with pets" for all 50 states.
4. Perform numerical descriptive statistics for the "percentage of households with pets" for all 50 states, and determine whether there are any outliers in this data.
5. Repeat tasks 2-4 above for the "percentage of dog owners" and for the "percentage of cat owners". Describe whether there are any similarities or dissimilarities in the distributions of the three variables analyzed.
6. Create a scatter plot of the "mean number of dogs per household" vs "mean number of cats". Use the scatter plot to describe whether there is a correlation between the two quantities above.
Information related to above question is enclosed below:
Attachment:- catsvdogs.rar