Search results

Thanks Luke. I will give those ideas a try.

Ah, thank you Luke for pointing this out. APA stands for the American Psychological Association. The APA publishes an APA style guide for publishing research documents. The most current edition of the guide is the 6th edition and contains specific instructions for table styling. I hope this...

All, I am looking for a method to convert an Excel spreadsheet into an APA formatted table. I have searched the Internet for this and cannot find any resources that explain how to do this step-by-step. Any assistance is great appreciated. Thanks all!

Thank you all! I can't believe I missed the "Find and Select" icon on the tool bar! Once again, the Excel masters have spoken!

I have multiple rows of text that are mostly two word entries. For example, some of the entries are: Blue House Red House Green House I need to reformat the text for another application so that each entry appears with an underscore between the words. For example: Blue_House Red_House...

Solved! Luke M provided the solution which does what I want. I modified the formula to use the cells I was using, and this worked like a charm. I appreciate everyones input and want to thank all of you very much! Narayank provided the foundation for the formula and Luke Ms modification...

Ah! Formula works, but the percentage must be between 0 and 1, not a whole number! Thank you! Now the only problem is that the list is not in order and the percentage cahnges from item to item.

Something is not working correctly with the formula. When I paste it into a sheet, is provides only all 1s or all 0s, regardless of the percentage in C1. Thanks again everyone!

Thank you Luke, that post was most helpful. I was hoping to see the percentage not applied to the whole list, but each individual element has its own percentage. For example, mark 50% of the cats 1, the other 50% of the cats 0. Mark 25% of the cats 1, the other 75% 0. Does this help...

Thank you Narayank for the quick reply. The percentage will change from item to item. I thought that the specification could be computed by Excel, i.e. if I want 76% of the items to have a "one" assigned to them, then the remaining 24% should have a "zero" assigned to them. It is my intention...

Say I have a list of items, similar to what is below: cat cat cat cat dog dog dog dog Given a cell where the user can input a value which represents what percentage of "cat" in the list should be assigned a one value, how would I assign "one" based on the percentage entered, then a...

Jordan, that worked exactly as you described! Thank you very much for your help with this problem!

I believe I understand what is going on. Can you tell me which columns you selected to create the chart? I am not having any luck reproducing your results with the chart. The list of animals are showing up as lines and not points, as they were in your example. Any assistance with this is...

Jordan, that appears to be the solution I am looking for. Were the values you put into the input column chosen arbitrarily? It seemed like in the example everything was skewed to the left of the curve. This is a huge step forward for me! Thank you so much!

Yes Jordan, that might be a better way to say this. How the items are mapped to the distribution is not important, only that they are. This will help me create a frequency of occurrence of each item that appears in the distribution. Below is a link to my sample...

This works wonderfully! However, what if I wanted more than the top name, instead I wanted the top 10, or 20? How would this be modified to accomplish this? Oh, and what if your data were in columns? How about if there were a tie? Thank you!

Thanks for your reply SirJB7. I am attempting to create a normal distribution sample data set. To create a sample set with 1000 values, using a mean of 10 in cell F1 and standard deviation of 2 in cell H1, I place the value -10 in cell A1. I then click the Home tab, editing group, fill drop...

I have a text list of 27 items. I want to simulate a normal distribution of the list with 2000 samples. Once the list has been simulated, I would like to assign a value of zero or one to each item, based on how often it occurs. Any help would be greatly appreciated! Thanks!

Thank you for the valid responses. I really did mean that disk 2 has an I/O speed of 50MB/s. I have the formula necessary to figure this out. However, I am trying to get Excel to iterate through the formula, using the solution generated on the first iteration as part of the second...

I am an Excel newbie, so please indulge me. :) I am trying to figure out how to make Excel perform "Leaky Bucket" calculations for me. For example, lets say we have a disk drive (Disk Drive A) that has an I/O speed of 200 MB/s. Let us say that this disk drive writes to another disk drive...