(LO 5-2, LO 5-3, LO 5-4, LO 5-5, LO 5-6) Select the type of Excel’s Data Analysis Toolpak statistical function that best describes the function of the tool.

Transcribed Image Text:

Data Analytics Statistical Function Correlation Regression Descriptive statistics Histogram t-tests Function of Tool To understand the probability of a difference in means between either two independent samples or a paired sample through time To understand if and the extent to which variables are related to each other To understand the relation between specific dependent variable values and independent variable inputs To understand the basic statistics, including the mean, standard deviation, minimums, and maximums of a dataset To understand the frequency of the data using a display of rectangles with area proportional to the underlying frequency of the data