Micheal has 16.25 $ in the bank. He needs 108 $ to buy a video game. He finds he can save 1.75 $ a week from his allowance. How many weeks must he save in order to have enough to buy the game.

Hello,

I never tire of asking me: To be a good programmer, what is the relevance of getting a degree in computer science? And a good programmer has in mind all the commands of a programming language, like PHP or JAVA? The oldest languages (MSDOS) had less than 200 commands and functions, currently they must have more than 1000

I would like to hearing from you

sincerely

Consider a binomial random variable X ~ Bi(n,∅).

We can get P(x) and P(x+1) as below but how to solve question 1 & 2 ?

P(x) = nCx . ∅ x (1- ∅)n-x
p(x+1) = nC x+1 . ∅ x-1 (1- ∅) n- (x+1)
                     
Thx.

What is the date today if april 29 was nine days before two days after three days preceding the day before five days following the day before yesterday?

Ray and a friend drive from vancouver to toronto in 56 h of steady driving, They leave vancouver on may 30 8 am when do they arrive in toronto

I've having trouble with a rounding routine in Excel.  The goal is when the user enters a number with the wrong number of significant digits, the macro rounds the number and replaces what they entered.  It does not merely change the cell display to show the desired number of digits, it actually corrects the number entered and updates the cell.

I am seeing some very strange results where sometimes the macro works and other times it does not.  Please enter the code below in a blank Excel workbook and try this out.

Private Sub Worksheet_Change(ByVal target As Range)

If target.Cells.Count > 1 Then Exit Sub

If target.Value = "" Then Exit Sub

If Not (IsNumeric(target)) Then
    MsgBox "please enter a number"
    target.Value = ""
    target.Select
    Exit Sub
End If

Call roundit(target, 0.1)

End Sub

Sub roundit(ByVal target As Range, rez As Single)

Dim x As Single

Application.EnableEvents = False

Select Case rez
Case 0.1
    x = Round(target * 10, 0) / 10
    target.NumberFormat = "0.0"
    MsgBox "Rounded value of " & target & " to the nearest " & rez & " is " & x
    target = x
End Select

Application.EnableEvents = True

End Sub

Select all Open in new window

Try entering these test values:

5 - works
5.54 - correctly changes to 5.5
5.45 - appears to work, but the number in the cell is now 5.40000009536743
5.454545 - correctly changes to 5.5
5.656565 - appears to work, but the number in the cell is now 5.69999980926513
6.899 - appears to work, but the number in the cell is now 6.90000009536743
Etc.  I can't find the pattern!

I've got a number of possible rounding values, hence the select case, but for this example I have just provided one.  I've followed the steps in my rounding algorithm and they appear to be working correctly.  It's gotta be a math thing.  Where are these crazy long values coming from, and how do I get this to work correctly?

Appreciate any help!

Nine coins of which three are gold and six are silver in a box. Three coins are selected and placed in bag A. The remaining coins are placed in bag B.
1. Find the probabilities of each possible numbers of gold coins, from 0 to 3, in bag A.

2. on a particular case it is know that one gold coin and two silver cons are in bag A, and that the remaining coins are in bag B. One coin is drawn from a bag selected randomly and put it into another bag. If one coin is then drawn from the last bag, find the probability that it is a gold coin.

I have an index and it is only published quarterly. I want to change it to monthly data.  I did the to the power 1/3 so each month in the quarter has the same return and it produces the same return as the quarter. This causes correlation problems with other indices which has monthly data.

Index 1 (Quarterly Data)
Index 2 (Monthly Data)

Index 1
Quarterly Return 0.48%

Index 2
June -6.71%
July 1.29%
August 2.65%
Which bring this quarterly return to -3.00%.

When I am converting Index 1 to monthly data , i would like to use Index 2 as a guidance.  So, it needs to weighted using the Index 2 data when making Index 1 monthly.

I tried the following.

For June Index 2 x1 = (1+ -6.71%)/(1+ 3%) - 1
For July Index 2 x2 =(1+ 1.29%)/(1+ 3%) - 1
For August Index 3 x3 = (1+ 2.65%)/(1+ 3%) - 1

For June Index 1  y1= (x1/(x1+x2+x3)) * 0.48%        (0.48% is the quarterly return for Index 1)
For July Index 1 y2= (x2/(x1+x2+x3)) * 0.48%        (0.48% is the quarterly return for Index 1)
For August Index 1  y3= (x3/(x1+x2+x3)) * 0.48%        (0.48% is the quarterly return for Index 1)

Then when I compound (1+y1)(1*y2)(1*y3) - 1 = 0.48% So it worked for this quarter.

It works great for some quarters but it doesn't work for some quarters. In some quarters, when I compound y1 y2 y3, i get a number very different from the actual quarterly data for Index 1.  Please see the attached file for the excel file. It has the calculations.
example-data.xlsx

Proper AWG for low voltage application.

I want to run some wire for a low voltage lighting.  The transformer supply will be about 6 -8 feet from the LED lights.  Transformer max output is rated at 36 watts.
36w / 12v = 3Amps.  (max)

Question: What would be safe wire gage to use ?  Was considering using 16AWG lamp cord ?   Most of the documentation and/or charts that I can find online shows 16AWG would be sufficient.  See Attached.
WireSelectionChart.png

Do I need a water-water heat exchanger to run a shower off an Antminer S9-Aqua?

My hovel is currently heated by several crypto-miners but they all blow hot air out and do not provide hot water. If I get a water-cooled mining rig can I connect it directly to my hot water tank or do I need a heat exchanger?

I live in a hard water area. there is a lot of chalk in the tap water which makes it taste nice but tends to clog the pipes.

How do i get the attached data "normalised" -- made into normal distribution ?

Worksheet "Data" = Full Data
"Filtered 25-65" = data with 25-65 s filtered by "Data" and copied in this worksheet.

If i use 25-65, it has the best result - ie, less skewness but stil not into normal distribution.

Any idea to use that range such that the data plotted is normal distribution  ?
Data-25-65--Check-Normal--EE.xlsx

Hi,

Is there a way to calculate percentile rank using a conditional statement. For example, PERCENTRANK.EXC of column Ratio if Rating value is AAA. Example is attached.

Thanks
EE-example.xlsx

I'm exploring the use of drones to do delivery (for items that weigh up to 20kg
ie about 44 lbs) of dimensions up to 2ft long x 2ft wide x 10 inches thick.  

Once local authority approves it, thought of sourcing/purchasing some of these
drones but will need to look into the cost effectiveness (ie its  gasoline/petrol
costs, maintenance/repair) or is there any that uses rechargeable powerbanks?

Has Amazon or any country done it & what's the safety & regulatory requirements?

We need an MBR, but it needs to be returned as a 5 point polygon.

Test sample :

with OrientedPoint as
   (
      SELECT 1 AS OrientedPoint, sdo_geometry(3001,31370,NULL,sdo_elem_info_array(1,1,1,4,1,0),sdo_ordinate_array(1,11,0,1,0,0))  AS geom FROM dual union all
      SELECT 2 AS OrientedPoint, sdo_geometry(3001,31370,NULL,sdo_elem_info_array(1,1,1,4,1,0),sdo_ordinate_array(2,12,0,1,0,0))  AS geom FROM dual union all
      SELECT 3 AS OrientedPoint, sdo_geometry(3001,31370,NULL,sdo_elem_info_array(1,1,1,4,1,0),sdo_ordinate_array(3,13,0,1,0,0))  AS geom FROM dual union all
      SELECT 4 AS OrientedPoint, sdo_geometry(3001,31370,NULL,sdo_elem_info_array(1,1,1,4,1,0),sdo_ordinate_array(4,14,0,1,0,0))  AS geom FROM dual union all
      SELECT 5 AS OrientedPoint, sdo_geometry(3001,31370,NULL,sdo_elem_info_array(1,1,1,4,1,0),sdo_ordinate_array(5,15,0,1,0,0))  AS geom FROM dual union all
      SELECT 6 AS OrientedPoint, sdo_geometry(3001,31370,NULL,sdo_elem_info_array(1,1,1,4,1,0),sdo_ordinate_array(11,21,0,1,0,0)) AS geom FROM dual union all
      SELECT 7 AS OrientedPoint, sdo_geometry(3001,31370,NULL,sdo_elem_info_array(1,1,1,4,1,0),sdo_ordinate_array(11,31,0,1,0,0)) AS geom FROM dual union all
      SELECT 8 AS OrientedPoint, sdo_geometry(3001,31370,NULL,sdo_elem_info_array(1,1,1,4,1,0),sdo_ordinate_array(15,21,0,1,0,0)) AS geom FROM dual union all
      SELECT 9 AS OrientedPoint, …