2. (LO 3.1, 3.4, 3.5, 3.6, 3.8) Match each business analytics statistical function in Excel’s Analysis ToolPak to its use.

Business Analytics Statistical Function Use 1. correlation

a. To determine if there is a significant difference between the means of two groups or two data sets 2. regression

b. To understand if and the extent to which variables are related to each other 3. descriptive statistics

c. To understand the basic statistics, including the mean, standard deviation, minimum, and maximum of a data set 4. histogram

d. To understand the frequency of the data using a display of rectangles with area proportional to the underlying frequency of the data 5. t-tests

e. To understand the relation between specific dependent variable values and independent variable inputs