Creating Percentiles
Jun 14, 2005I am going to be gathering some raw test results soon, and I need to create a percentile for this particular group of results. way to do this in Excel? Or at least point me in the right direction? :o
View 9 Replies
ADVERTISEMENT
Calculating Percentiles
Dec 5, 2008For my Intro to Engineering class, I collected data of two filter media in the laboratory. The data included the % of the media which passed through a sieve and the sieve openings. For use in a certain equation, I need the opening size at the 10th, 30th, 50th, 70th and 90th percentiles. I've tried searching on the Microsoft website but I don't think the PERCENTILE function will work correctly with the given data. I also tried using the slope between points to find the opening sizes at the percentiles mentioned, but doing so yielded different results from my professor's. Attached is the data I collected organized in tables and graphs of the data. I have also attached a pdf file of an example which my professor has given us.
View 5 Replies View RelatedCalculate Different Percentiles Based On Different Grades
Jun 3, 2009Need to calculate different percentiles based on different grades. how do I put an 'if' loop or anything else that will work for this.
GradeAmount
B23
B22
B35
B36
B48
B49
B510
B511
B615
B23
B37
B614
Need function for the table below
Percentile10%25%50%60%75%90%
B2
B3
B4
B5
Calculating Percentiles Based On Known Data
Jul 15, 2009Is there a function in Excel that would calculate the 85th & 90th percentiles based on the 50th & 75th percentiles.
View 2 Replies View RelatedCalculating Percentiles Of A Selected Range
Apr 12, 2014What I need is the following: I select a range of numbers and for this range I want to calculate the 1/3th and 2/3th percentile, and these should come in two cells that I can easily change in the vba code.
Some formula in which I can give two inputs: first the range of which it has to calculate the 1/3th and 2/3th percentile and a second input which is just a number and than the vba should say whether that second input is in the first range (between 0 and the 1/3th percentile value) or in the second range (between 1/3th and 2/3th percentile values) or third range (between2/3th percentile value and highest value).
Percentiles Against Each Concatenated Grade And Region
Oct 28, 2008I have a dataset (20,000rows) with Grade, Region and Salary. I need to calculate the 25, 50, 70 and 90 percentiles against each concatenated Grade and Region.
Creating A Range After Creating A Different One
Dec 22, 2008I am trying to build a selection for a procedure to use.
View 2 Replies View RelatedCreating Add-ins
Nov 12, 2008I need some help about creating add-ins to distribute my macro.
I have written a macro and have saved it as an .xla file.
What i want is that when this add-in is installed an extra button appear on the menu bar and when users click the button the macro should run.
I tried to install the add-ins but am having some trouble in creating a button automatically when add-in is installed and assigning a macro to it?
I tried to look through some books and on some internet websites but really cant figure out.
Creating PDF Of More Than One Sheet?
Mar 28, 2014I have an issue creating a PDF of more than one sheet. Only top left corner of sheets are shown in PDF. Creating a PDF of a single sheet works perfectly. I have attached the result (2 pdf-files) and the original Excelfile.
Code for one sheets (Result OK):
[Code] ......
Code for multi sheets (Result not OK):
[Code] .........
Attached Files
CreatePDF.xlsm
MyPDF_OneSheet.pdf
MyPDF_3Sheets.pdf
Creating A PivotTable Using VBA
Apr 30, 2014I am unsure if this is supposed to be in the PivotTable or VB section, but given it is VB code I expect here is better.
[Code] ......
I can confirm the SourceData exists, and can be used to create a pivot table without error. Only when I try to RUN this code does it kick out saying, "Invalid procedure call or argument".
Creating New Tab And Then Renaming It?
Mar 5, 2014I am tying to build a macro that contains a function to open a closed workbook, create a new tab, select the tab and then paste data into it before closing the workbook.
In a separate macro I will then want to open the workbook again and compare the last two tabs worth of data, to highlight where old data has been removed.
Creating Search Bar Using VBA
Mar 26, 2014I'd like to create a search bar where someone types text into a field in Sheet1 (in the sample B1), then clicks a macro button to search for that word in Sheet2.
The result should be that the cell containing that word is where you end up.
The search word shouldn't be an exact match for the result, the cell just needs to contain it.
The search bar should also be present on Sheet2, with an additional button for Find Next, so that the user can move to the next result if the first one is not what they're looking for.
I've managed to create a search function with a pop up box using the below but this isnt as effective.
[Code] .....
Sample.xlsx
Creating Sub Menu's
Oct 18, 2008I am using the following code to build and remove a menu on the menu bar. how to modify this to create sub menu's instead of a single drop down list
View 2 Replies View RelatedCreating New Tab Syntax
Nov 25, 2008if I copy and Add it created a new workbook not the current on im in. What am I doing wrong?
View 5 Replies View RelatedCreating Tab Rows
Dec 9, 2008I have worksheets with many Tabs, I wanted to know if it was possible to create Rows of Tabs? I have included a picture of what I am talking about.
View 3 Replies View RelatedCreating Buttons Using VBA
Dec 16, 2008I'm trying to make a macro that creates a button (to run another macro). I'm also trying to make sure this has a specific name, instead of just "Button#". The code I get from recording this is:
View 5 Replies View RelatedCreating A Userform With VBA
Feb 5, 2009On a worksheet i have a list of names in Column A the list length can vary this is why i want to create a userform using VBA. The form just wants a checkbox with name next to it for each name in column A. If the checkbox is ticked I want a 'Y' in Column B next to the corresponding name.
View 4 Replies View RelatedCreating A VBA Chart
Jul 8, 2009I have wriiten some simple code to create a chart which works fine. I have a problem applying formatting to my chart. I am using the With construct to apply the formatting, but the problem is that the chart name keeps on incrementing from "Chart 1" to Chart 23" etc. each time I run the chart and I get an error message before the With code?
View 2 Replies View RelatedCreating Two Menus
Oct 11, 2009I have a workbook which uses the code below to create a new menu upon opening. I have now used this same code in a second workbook to create a different menu. both work OK on their own However if by chance both workbooks are opened at the same time only one menu is shown. Is there a way I can change one of these to create a second menu if the first one is already there?
View 4 Replies View RelatedCreating An If Then Macro
Feb 3, 2010I am creating a macro that when cell range H7:H78 = x then the cell in the same row but column A changes to r. This is what I have so far.
View 4 Replies View Related.0 Is Creating #VALUE! Error
Apr 7, 2006I am currently using the following formula:
=(H21*60)-IF(MID(H21,FIND(".",H21,1),5)>0,(MID(H21,FIND(".",H21,1),5)*60),"")+(MID(H21,FIND(".",H21,1),5))
However, I get the results of #VALUE!
In cell H21, the value is 27.00
How do I force excel to recognize the .00 in the formula?
Creating A List..
Feb 6, 2009I thought this would be a simple task, but i cant seem to figure out how to do this.
I have a list with names and its a fixed number of rows, say A1:A200. In the next column, B1:B200, there is either TRUE or FALSE. I want a make a new list with all names with "TRUE" on the same row, without any blanks. How can I do this?
Creating A Timesheet ....
Jan 1, 1970Not sure where the best to ask this is so i'll do it here.
I have a h:mm time which i need to get converted into days/hours/minutes, creating an on the fly phrase of something like "2 days, 4 hours, 32 mins" for example.
eg: 26:45 (hours/minuts) to be converted to "1 day(s), 2 hours, 45 minutes"...
Creating New Sheet With Name Same As That CC
Nov 7, 2011I am struggling with task when i have list of cost centers (appr. 100) and for each one of them i need to create new sheet with name same as that CC.
View 1 Replies View RelatedCreating 3D Bar Graph
Feb 10, 2013I want to create a graph as showed below.
Actual graph will contain a larger/longer X-axis (40 instead of 6 readings), but no more than 2 rows af data (A and B), of which one has a seqenced number af data (row B).
Row B alo has got singular points of data superimposed over the cylinders.
I have got all the numbers ready, but I don't know whether or not it is even possible to create a graph like this.
The cylinders have values up to 45.000 (accumulated in row B), the points (black dots) go from 2 to 6.
If so, I'm having trouble selecting the correct template out of the excel's standard list of graphs.
Creating N-tuples Of 1's And 0's
Nov 18, 2006Is there an easy way in Excel to generate all of the 512 possible combinations of 1 and 0 in a 9-tuple (9 consecutive numbers with each number either being 1 or 0)?
For example:
1, 0, 1, 0, 1, 1, 1, 0, 0
1, 1, 1, 0, 1, 1, 1, 0, 0
etc.
Creating A Query
Mar 29, 2007I have a table that contains data for a region broken down into North South East and West areas.
New data is added to one spreadsheet (Region).
What I would like to do is have information for the North team automatically moved (or copied via a link) to the North sheet for printing off.
Creating A Chart ..
Apr 21, 2008I have creating a chart. All the information in the source data appears to me to be ok but the chart isn't been displayed.
View 9 Replies View RelatedCreating Reports
May 14, 2008I am trying to create a report that takes two user inputs and looks them up on another worksheet in the workbook and returns the right value. As an example I have the user input a date and a job location and on another sheet there is also a date and a job location that has a population associated with it. Is there a way to return this information so that it changes whenever the user changes these two criteria
View 9 Replies View RelatedCreating All Possible Combinations
Nov 24, 2008I am trying to create a combination list. I have 48 items and I want to create all possible comibinations of 3 items from this group of 48 items.
I did something similar to create all possible combinations of 2 items from the group of 48 items in the attached spreadsheet. This was done manually and was time consumning. I want to do something similar for all possible combinations of 3 items from this group of 48 items.
All my 48 items are listed in rows 4 and 5. I want to enter the number "1" in each column to indicate my selection. Right now I have 2 ones per row. But I want to do 3 ones per row.