Math Help Question

[ststern45]

I purchased a software program and trying to figure out the calculations from a range of numbers.

The numbers are the following: 14 16 24 29 30
The answer is 9 according to the program calculation
The explanation is the following:
"The amount of multipliers which are equal to 2 in the range of cells"
In addition the help file: amount of factor 2 - The quantity of the factor = 2 of the numbers in the range

Example 2:
The numbers are the following: 4 5 9 20 28
The answer is 6 according to the program calculation

Example 3:
The numbers are the following: 8 16 18 19 22
The answer is 9 according the the program calculation

Example 4:
The numbers are the following: 8 12 16 17 26
The answer is 10 according the the program calculation

I'm trying figure out how the calculations correspond to the explanation from the help file and the given numbers.

Kudos to those who can figure this out.

Thanks in advance!!

Are the Factors of 2? = 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22, 24, 26, 28, 30

 

[ststern45]

Thanks everyone for all your math expertise. Very much appreciate your time and knowledge.

 

[Eric W]

I designed an Excel formula to do this, but it took 2 helper columns. It's proving tricky to do it in a single cell.

Book1
	A	B	C	D	E
1	14		2	1	9
2	16		16	4
3	24		8	3
4	29		1	0
5	30		2	1
Sheet6

Cell Formulas
Range	Formula
C1:C5	C1	=GCD(A1,2^10)
D1:D5	D1	=LN(C1)/LN(2)
E1	E1	=SUM(D1:D5)

 

[johnnyL]

Well, If you are gonna play, don't drop the ball on the 20 yard line.

Book2
	A	B	C	D	E	F	G	H
1	Start value		Multiple		Base #		Exponent	Sum of Exponents
2	14	=	7	*	2	^	1	9
3	16	=	1	*	2	^	4
4	24	=	3	*	2	^	3
5	29	=	29	*	2	^	0
6	30	=	15	*	2	^	1
Sheet1

Cell Formulas
Range	Formula
H2	H2	=SUM(G2:G6)
C2:C6	C2	=A2/(E2^G2)
G2:G6	G2	=LN(GCD(A2,2^10))/LN(2)

Since we are playing, why not make a cheat sheet:

Book2
	A	B	C	D	E	F	G
1	Start value		Multiple		Base #		Exponent
2	1	=	1	*	2	^	0
3	2	=	1	*	2	^	1
4	3	=	3	*	2	^	0
5	4	=	1	*	2	^	2
6	5	=	5	*	2	^	0
7	6	=	3	*	2	^	1
8	7	=	7	*	2	^	0
9	8	=	1	*	2	^	3
10	9	=	9	*	2	^	0
11	10	=	5	*	2	^	1
12	11	=	11	*	2	^	0
13	12	=	3	*	2	^	2
14	13	=	13	*	2	^	0
15	14	=	7	*	2	^	1
16	15	=	15	*	2	^	0
17	16	=	1	*	2	^	4
18	17	=	17	*	2	^	0
19	18	=	9	*	2	^	1
20	19	=	19	*	2	^	0
21	20	=	5	*	2	^	2
22	21	=	21	*	2	^	0
23	22	=	11	*	2	^	1
24	23	=	23	*	2	^	0
25	24	=	3	*	2	^	3
26	25	=	25	*	2	^	0
27	26	=	13	*	2	^	1
28	27	=	27	*	2	^	0
29	28	=	7	*	2	^	2
30	29	=	29	*	2	^	0
31	30	=	15	*	2	^	1
32	31	=	31	*	2	^	0
33	32	=	1	*	2	^	5
34	33	=	33	*	2	^	0
35	34	=	17	*	2	^	1
36	35	=	35	*	2	^	0
37	36	=	9	*	2	^	2
38	37	=	37	*	2	^	0
39	38	=	19	*	2	^	1
40	39	=	39	*	2	^	0
41	40	=	5	*	2	^	3
42	41	=	41	*	2	^	0
43	42	=	21	*	2	^	1
44	43	=	43	*	2	^	0
45	44	=	11	*	2	^	2
46	45	=	45	*	2	^	0
47	46	=	23	*	2	^	1
48	47	=	47	*	2	^	0
49	48	=	3	*	2	^	4
50	49	=	49	*	2	^	0
51	50	=	25	*	2	^	1
52	51	=	51	*	2	^	0
53	52	=	13	*	2	^	2
54	53	=	53	*	2	^	0
55	54	=	27	*	2	^	1
56	55	=	55	*	2	^	0
57	56	=	7	*	2	^	3
58	57	=	57	*	2	^	0
59	58	=	29	*	2	^	1
60	59	=	59	*	2	^	0
61	60	=	15	*	2	^	2
62	61	=	61	*	2	^	0
63	62	=	31	*	2	^	1
64	63	=	63	*	2	^	0
65	64	=	1	*	2	^	6
66	65	=	65	*	2	^	0
67	66	=	33	*	2	^	1
68	67	=	67	*	2	^	0
69	68	=	17	*	2	^	2
70	69	=	69	*	2	^	0
71	70	=	35	*	2	^	1
72	71	=	71	*	2	^	0
73	72	=	9	*	2	^	3
74	73	=	73	*	2	^	0
75	74	=	37	*	2	^	1
76	75	=	75	*	2	^	0
77	76	=	19	*	2	^	2
78	77	=	77	*	2	^	0
79	78	=	39	*	2	^	1
80	79	=	79	*	2	^	0
81	80	=	5	*	2	^	4
82	81	=	81	*	2	^	0
83	82	=	41	*	2	^	1
84	83	=	83	*	2	^	0
85	84	=	21	*	2	^	2
86	85	=	85	*	2	^	0
87	86	=	43	*	2	^	1
88	87	=	87	*	2	^	0
89	88	=	11	*	2	^	3
90	89	=	89	*	2	^	0
91	90	=	45	*	2	^	1
92	91	=	91	*	2	^	0
93	92	=	23	*	2	^	2
94	93	=	93	*	2	^	0
95	94	=	47	*	2	^	1
96	95	=	95	*	2	^	0
97	96	=	3	*	2	^	5
98	97	=	97	*	2	^	0
99	98	=	49	*	2	^	1
100	99	=	99	*	2	^	0
101	100	=	25	*	2	^	2
Sheet1

Cell Formulas
Range	Formula
A3:A101	A3	= A2 + 1
C2:C101	C2	=A2/(E2^G2)
G2:G101	G2	=LN(GCD(A2,2^10))/LN(2)

 

[ststern45]

Thanks Eric and JohnnyL. Appreciate the time and effort coming up with the solutions. Very impressive!!

 

[johnnyL]

@Eric W is the genius, I just piggybacked a lil bit.

 

[JGordon11]

Single cell formula for numbers less than 2^21 or 2,097,152:

Book3
	A	B	C
1	14		9
2	16
3	24
4	29
5	30
Sheet2

Cell Formulas
Range	Formula
C1	C1	=SUM(--(A1:A5/2^TRANSPOSE(ROW($1:$20))=INT(A1:A5/2^TRANSPOSE(ROW($1:$20)))))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[ststern45]

Thanks for the reply J.