Please provide descriptive statistics (count, max, min, mean, and std.) for variables (ctr, tcr, roa, net revenue, avg.

Please first add four additional metrics (columns) into your data using the formula provided
• Net Revenue (Amount (total revenue) – Total Cost))
• Return on Ad $ Spent (ROA) (Net Revenue / Total Cost) (Note: Set this variable as
percentage; if Total Cost is 0, then set ROA as 0 for that observation.)
• Average Revenue per Booking (Amount /Total Volume of Bookings) (Note: if Total
Volume of Bookings is 0, then set “NA” for that observation)
• Probability of Booking (Engine Click Thru % (CTR) * Trans. Conv. % (TCR) / 10000)
Please provide descriptive statistics (Count, Max, Min, Mean, and Std.) for variables (CTR, TCR, ROA, Net Revenue, Avg. Cost per Click, Average Revenue per Booking, and Probability of Booking. Please ONLY report a summary statistics table and provide short descriptions of your observations and thoughts.
• Please make a Scatter Plot (with a Trend line), a Histogram (with a density plot, see Tutorial 1.2), and a Box Plot for any of the variables of your own interest in the data. Then report any insights you may be able draw from the charts.