Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-09-2015, 11:35 AM
laucn laucn is offline Need help calculating frequency of digits Windows 7 64bit Need help calculating frequency of digits Office 2010 64bit
Novice
Need help calculating frequency of digits
 
Join Date: May 2015
Posts: 9
laucn is on a distinguished road
Smile Need help calculating frequency of digits

I have data in such way:

-------Set1 Set2 SetA SetB
Day1 3591 8690 7202 6796
Day2 5766 9514 9309 9344
Day3 4939 0023 4607 7550
Day4 5472 3489 6872 2455

*Note that some data set will contain leading zero(s), which must be retained and included in calculating the frequency.

1 am trying to find out the frequency of each digit from each set1, set2, setA, setB
Example,

For Set1, FIRST digit:
Digit Frequency
0-----0
1-----0
2-----0
3-----1
4-----1
5-----2
6-----0
7-----0
8-----0
9-----0

3 Digits that has lowest frequency (sorted ascending order, below is just example how it looks):
Digit Frequency
9-----11
0-----24
7-----30

For Set1, SECOND digit:
Digit Frequency
0-----0
1-----0
2-----0
3-----0
4-----1
5-----1
6-----0
7-----1
8-----0
9-----1

3 Digits that has lowest frequency:
Digit Frequency
X-----n
X-----n
X-----n


For Set1, THIRD digit:
Digit Frequency
0-----0
1-----0
2-----0
3-----1
4-----0
5-----0
6-----1
7-----1
8-----0
9-----1

3 Digits that has lowest frequency:
Digit Frequency
X-----n
X-----n
X-----n


For Set1, FOURTH digit:
Digit Frequency
0-----0
1-----1
2-----1
3-----0
4-----0
5-----0
6-----1
7-----0
8-----0
9-----1

3 Digits that has lowest frequency:
Digit Frequency
X-----n
X-----n
X-----n




The above search to be repeated for set2, then setA, SetB...
But as long as you guys can shed me light on how to do it for set one, i can take care of the rest of the data set

Many thanks in advance.

Regards,
Tristan
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to calculate Frequency lwls Excel 1 03-30-2015 05:40 AM
Need help calculating frequency of digits Trying to count frequency borninscorpio Excel 4 07-31-2013 12:44 AM
Frequency of a name bryant03 Excel 1 06-27-2012 10:21 AM
How to set frequency of Send?/Receive in Outlook 2010 mikepla Outlook 4 11-03-2011 06:50 AM
Need help calculating frequency of digits Problems merging in last 4 digits of an account higher than 16 digits Glynda Mail Merge 1 04-08-2011 12:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft