Write a SQL query to compute a frequency table of a certain attribute involving two joins. What if you want to GROUP or ORDER BY some attribute? What changes would you need to make? How would you account for NULLs?
13.103 Domande di colloqui condivise dai candidati | data analytics engineer
Lets say the population on Facebook clicks ads with a click-through-rate of P. We select a sample of size N and examine the sample's conversion rate, denoted by hat{P}, what is the minimum sample size N such that Probability( ABS(hat{P} - P) < DELTA ) = 95%. In other words (this is my translation), find the minimum sample size N such that our sample estimate hat{P} is within DELTA of the true click through rate P, with 95% confidence.
Given two binary strings, write a function that adds them. You are not allowed to use any built in string to int conversions or parsing tools. E.g. Given "100" and "111" you should return "1011". What is the time and space complexity of your algorithm?
Tell me about your dream job
We have a table called ad_accounts(account_id, date, status). Status can be active/closed/fraud. A) what percent of active accounts are fraud? B) How many accounts became fraud today for the first time? C) What would be the financial impact of letting fraud accounts become active (how would you approach this question)?
what is logistic regression? How to perform variable selection
Imagine a cube 1x1x1, then imagine that you form a cube of 10x10x10 with all these little cubes of 1x1x1. How many cubes do you have to remove to get rid of the surface of cubes.
how did u handle multicolleanarity in logistic model
Mini Case: eBay is getting complaints from customers that the site doesn't have enough product selection. To increase product selection eBay runs a promotion and decides to waiver the listing fees for all sellers. eBay's earns revenue from the listing fees and as a % of sales transaction and the bulk of revenue comes as a commission over sales transactions. The promotion instead of increasing the revenue results in a drop in revenue for eBay. Explain
Which field are you interested in.
Stai visualizzando 1 - 10 domande di colloquio
Guarda le domande di colloquio per lavori simili
Senior Data Analytics EngineerData And AnalyticsSenior Sas DeveloperAnalytics EngineerData Scientist IiiSenior Data ManagerData Analytics ConsultantData Analytics ManagerData AnalyticsSenior Sas ProgrammerSenior Data AnalystStatistical Analyst Predictive AnalyticsHead Of Data ScienceStatistical Sas ProgrammerData ScientistsProgrammer Analyst Sas Data AnalystPrincipal Data AnalystPrincipal Data Engineer