This question has part a, b, and c. HouseholdsHouseholdsHouseholdsHouseholds20252520152020151510101010FamilyMembers o0FamilyFamilyMembers oOFamily2MembersMembers(b) Use a stacked bar chart to compare the number of family members living in each of the three types of residences.Apartment Duplex SingleIII ApartmentI DuplexI SingleApartmentI Duplex SingleApartment Duplex singleNumber ofNumber ofNumber ofNumber ofHouseholdsHouseholdsHouseholdsHouseholds35303030252020201510101010FamilyFamilyMembers OFamilyFamilyMembers o0Members o01 "24Members12123 " 4(c) what conclusions can you draw using the graphs in parts (a) and (b)?O Both charts indicate that the more family members there are, the more likely it is that the family lives in an apartment.O The side-by-side bar chart indicates that the more family members there are, the more likely it is that the family lives in an apartment. The stacked bar chart indicates that the more family members there are, the more likely it is that the family lives in a duplex.O Both charts indicate that the fewer family members there are, the more likely it is that the family lives in a single residence.O The stacked bar chart indicates that the more family members there are, the more likely it is that the family lives in an apartment. The side-by-side bar chart indicates that the more family members there are, the more likely it is that the family lives in a duplex.O Both charts indicate that the more family members there are, the more likely it is that the family lives in a single residence. A local chamber of commerce surveyed 124 households within its city and recorded the type of residence and the number of family members in each of the households.Type of ResidenceFamily Members Apartment Duplex Single Residence1115313310254 or more7227(a) Use a side-by-side bar chart to compare the number of family members living in each of the three types of residences.I Apartment I DuplexI SingleI Apartment Duplex SingleI ApartmentI DuplexI SingleI Apartment I DuplexI SingleNumber ofNumber ofNumber ofNumber ofHouseholdsHouseholdsHouseholdsHouseholds****202525252015202015151510101010FamilyFamilyFamilyFamily2 '3Members oO14Members4Members342Members(b) Use a stacked bar chart to compare the number of family members living in each of the three types of residences.I ApartmentI Duplex SingleI Apartment Duplex Single|Apartment Duplex single| ApartmentI Duplex singleNumber ofNumber ofNumber ofNumber ofHouseholdsHouseholdsHouseholdsHouseholds3530303025202015101아1아10FamilyFamilyFamilyFamily

Question

This question has part a, b, and c. HouseholdsHouseholdsHouseholdsHouseholds20252520152020151510101010FamilyMembers o0FamilyFamilyMembers oOFamily2MembersMembers(b) Use a stacked bar chart to compare the number of family members living in each of the three types of residences.Apartment Duplex SingleIII ApartmentI DuplexI SingleApartmentI Duplex SingleApartment Duplex singleNumber ofNumber ofNumber ofNumber ofHouseholdsHouseholdsHouseholdsHouseholds35303030252020201510101010FamilyFamilyMembers OFamilyFamilyMembers o0Members o01 &#34;24Members12123 &#34; 4(c) what conclusions can you draw using the graphs in parts (a) and (b)?O Both charts indicate that the more family members there are, the more likely it is that the family lives in an apartment.O The side-by-side bar chart indicates that the more family members there are, the more likely it is that the family lives in an apartment. The stacked bar chart indicates that the more family members there are, the more likely it is that the family lives in a duplex.O Both charts indicate that the fewer family members there are, the more likely it is that the family lives in a single residence.O The stacked bar chart indicates that the more family members there are, the more likely it is that the family lives in an apartment. The side-by-side bar chart indicates that the more family members there are, the more likely it is that the family lives in a duplex.O Both charts indicate that the more family members there are, the more likely it is that the family lives in a single residence. A local chamber of commerce surveyed 124 households within its city and recorded the type of residence and the number of family members in each of the households.Type of ResidenceFamily Members Apartment Duplex Single Residence1115313310254 or more7227(a) Use a side-by-side bar chart to compare the number of family members living in each of the three types of residences.I Apartment I DuplexI SingleI Apartment Duplex SingleI ApartmentI DuplexI SingleI Apartment I DuplexI SingleNumber ofNumber ofNumber ofNumber ofHouseholdsHouseholdsHouseholdsHouseholds****202525252015202015151510101010FamilyFamilyFamilyFamily2 '3Members oO14Members4Members342Members(b) Use a stacked bar chart to compare the number of family members living in each of the three types of residences.I ApartmentI Duplex SingleI Apartment Duplex Single|Apartment Duplex single| ApartmentI Duplex singleNumber ofNumber ofNumber ofNumber ofHouseholdsHouseholdsHouseholdsHouseholds3530303025202015101아1아10FamilyFamilyFamilyFamily

Accepted Answer

Procedure to obtain side-by-side chart using excel:

Enter the data in an excel sheet.
Select the…