Anlayse Data Set to identify number of occurence, using VB coding

Status
Not open for further replies.
S

sankavit

Newbie level 6
Joined
Jul 5, 2009
Messages
11
Helped
0
Reputation
0
Reaction score
0
Trophy points
1,281
Location
India
Visit site
Activity points
1,367
I have a Data set with about 12500 values.

I need to findout how many times each of the different values in column Y occurs and display it as a graph.

I have attached a short example with 20 data lines, to explain this.

I am using a Data Analysis software, which has VBA programming possibility.

Can Anyone help?
 

Attachments

  • math_prob.zip
    5.7 KB · Views: 103

I think you can use directly "Tools-->Data analysis-->Histogram" you can find in excel.
 

Status
Not open for further replies.

Similar threads

Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…