Problems With Using Microsoft Excel for Statistics

File title:
Problems With Using Microsoft Excel for Statistics

File content:
Example: Excel Graphics With False Third Dimension (taken from JSE!), Example: Pyramid Charts, Example: Excel Default Scatterplot, Example: Excel Default Histogram, Example: Excel Histogram (stretched vertically to read labels), Example: Excel 2000 Help Screen for the Two-sample T-Test, Example: Excel 2000 Confidence Function, Example: Excel 2000 STDEV Function.

File format: PDF

File size: 413 kb

File url:
http://www.cs.uiowa.edu/~jcryer/JSMTalk2001.pdf

OpenOffice.org’s Documentation of the Microsoft Excel File Format

File title:
OpenOffice.org’s Documentation of the Microsoft Excel File Format

File content:
Introduction
License Notices, Abstract, Byte Order.

Document Structure
Document Types, The Binary Interchange File Format, File Structure, BIFF Record Structure, Common Record Substructures.

Formulas
Common Formula Structure, Token Classes, Cell Addresses in Tokens, Token Overview, Unary Operator Tokens, Binary Operator Tokens, Function Operator Tokens, Constant Operand Tokens, Operand Tokens, Control Tokens, Built-In Sheet Functions.

Worksheet/Workbook Stream
Worksheet/Workbook Stream, Record Order in Streams and Substreams, Calculation Settings Block, Page Settings Block, Sheet View Settings Block, Cell Formatting, Cell Table and Row Blocks, Array Formulas and Shared Formulas, Multiple Operation Tables, Internal and External References, Shared String Table (BIFF8), Conditional Formatting Table (BIFF8), Hyperlink Table (BIFF8), Data Validity Table (BIFF8), AutoFilter, Advanced Filter, Scenarios, Web Queries (BIFF8), Worksheet/Workbook Protection, File Protection.

Worksheet/Workbook Records
Overview, Ordered by Record Identifier, Overview, Ordered by Record Names, Overview, Ordered by BIFF Versions, ARRAY, BACKUP, BITMAP, BLANK, BOF – Beginning of File, BOOKBOOL, BOOLERR, BOTTOMMARGIN, BUILTINFMTCOUNT, CALCCOUNT, CALCMODE, CFHEADER, CFRULE – Conditional Formatting Rule, CODEPAGE, COLINFO, COLUMNDEFAULT, COLWIDTH, CONTINUE, COUNTRY, CRN, DATATABLE – Multiple Operation Table, DATATABLE2 – Multiple Operation Table, DATAVALIDATION, DATAVALIDATIONS, DATEMODE, DBCELL, DCONREF – Data Consolidation Reference, DEFAULTROWHEIGHT, DEFCOLWIDTH, DEFINEDNAME, DELTA, DIMENSION, DSF – Double Stream File, EOF – End of File, EXTERNALBOOK – External Workbook, EXTERNALNAME, EXTERNCOUNT, EXTERNSHEET, EXTSST – Extended SST, FILEPASS, FILESHARING, FONT, FONT2, FONTCOLOR, FOOTER, FORMAT, FORMULA, GCW – Global Column Width, GRIDSET, GUTS, HCENTER, HEADER, HIDEOBJ, HORIZONTALPAGEBREAKS, HYPERLINK, INDEX, INTEGER, ITERATION, IXFE – Index to XF, LABEL, LABELRANGES, LABELSST, LEFTMARGIN, MERGEDCELLS, MULBLANK – Multiple BLANK, MULRK – Multiple RK, NOTE, NUMBER, OBJECTPROTECT, PAGESETUP, PALETTE, PANE, PASSWORD, PHONETICPR, PLS, PRECISION, PRINTGRIDLINES, PRINTHEADERS, PROTECT, QUICKTIP, RANGEPROTECTION, REFMODE, RIGHTMARGIN, RK, ROW, RSTRING, SAVERECALC, SCENPROTECT, SCL, SELECTION, SHAREDFMLA – Shared Formula, SHEET, SHEETLAYOUT, SHEETPR, SHEETPROTECTION, SORT, SST – Shared String Table, STANDARDWIDTH, STRING, STYLE, TOPMARGIN, UNCALCED, USESELFS, VCENTER, VERTICALPAGEBREAKS, WINDOW1, WINDOW2, WINDOWPROTECT, WRITEACCESS, WRITEPROT, XCT – CRN Count, XF – Extended Format.

Drawing Objects

Charts
Document Integration, General Chart Structure, Common Record Blocks, Record Overview, Ordered by Identifier, Record Overview, Ordered by Name, CHAREAFORMAT, CHAXISLINE, CHBEGIN – Begin of Block, CHEND – End of Block, CHFRAME, CHLINEFORMAT, CHSOURCELINK, CHSTRING.

PivotTables

Change Tracking

Workspace Documents
Workspace Stream, Overview, Ordered by Record Identifier, INDEX, SHEETHDR, SHEETSOFFSET.

File type: PDF

File url:
http://sc.openoffice.org/excelfileformat.pdf

 File size: 1.14 mb

Tutorial – Microsoft Office Excel 2003

File title:
Tutorial – Microsoft Office Excel 2003

File content:
Introduction, Opening Excel, Standard Toolbar (New, Open, Save, Permission, Print, Print Preview, Research, Copy, Paste, Undo, Insert Hyperlink, AutoSum, Sort Ascending, Chart Wizard, Microsoft Excel Help, More Options), Formatting Toolbar (FOnt, SIze, Bold, Italics, Underline, Align Left, Center, Align Right, Merge & Center, Currency Style, Percent Style, Decrease Indent, Border, Fill Color, Font Color), Navigating the Spreadsheet, A Simple Spreadsheet, Simple Formulas, Insert Rows & Columns, Sorting, Cell Formatting, Chart Wizard.

File type: PDF

File url:
http://getit.rutgers.edu/tutorials/excel/media/excel.pdf

File size:
246 kb

MySQL®

File title:
MySQL®

File Content:
How cPanel Distributes and Installs MySQL on Linux, How cPanel Distributes and Installs MySQL on FreeBSD, What Version of MySQL does cPanel currently install?, MySQL Version File Example, Choosing the Version of MySQL that is Right for You, Manually Upgrading MySQL, Manually Upgrading MySQL: How it is Actually Done, The cPanel Naming Conventions and how they Work with MySQL, How cPanel and MySQL Interact, Possible Errors with cpwrap, Basic MySQL Troubleshooting, Scripts Included with cPanel to Help Troubleshoot MySQL, MySQL and Perl Scripts, Additional MySQL Troubleshooting.

File url:
http://www.cpanel.net/docs/seminar/MySQL.pdf

File type: PDF

File size: 148 kb