Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sample vs. population proportion using a z-score in excel
To all,
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. Any suggestions? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sample vs. population proportion using a z-score in excel
"Christopher" wrote in message ... To all, 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. Any suggestions? Thanks! Hello Christopher I may be able to help with some code but first I wish to clarify your need. So you have a population of data You have calculated or dervied 95 % ci limits for the mean of this data ? Individual P values either fall inside ( + or - bias) out side the Ci limits Those values outside the Ci limits have unsatifactory Z scores ? Z scores are a function or in some way related to the number of std deviations a value of p diverges from upper or lower Ci concesus values ? Best N10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sample vs. population proportion using a z-score in excel | Excel Worksheet Functions | |||
Display sample population size in chart i.e. n=X | Charts and Charting in Excel | |||
Pull a Sample from a Population | Excel Worksheet Functions | |||
Make a sheet to enter score and score is copy to the proper cell.. | Excel Worksheet Functions | |||
Determine Valid Sample Size from a Population - Any UDFs or Formulas? | Excel Programming |