2 What is your full name? 3 Do you certify that this workbook contains your work and not that of someone else? (Answer Yes if True) 4 How many unique advertisement identifiers are there (ad id)? 5 How many company campaigns are there (xyz_campaign id)? 6 List the identifying numbers for the company campaigns (ascending numbers separated by commas) 7 What is the youngest age range in the dataset? 8 What is the oldest age range in the dataset? 9 What is the definition of "impressions"? (copy from Kaggle Data page) 10 Which ad id had the highest number of impressions? (hint: Sort can help) 11 How many times was this ad shown? 12 How many ads (ad_id) produced no clicks? (hint: COUNTIF can help) 13 What percentage of the ads produced no clicks? (cell should be formula and use percentage format) 14 Add a data column "Click Ratio" this is the ratio of Clicks to Impressions. Among the ads (ad_id) that had at least 250 clicks, what was the highest Click Ratio in percentage terms? (hint: MAXIFS can help, report four decimals) 15 What is the ad_id for this ad with the highest Click Ratio? 16. What is the least amount of money that the company spent on an individual ad (ad_id)? (hint: MIN) 17 What is the most amount of money that the company spent on an individual ad (ad_id)? (hint: MAX) 18 What is the average amount of money that the company spent on an individual ad (ad_id)? (hint: AVERAGE) 19 What is "Approved_Conversion"? (see Kaggle Data page) 20 Forads (ad_id) that had 250 or more clicks, what was the total number of product sales (hint: SUMIF) 21 For ads (ad_id) that had 250 or more clicks, what was the average number of product sales? (hint: AVERAGEIF)