Susan Is in Charge of the Inventory Reports for Her

question 14

Multiple Choice

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2013 Analysis tools.
-Susan designs a worksheet with the inventory number,description,quantity,unit cost,reorder point and value. To find values in tables of data,and insert them in another location in the worksheet such as cells or in formulas,she will use ________.

• A)Max function
• B)Lookup function
• C)CountA function
• D)Sum function

---

Definitions:

Home Prices

Refers to the cost at which houses are bought and sold in the real estate market.

Null Hypothesis

A default hypothesis in statistical inference that suggests no statistical significance or effect exists within a set of observations.

Significance Level

A threshold in hypothesis testing that determines the probability of rejecting the null hypothesis when it is actually true, commonly denoted as alpha (α).

One-Way ANOVA

A statistical test used to compare the means of three or more independent groups to determine if there is a significant difference among them, based on one independent variable.