Access Microsoft 365 to create, share, and collaborate using your favorite apps like Word, Excel, and PowerPoint.
I am getting × in alert. I need to get × as result. Anybody knows or faces this problem? Please update your suggestions.
Bonus 2: repeating a 2D array this way takes a little bit more work, converting to rows a few times before wrapping back to the desired dimensions. You can of course use LET to keep things tidy if you don't want to define the array twice:
How do i calculate the probability of a result happening X amount of times in a row? Imagine an event with 6 possible outcomes. 1st outcome has chance of 40%, 2nd has a chance of 20%, 3rd 15%, 4th 10%, 5th 10%, 6th 5%.
Calculating the odds of a specific outcome happening X amount of times ...
Why is $1+2+3+4+\ldots+n = \dfrac {n\times (n+1)}2$ $\space$ ? Not appropriate for an answer, but you've asked either a very easy or a very difficult question. If by "why" you mean, "Can I see a proof of this fact?" the question is fairly easy to answer. If by "why" you mean, "Why should this be true?" you've asked a very deep kind of question that mathematicians make entire careers out of ...
The solution is to restore the table N times by using UNDROP; and it only works if there is no table with the same name. N is a number of times the table is recreated using CREATE OR REPLACE; and time travel doesn't work as CREATE OR REPLACE drops the table and recreates it. I have created a table with some dummy data to test it.