Variations in means/statistical calculations

From mtab wikisupport
Revision as of 17:36, 8 August 2013 by Mtabadmin (Talk | contribs)

Jump to: navigation, search

Means, the most common statistical calculation, and some other calculations sometimes appear a little differently in mTAB vs other packages such as SPSS, or even show up just as zeros. The zero occurrence can be easily taken care of, especially in the short term and the numbers varying slightly can usually be dealt with as easily.

How are Means Calculated?

Each response to a numeric question is usually associated by mTAB with a statistical value or range. If the response to a question is 100, then usually the statistical value would also be 100.

However, ranges work differently and there are two kinds of range questions. Some range questions come that way from the survey itself. For example, respondents are asked what income range they fall into.

How does it work

Ranges work.


How Are Means Calculated?

Each response to a numeric question is usually associated by mTAB with a statistical value or range. If the response to a question is 100, then usually the statistical value would also be 100.


However, ranges work differently and there are two kinds of range questions. Some range questions come that way from the survey itself. For example, respondents are asked what income range they fall into. The other kind of range question is the kind we implement here at mTAB. For example, if a respondent is asked to write in his income in thousands, you do not want to look at every break of 1,000. That is a useless amount of detail, especially in higher income brackets, so we cluster the respondents into ranges that are more useful. Our older ranges would automatically give ANY respondent who falls between 100,000and150,000astatisticalvalueof125,000evenif90ofthesepeopleactuallyfallinthe100,000to120,000range.Thiswouldobviouslyskewthenumbers.Inolderdatabases,thereisnothingthatcanbedoneaboutthatunlessyouwanttoguesswheretheserespondentsfallandthenmanuallyalterthestatvalues.Thismaybeusefulsometimeswhenthelastresponsetoaquestionis"100,000ormore."Inacaselikethistheupper(righthand)statvaluemaybehigherorlowerthansomeonewhoknowsthedatawellwouldwant.Innewerdatabases,wehaveanewwayofhandling"fillintheblank"stylequestionswhichweputintorangeswhichwecall"ValueFields".Thisvaluefieldputstherespondentsintotherangetheybelonginasbefore,butrememberstheexactdatavaluetheyprovidedaswell,forcalculatingmeans.ThisabilitywasintroducedinSeptember1997andisnowbeingusedinallstudiesandimplementedinoldertrackingstudiesastimepermits.Ifaquestionusesavaluefield,editingthestatvaluesdoesnotchangethestatisticalcalculations.FixingZerosOrChangingStatValues[[File:Sigtestingvariationsinmeanssubset.jpg|thumb|right|x350px]]Firstoff,thequestionyouaretryingtofindameanforshouldhavesomenumericstatisticalvalueassociatedwithit.Ifitdoes,thensetupyourtabasusual.Whenyouarefinishedsettingupyourtab,gotothesubsetwindowforthequestionthatyouarenotgettingameanfor.Inthiswindowyouwillseeontheleftalistofresponsessuchas"100" or "100200". On the right you should notice two empty columns. Just click on the first empty column to the right of 100forexampleandtypein100thenhitenter.Orifitwasarangelike100-$200 you should type 100 in the first column to the right of that response, and 200 in the second column. Do this for all the responses that need a statistical value. "No Answer" should not have a statistical value associated with it.


Now when you run your tab, you can get means and other statistical calculations.


NOTE: If a question uses a value field, editing the stat values does not change the statistical calculations. The only way to alter the mean for a value field question is to deselect the responses you want left out of the subset window by highlighting a particular response and hitting backspace to put a minus sign by the response. This eliminates it from the sample when you run your tab. If you merely select the responses you want included, subsetting will not work, you can only deselect the responses you do not want.


Ratings/Scoring type questions are usually not value field, fill in the blank number questions usually are.