When Using XL Data Analyst to Compare Two Mutually Exclusive

question 46

Multiple Choice

When using XL Data Analyst to compare two mutually exclusive groups as to their respective percentage on a category of some variable,you must define:

• A)a grouping variable to identify groups and a target variable
• B)a target variable to identify groups and no other variable
• C)a grouping variable on which the percentages are calculated
• D)the hypothesized value
• E)none of the above; XL Data Analyst cannot perform this task

---

Definitions:

Financial Futures

Contracts to buy or sell financial instruments, like currencies or government bonds, at a predetermined future date and price.

S&P 500 Index

A stock market index in the United States comprised of 500 major companies with publicly traded shares on the New York Stock Exchange or NASDAQ, determined by their market capitalizations.

Nikkei Index

A stock market index for the Tokyo Stock Exchange, representing the performance of leading Japanese companies.

Futures Price

The agreed price for the future sale or purchase of an asset in a futures contract.