4.2.7 Question Help Use the COUNTIF function to construct frequency distributions for gender, preferred style, and purchase influence for the data provided, develop column charts to express the results visually, and compute the relative frequencies. Click the icon to view the data. Complete the frequency distribution for gender, and compute the relative frequencies. (Type integers or decimals rounded to three decimal places as needed.) Gender Frequency Relative Frequency Male Female Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Calibri V 11 & Wrap Text General Y 3I3 Y 4 Paste B Aw Insert Delete Marge & Centar Format Conditional Format CAL Formatting as Table Styles Ideas Sort & Filter Find & Select Al Sx Gender A B D E F G H I L M N N 0 P R S T T u V W ] 1 Gender 2 Male 3 Male 4 Femala s Female 6 Female 7 Male & Female 9 Female 10 Male 11 Male 12 Me 13 Female 14 Male 15 Female 16 Male 17 Female 18 Me 19 Male 20 Female 21 Male 22 Female 23 Male 24 Male 25 Male 26 Female 27 Female 28 Male 29 Female 30 Male 31 Female 32 Are Group Preferred Color 19-25 Blue 19-25 Blue 19-25 Blue 26 30 Gray 18 and uncer Grey 19-25 Gray 18 and under Blue 26-30 Blue Over 30 plach Over 30 plack 19-25 Blue 26-30 Black Over 30 Blue 18 and under Gray 26-30 Dlack Over 30 Gray 26-30 Gray 19 25 Blue 18 and uncer Blue Over 30 Black 26-30 RIAK 19 25 Blue 26-30 Gray 26-30 Gray 18 and under Black Quer 30 Blue 12 and uncer Blac! 26-30 blue 16.25 19-29 Black 126-30 RIAK Preferred Hyle Straighthyphenleht Slim Fit Relaxed Fit Slim Fit Slim Fit Straight hyphenley Fit Slim Fit Classic Fit Slim Fit Slim Fit Slim Fit Slim Fit Relaxed FIE Slim Fit Straight & hyphenleFit Slim Fit Slim Fit Slim Fit Slim Fit Relaxed Fit Classic Fit Classic Fit Slim Fit Straight & hyphen;ler Slim Fit Straight & hyahen log Fit Slim Fit Classic Fit Slim Fit Slim Fit Purchase Influence Comfort Comfort co Comfort Style Style Quality Price Style Style Brand Comfort Comfort Comfort Comfort Style Comfort Comfort Quality Style Comfort Rrandl Comfort Price Price Brand Comfort Brand Brand |Quality Brand 24 35 36 37 39 4.2.7 Question Help Use the COUNTIF function to construct frequency distributions for gender, preferred style, and purchase influence for the data provided, develop column charts to express the results visually, and compute the relative frequencies. Click the icon to view the data. Complete the frequency distribution for gender, and compute the relative frequencies. (Type integers or decimals rounded to three decimal places as needed.) Gender Frequency Relative Frequency Male Female 4.2.7 Question Help Use the COUNTIF function to construct frequency distributions for gender, preferred style, and purchase influence for the data provided, develop column charts to express the results visually, and compute the relative frequencies. Click the icon to view the data. Complete the frequency distribution for gender, and compute the relative frequencies. (Type integers or decimals rounded to three decimal places as needed.) Gender Frequency Relative Frequency Male Female Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Calibri V 11 & Wrap Text General Y 3I3 Y 4 Paste B Aw Insert Delete Marge & Centar Format Conditional Format CAL Formatting as Table Styles Ideas Sort & Filter Find & Select Al Sx Gender A B D E F G H I L M N N 0 P R S T T u V W ] 1 Gender 2 Male 3 Male 4 Femala s Female 6 Female 7 Male & Female 9 Female 10 Male 11 Male 12 Me 13 Female 14 Male 15 Female 16 Male 17 Female 18 Me 19 Male 20 Female 21 Male 22 Female 23 Male 24 Male 25 Male 26 Female 27 Female 28 Male 29 Female 30 Male 31 Female 32 Are Group Preferred Color 19-25 Blue 19-25 Blue 19-25 Blue 26 30 Gray 18 and uncer Grey 19-25 Gray 18 and under Blue 26-30 Blue Over 30 plach Over 30 plack 19-25 Blue 26-30 Black Over 30 Blue 18 and under Gray 26-30 Dlack Over 30 Gray 26-30 Gray 19 25 Blue 18 and uncer Blue Over 30 Black 26-30 RIAK 19 25 Blue 26-30 Gray 26-30 Gray 18 and under Black Quer 30 Blue 12 and uncer Blac! 26-30 blue 16.25 19-29 Black 126-30 RIAK Preferred Hyle Straighthyphenleht Slim Fit Relaxed Fit Slim Fit Slim Fit Straight hyphenley Fit Slim Fit Classic Fit Slim Fit Slim Fit Slim Fit Slim Fit Relaxed FIE Slim Fit Straight & hyphenleFit Slim Fit Slim Fit Slim Fit Slim Fit Relaxed Fit Classic Fit Classic Fit Slim Fit Straight & hyphen;ler Slim Fit Straight & hyahen log Fit Slim Fit Classic Fit Slim Fit Slim Fit Purchase Influence Comfort Comfort co Comfort Style Style Quality Price Style Style Brand Comfort Comfort Comfort Comfort Style Comfort Comfort Quality Style Comfort Rrandl Comfort Price Price Brand Comfort Brand Brand |Quality Brand 24 35 36 37 39 4.2.7 Question Help Use the COUNTIF function to construct frequency distributions for gender, preferred style, and purchase influence for the data provided, develop column charts to express the results visually, and compute the relative frequencies. Click the icon to view the data. Complete the frequency distribution for gender, and compute the relative frequencies. (Type integers or decimals rounded to three decimal places as needed.) Gender Frequency Relative Frequency Male Female