Question: l. (8 Points) Please add four additional metrics into your data using the formula provided 0 Net Revenue (Amount (total revenue) - Total Cost)) 0


l. (8 Points) Please add four additional metrics into your data using the formula provided 0 Net Revenue (Amount (total revenue) - Total Cost)) 0 Return on Ad $ Spent (ROA) (Net Revenue I Total Cost) (Note: Set this variable as percentage; if Total Cost is 0, then set ROA as 0 for that observation.) 0 Average Revenue per Booking (Amount lTotal Volume of Bookings) (Note: if Total Volume ofBookings is 0, then set \"NA "for that observation) 0 Probability of Booking (Engine Click Thru % (CTR) * Trans. Conv. % (T CR) J 10000) Please provide descriptive statistics (Count, Max, Min, Mean, and Std.) for variables (CTR, TCR, Net Revenue, Avg. Cost per Click, RDA, Average Revenue per Booking, Probability of Booking, and. Please report a summary statistics table and provide short descriptions of your observations and thoughts. 0 Please make a Scatter Plot (with Trend line) and a Histogram for any of the variables of your own interests in the data. Then report any insights you may be able draw from the charts
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
