Let $ X$ , $ Y$ be two independent random variables with $ N(0,1)$ distribution. How can I find the following conditional expected value $ $ \mathbb{E}(X | X^2 + Y^2)?$ $Read more
Let $ X$ , $ Y$ be two independent random variables with $ N(0,1)$ distribution. How can I find the following conditional expected value $ $ \mathbb{E}(X | X^2 + Y^2)?$ $Read more
I’m working with Google Sheets and want to highlight cells in long date format (e.g. 11/13/2018 21:00:00) that are Tuesday and 21:00:00. Here is my attempt: =AND((weekday(C4:C124)=3),(EQ(RIGHT(C4:C124,8)),”21:00:00″)) What I understand this to say is “if the weekday is Tuesday AND the eight characters at the end of the cell is equal to 21:00:00, then highlight.”Read more
I need help creating a function that takes 5 integer inputs and does the following: If exactly 2 or 3 of the first four inputs are not divisible by the last input I want the output to read “Impossible” If exactly 1 of the first four inputs (let’s call it Z) is not divisible byRead more
My code consists of two input fields and a submit button. The business rules require the following rules: 1. One or both fields must be filled out. Both cannot be blank. 2. If the first field is empty, then the second field must have a value greater than or equal to 50. 3. If theRead more
Let me try to specify my question with an example: Consider that there are 4 accounts ( AccountA and AccountB and AccountC (Taged as Store) and and AccountD (Taged as Night Club)), and AccountA wants to send let’s say $ 100 to AccountB with a specified condition (i.e. $ 100 can be spent only atRead more
We have following tables – Action, Employee and ActionAssignedTo I am trying to write a query to fetch an Action with id : 10 that has been assigned to emp_id : 1000. the reply of query should also contain all the other assignees for the same action i.e. same action can be assigned to multipleRead more
I am looking for an implementation of CRFs in Mathematica. I searched the documentation but found nothing, perhaps someone knows of a third party package?Read more
Suppose X is a random variable that we can observe, we want to take an action Y in order to minimize $ $ E[(Y-X)^{2}]$ $ Given the density of X is $ p(x)$ , what is the optimal choice of the conditional density $ q(y|x)$ of $ Y|X$ . Formally: $ $ \min_{q}\{E[(Y-X)^{2}]=\int(y-x)^{2}q(y|x)p(x)dydx\}$ $ s.tRead more
How does Amazon Aurora handle conditional queries based on MySQL version? I was unable to find any documentation on this. For example, the code below inserts into a database for MySQL 5.6.4 or newer. What is result in Aurora? I could spin up an instance but wanted to read the documentation about this to understandRead more
I have a nasty (IMO) piece of code for a datatable configuration, how do i best remove the duplication here? I’ve tried the obvious things I know (collapsing into one statement and trying inline conditionals) but it isn’t working and I can’t help thinking there must be a more elegant Ruby way here. if show_statusRead more