How to Make a Frequency Distribution Table – Paredo Charts
How to Make a Frequency Distribution Table
Paredo Charts and Analyzing Data
A paredo chart shows the number of items or occurrences of instances within a category. A chart typically lists between 5 and 10 categories but I've seen them listing up to 30.
Normal graphing rules suggest that as you enter the data into a spreadsheet to chart you will list the data in highest to lowest sequence, so that your chart will list of the far left the biggest frequency item. The reason you would do this is so that you get a sense for your biggest opportunities.
In the linked article above, I show you how I analyzed my own articles to see where the biggest number of hits came from by category. The objective would be for me to write more articles of the same types that I am frequenting hits.
Analyzing income from article writing could be handled the same way. Create categories such as: $.01c -$5, $5-10, $11-15, $16-20, $21-35, $36-49, $50-100, $101-249, $250-500. Put these column headings in row 1, starting in column B.
Next list all the article titles you have written in an excel spreadsheet. Put them in column A, starting in row two.
After listing all the articles, go back through, row by row and put a '1′ in the column, to act as a check mark for the income you received for that particular article. As you go through your list, you may have some articles that had two different ways to receive payments. One might be an upfront of $5.24, and you might have received revenue from pay per clicks, and that might equal .25C. Put a '1′ in each column. What you are after is not the total revenues that you received in this excrcise, but the areas where you are having the most frequent activity.
When you are done marking the occurrences, total them up. Go to column A and underneath your last article title, type in "Total". Then put your cursor in column A, directly to the right, in the same row, and type in "=Sum". This will bring up a formula. Here you can highlight all the data in column B (rows 2 through whatever row number your last title is in) and choose enter. The excel sheet will total column B. Now click on the box and drag it to the right, and this should auto sum the rest of the columns for you.
Now you should be able to see what column has your biggest hitter in it. On another excel sheet in the same workbook, copy over your total sum, by right clicking that row, choosing copy, and then in the new work book, choose right click to paste. You will want to put this data in the second row. Then carefully assign your data headings to align with your sums. From here, you can easily make a Paredo chart to give you the data in a graph.
To take this to the next level, you might also want to do a graph that is similar but instead of using a "1″ to "check" the category, insert your actual total, or amount of revenue. Then you can see where you are generating the most kinds of revenues. Typically blog posts might earn you $1 – $20.00, articles can earn anywhere from $1-$100. Analyzing this data will help you see where you have been spending your efforts and it might also help you see where you should be spending your time if you want to increase your reveneue.
Sigma XL is a good source for more info.
For other article writing advice, please explore my site Bad Girl Gone Mom, author site and check out the new feed, Sabah's writing tips that I have included.
More From kbalbify
How to Create a Career without a Full-Time Job – US News and World Report
Business Plan – A Valuation Method Using Discounted Cash Flows
Don't flirt with motorcyclists
kbalbify Recommends
How to Make Out Most from of a Fitness Video (Web Chit-Chat)
How to Choose a Theme for Your Scrapbook | Family Articles (Web Chit-Chat)
Ask kbalbify To Recommend Your Posts [image error] Use Facebook to Comment on this Post
Related posts:Justified and the letter J: #ZtoAChallent Today's blog post is on the word justified. So here...
Web-writing tricks, writer support and resources I started my foray into online web-writing when I got...
Author Chat on Night Owl Reviews was a success! Last night I participated in Night Owl Reviews Author Chat...
