522 - Quiz 4

Question 1

Excel Memory Limit

Answer 1

2GB

Question 2

Periodic Graph - purpose

Answer 2

Comparative graphs for period-over-period analysis

Shows time sensitive totals/min/max, ext.

Question 3

Data Histogram/Frequency Graph - purpose and design characteristics

Answer 3

Shows distro of data
Number of data points in a range
Upper/lower bounds defined:
    Lower: >
    Upper: <=

Question 4

Data Histogram/Frequency Graph skews (3)

Answer 4

Pos = Bias toward sm. numbers and fewer lg. numbers (long tail in the positive direction)
Neg = Bias toward lg. num. (long tail in the negative direction)
Zero = All numbers are evenly distro'd

Question 5

Data Stratification - purpose and details (3)

Answer 5

Verfies Completeness Assertion

1. normal expected ranges
   a. credit memos
   b. low value invoices
2. too many zeros
3. negative amounts - shouldn’t exist for PR, Inv., mileage records..

Question 6

Row limit

Answer 6

2^20

Question 7

Col Limit

Answer 7

2^14

Question 8

Delimiters

Answer 8

CSV - comma separated data points

Tab Delim - TAB char (009) separated data points

Question 9

Copy Data from Access to Excel

Answer 9

Use “From Access” instead of copy/paste from access (data must also be complete)

Question 10

How to tell if imported data is complete or not?

Answer 10

Imported data is likely incomplete if = 16,384 records (the upper limit of excel col space?)