Public Direction


Giving all citizens a say in the federal budgetary process.

Public Direction RSS Feed

Testing the Formula


This page includes several spreadsheets that were used to test the basic formula used with Public Direction. They simulate random samples of user ratings and display the budgetary changes of each department.

All random samples were generated with the randbetween() function of Excel and OpenOffice.


-------------------


Spreadsheets


Averages (.xls) and (.ods)

Md5 (.xls): c6d6401db85bd4f930999bff1d37e08a (Updated: 08-24-2010)

Md5 (.ods): 4ba0cefa649524fb7cf82f6b379dd7f9 (Updated: 08-24-2010)


This spreadsheet contains a random sample of 100 simulated voters . Their ratings span the entire scale, from 0 to 10.


Averages 0-2 (.xls) and (.ods)

Md5 (.xls): f2e6977be2ded42010822814e9116e59 (Updated: 08-24-2010)

Md5 (.ods): a01d80a5d3be221f875f69d325598cb4 (Updated: 08-24-2010)


This spreadsheet contains a random sample of 100 simulated voters. Their ratings span only the lower end of the scale, from 0 to 2.


Averages 8-10 (.xls) and (.ods)

Md5 (.xls): 4c6c8a963496c5b31a61bb739d62dad0 (Updated: 08-24-2010)

Md5 (.ods): c6088dd195ec6f41ce332d5103826143 (Updated: 08-24-2010)


This spreadsheet contains a random sample of 100 simulated voters. Their ratings span only the upper end of the scale, from 8 to 10.


Averages 0-2 and 8-10 (.xls) and (.ods)

Md5 (.xls): 9680e557671340ddc3dd38de4a09492c (Updated: 08-24-2010)

Md5 (.ods): 0799eb3c0e6b2c0b076fed373f783633 (Updated: 08-24-2010)


This spreadsheet contains a random sample of 100 simulated voters. Their ratings span both the lower and upper ends of the scale, from 0 to 2 and from 8 to 10.



----------



Creative Commons License
http://www.publicdirection.com
by Casey Houser and Christian Yaeger
is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Powered by Laughing Squid