Percentiles - Microsoft Access / VBA

Andy Chalkley

Hi
My customer wants salary statistics for a number of similar organisations
expressed in percentiles something like the following:

Administrator Salary Total package
25 precentile $xxxxx $xxxxx
50 precentile $xxxxx $xxxxx
75 precentile $xxxxx $xxxxx
Average $xxxxx $xxxxx

Librarian Salary Total package
25 precentile $xxxxx $xxxxx
50 precentile $xxxxx $xxxxx
75 precentile $xxxxx $xxxxx
Average $xxxxx $xxxxx

Etc etc etc for numerous groups.

Any good ideas.

Andy Chalkley

Nov 12 '05 #1

Subscribe Reply

2374

Enrico Palazzo

Ola Andy:

It's a little unclear what the comparisons are, but as a general suggestion
you might try using your Access database and data in a detail level query as
the source for an Excel Pivot table. Pivots kick hinder when trying to
complex analysis. You can present dynamic 'Percent of Row', 'Percent of
Column' and running totals as well as simple statistical analysis.
Depending on the source, you may also be able to define custom grouping
levels within columns.

=============== =============== =============== ==============
Rich Harrington - Prairie State College MIS
x3785
=============== =============== =============== ==============
a man's GOT to know his limitations...

- uncle Clint

-30-

"Andy Chalkley" <an***********@ yescomputer.com .au> wrote in message
news:3f******** @quokka.wn.com. au...

Hi
My customer wants salary statistics for a number of similar organisations
expressed in percentiles something like the following:

Administrator Salary Total package
25 precentile $xxxxx $xxxxx
50 precentile $xxxxx $xxxxx
75 precentile $xxxxx $xxxxx
Average $xxxxx $xxxxx

Librarian Salary Total package
25 precentile $xxxxx $xxxxx
50 precentile $xxxxx $xxxxx
75 precentile $xxxxx $xxxxx
Average $xxxxx $xxxxx

Etc etc etc for numerous groups.

Any good ideas.

Andy Chalkley

Nov 12 '05 #2

Similar topics

14987

Creating Deciles

by: Indraneel Sheorey | last post by:

Hello, I want to set up a query in SQL Server that is "grouped by" a variable PRICE. Since PRICE takes on continuous decimal values, I want to create deciles based on this variable and then display the average price in each decile. As background, PRICE is a calculated quantity: I divide a table field SLS_DLRS by a field SLS_UNTS to get it. I also want to include an average SLS_UNTS for each decile. So essentially, I want the result...

Microsoft SQL Server

4201

different style sheets for screen/printing?

by: Geoff Cox | last post by:

Hello, I publish some web pages using large fonts and would like to give the user the opportunity to print the pages using a smaller font. I believe that this is possible using different style sheets? I am not clear how the user would select the different .css files? Seems to be easier than having duplicate html files ...

HTML / CSS

2197

Passing report results as the argument in a custom/user-defined function

by: CapeCoder | last post by:

I'd like to use the Excel.WorksheetFunction library to compute median and percentiles in a user-defined function. I'd like to use the data from the calling report as the function argument. Example: The report's Record Source is a query that fetches salaries from a database, "SELECT JobID, JobTitle, BaseSalary ORDER BY JobTitle". The report groups BaseSalary by JobTitle.

Microsoft Access / VBA

4423

Excel.WorksheetFunction Argument in User-Defined Function

by: CapeCoder | last post by:

I'd like to use the Excel.WorksheetFunction library to compute median and percentiles in a user-defined function. Rather than creating a SQL dataset in the function, I'd like to use the data from the calling report as the function argument. Example: The report's Record Source is a query that fetches salaries from a database, "SELECT JobID, JobTitle, BaseSalary ORDER BY JobTitle". The report groups BaseSalary by JobTitle.

Microsoft Access / VBA

1116

Percentiles in Access97

by: AnilKumar | last post by:

Hello, We have a task which comprises of calculating percentile for a group of users based on some observations which are on Daily as well as hourly basis(observations). We are having a tough time to accomplish this task. Please help us in solving the problem. we tried different methods but could get the results. we also tried to work out the example given at:...

Microsoft Access / VBA

13185

Help with Excel Complex Formula

by: cowboyboborton | last post by:

Looking for some help here. I've tried to solve this, but I just can't. What I need to know is what formula to use in an excel calculation to complete the following calculation. It's in two parts. If first finds a natural logarithm, then converts it to a percentile. Even if I had to do it in two steps on the spreadsheet, I can't determine the calculations. *************************************************** Logarithm System The...

Microsoft Access / VBA

12808

'erf' function in C

by: James Harlacher | last post by:

Hi, Are there any C compilers which have the erf function (from probability) as part of their math libraries? Or are there any math libraries available to download which implement this function? Thanks, James Harlacher

C / C++

1869

PivotChart Decimal Place on Fixed Number Format on Averaged Field

by: pomeroymiles | last post by:

I have a pivotchart which I cause to take a huge list of people's test percentiles and calculate the average for each year. I then display the average above each bar. The problem is that there are too many numbers after the decimal place for each figure. I went into the properties and changed the number format to "fixed" but it doesn't give me the option to change the number of decimal places that are used (it does every where else in MS...

Microsoft Access / VBA

1895

what python technology for my app?

by: Chris | last post by:

I have an database containing lots of numerical data. I want to write a browser based interface that will allow selection of various key parameters and yield tables, plots and/or printouts of the data according to the selections. Ultimately I want this to run on an intranet so that others can get access via their browsers. The application is for in-house use only and not likely to have more than a few users at any one time. I've managed...

Python

8706

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8631

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9199

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

7787

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5889

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4392

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4641

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2366

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2016

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General