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 A1 fx Gender A B D F G . 1 Gender 2 Male 3 Male 4 Female 5 Female 6 Female 7 Male 8 Female 9 Female 10 Male 11 Male 12 Male 13 Female 14 Male 15 Female 16 Male 17 Female 18 Male 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 Age Group 19-25 19-25 19-25 26-30 18 and under 19-25 18 and under 26-30 Over 30 Over 30 19-25 26-30 Over 30 18 and under 26-30 Over 30 26-30 19-25 18 and under Over 30 26-30 19-25 26-30 26-30 18 and under Over 30 18 and under 26-30 19-25 26-30 Preferred Color Blue Blue Black Blue Blue Gray Black Blue Black Black Black Blue Blue Black Blue Gray Blue Black Black Blue Preferred Style Slim Fit Slim Fit Relaxed Fit Slim Fit Slim Fit Straight& hyphen;leg Fit Slim Fit Slim Fit Slim Fit Slim Fit Slim Fit Slim Fit Relaxed Fit Slim Fit Straight‐leg Fit Slim Fit Slim Fit Slim Fit Slim Fit Relaxed Fit Classic Fit Classic Fit Slim Fit Straight& hyphen;leg Fit Slim Fit Slim Fit Slim Fit Classic Fit Slim Fit Slim Fit Purchase Influence Comfort Comfort Comfort Brand Style Quality Price Style Style Brand Comfort Comfort Comfort Quality Style Comfort Comfort Quality Style Comfort Brand Comfort Price Price Comfort Comfort Brand Brand Comfort Brand Gray Blue Gray Black Gray Black Gray Black Black Gray 32 33