You are here: HomeExcelTutorials

# sample vs. population proportion using a z-score in excel

## sample vs. population proportion using a z-score in excel

Price: FREE

Needed some help on finding a formula to use in excel to calculate a z- score that is comparing a sample proportion to a population
proportion. Here's the data:
Sample proportion = 0.31
N = 998
Population proportion = 0.49
I can find a z-score using a formula by hand: (z-score = -11.39), but wanted to calculate in excel for many other variables. This is the formula I used by hand:
p = sample proportion
Po = population proportion
alpha = 0.05 (z-critical = plus/minus 1.96)
non-directional test
z = (p-Po)/square root((Po(1-Po))/N)
When I use the standardize function in excel it gives me = -0.1153.

Visit publisher's web-site: sample vs. population proportion using a z-score in excel

Category and Tags: ExcelTutorials :

## Related Tutorials

### Proportion of Averages

Free: Yes
Tags: Excel ›

I'm not particularly skilled in mathematics, but I am trying to determine the true average of a simple table of scores:
Name, ExamQty, Score
Jim, 1, 10
Bob, 2, 5
Average = 8.33
Preferably I would like a formula in column D that when summed or averaged, it will provide me with 8.33

### Pull a Sample from a Population

Free: Yes
Tags: Excel › Functions

I need a statistically valid, randomly selected breakout of transactions from a total population of all transactions. Would like to have Excel generate a statistically valid list from a total population of about 38K transactions. All 38K transactions, regardless of dollar value, are subject to review through random selection based on the n of total population. The list should also induce any transaction >= \$5,00. The listing should include all data elements of the select transactions.

### Display sample population size in chart i.e. n=X

Free: Yes
Tags: Excel › Charts

Does anyone know if Excel can display the sample group population within the chart i.e. N=100, (if 100 people answered the question) obviously this can be done manually but it would be cool if excel could do it itself.
The reason I want to do this is so the reader of the graph can gauge the significance of the % figures, my chart is reading of a pivot table which I plan to update over time with new data so has to be dynamic, maybe there is another solution which could work,

### How to graph normal distribution curve

Free: Yes
Tags: Excel › Charts

at Excel and need help graphing a sampling distribution of of the sample proportion. sample is 150, sample proportion is .15, std deviation is .029 How do I make a normal bell curve?

### how to get population standard deviation in descriptive statistics?

Free: Yes
Tags: Excel ›

The standard deviation in "descriptive statistics" in "data analysis" is sample standard deviation not population SD. How can I get the population SD?

## Related Applications & Scripts

### SFESurvey : Create multiple choice quiz

Free: Yes

SFESurvey will allow you to create multiple-choice quizzes or surveys online with a twist. Rather than having one correct answer, and multiple incorrect distractors, each possible answer is weighted or assigned a certain number of points. The instructor/test creator can then assign various comments or scores to different ranges of raw scores.
The quiz taker's score and any additional fields you choose (Name, Age, Gender, Occupation, Favorite Color -- whatever you like) are saved to a score database, but there is currently no option to view scores or score statistics

### Popular on Twitter Widget

Free: Yes

Another Topsy-enabled jQuery plugin to list the most popular posts on your website, from your Twitter timeline or for some keyword within a selected period of time.
Links are displayed with number of tweets and score -which is calculated by the influence of the people talking about them and affects on sorting those links.
Widget Features:
Display popular posts on a website, from a Twitter username or for some keyword.
Select the window of time: today, this week, this month. or let Topsy automatically pick the most relevant window.
Display links as a bar with transition effects or as a fixed list.
Many transition options like opacity, height, font-size.
Each part of the link like Title, Score, Hashtags. has its own class for easy CSS customization.
Show or hide some parts of the link like tweet, score, number of tweets.
Use a typical JS call or auto-load div elements that have "popular-on-twitter" class.

### Viewer 360 Product Rotation

Free: No
Tags: Flash › Excel Carousel

Viewer360 loads a sequence of unlimited number of images of any size (photos or 3D renders) and allows the user to rotate and zoom. You can use it in a e-commerce, inside your flash website or in your facebook page.
Features
- XML powered
- no Action Script knowledge required
- unlimited number of images
- use images of any size ( it automatically fits the images in the viewer keeping the proportion )
- mouse wheel zoom
- file formats JPG and PNG

### Database Editing Sample

Free: Yes
Tags: ASP › Excel CRUD Databases

This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a database table. It illustrates a number of useful techniques for database manipulation.

### Premium Memory Puzzle Game XML/AS3

Free: No
Tags: Flash › Excel Games PHP

This is a premium memory matching puzzle game. The card flip animation is real 3d taking advantage of the Flash player 10 native 3d capabilities. It supports furthermore real-time shading and motion blur. The memory game can be of any size with as many cards as you like. The cards can have any size. The grid for placing the cards can be freely chosen. Cards with different images can be declared to match (e.g. a shoe and a hat should match because they are related in terms of clothes). It can be configured that not only 2 cards have to be matched like in the classic game but you can declare an arbitrary set of cards with all kind of images to have to be matched (in the demo above e.g. there are three shoes to be found .
The component is freely resizable and XML driven. A puzzle can be easily defined in a XML file. This puzzle XML file allows you to set
- a cover picture
- You can freely define a memory grid/distribution for the cards in rows and columns (53 or 62 e.g.)
- as many memory images to be discovered as you like. If you specify more images than fit in the grid the relevant ones will be chosen randomly.
- Whether matched cards should disappear or stay on the stage.
- a time limit for solving the puzzle(s) if desired
- once you finished a puzzle it is presented to you a results screen with some key statistics and a score
- if the players results should be stored in your database (it is saved to the database: players email, date of play, score, time, percentage completed, id of the puzzle played)
- you can set the importance the time should have in the score
- if the game should be in exam or regular mode (in exam mode the hint functionality is disabled)
- it can be configured how fast the card should flip around
- show duration can be freely set (this is the time a flipped card is shown before be hidden again if it is not matching)
There is a PHP / MySQL back-end included to store the players results in a database. FlashVars are supported to set the puzzle XML file location in the HTML file.