What is the command sequence for the XL Data Analyst to perform cross-tabulation analysis and generate row and column percentage tables?
A) Go—Boolean
B) Summarize—Boolean—Cross
C) Relate—Crosstabs
D) Relate—2 Variables
E) Relate—Boolean—Stacked Bar
C
You might also like to view...
"What's the purpose of a website?" and "Who should be responsible for it?" are among significant questions that must be answered before a website is created if that website is to be successful
Indicate whether the statement is true or false
Last year, the Parker family used to eat at nice restaurants almost four times a week. Even though Mr. Parker received a 2 percent pay raise, the cost of living rose by 4 percent and property taxes went up 5% in their community. As a result, the family now eats most of their meals at home, dining out only a few times a month. This reflects
A. a reaction to a loss of discretionary income. B. a decrease in the number of fine restaurants that can stay in business during times of economical downturn. C. a significant drop in disposable income since there was a negative gain in income. D. a rise in deflation. E. a shift from spending to investing.
In the Exempt Model, the earnings are excluded from explicit taxation.
Answer the following statement true (T) or false (F)
The balance sheet and income statement for Johnson and Breakwater is presented below
Balance Sheet (000) Cash $500 Accounts receivable 1,500 Inventories 500 Current assets 2,500 Net fixed assets 5,000 Total Assets 7,500 Accounts payable 1,200 Bank note 300 Total current liabilities 1,500 long-term debt 4,000 Common stock 300 Retained earnings 1,700 Total liabilities and owners' equity $7,500 Income Statement (000) Net sales $8,500 Cost of goods sold (3,400) Gross profit 5,100 Operating expenses (2,900) Net operating income 2,200 Interest expense (580) Earnings before taxes 1,620 Income tax (34%) (551) Net income $1,069 a. Compute the following ratios: Current ratio, Acid test ratio, Debt ratio, Total asset turnover, Operating profit margin, Return on total investments, Times interest earned, Inventory turnover. b. All other things equal, compute the dollar amount of sales needed to achieve an 18% return on total assets for the coming year. c. Given Johnson's inventory turnover ratio, find a way of computing the current level of inventory given this ratio and assuming the current level of inventories is unknown. Set up but do not solve.