MSIS 3223 Exam 1 - Okstate Questions + Answers Graded A+

"centering" of a set of data - Measures of location provide estimates of a single value that in some fashion represents the absolute address - An absolute address uses a dollars sign ($) before either the row or column or both (for example $A2, C$23, or $B$15) Add third dimension to analysis in Pivot Table - Dragging a field into the Filters area in the PivotTable field list Addition in excel - + Advantages of Using Tableau - Fantastic Visualizations, In-depth Insights, User-friendly Approach, Working with Disparate Data Sources, Adding Datasets, Switching Between Visualizations AND(condition1, condition 2 . . . ) - a logical function that returns TRUE if all conditions are true and FALSE if not area chart - combines the features of a pie chart with those of line charts Average - the most common, and called the arithmetic mean (or simply the mean) which is the sum of the observations divided by the number of observations AVERAGE(range) - finds the average or mean of the values in a range of cells bubble chart - type of scatter chart in which the size of the data corresponds to the value of a third variable; consequently, it is a way to plot three variables in two dimensions Capabilities of Tableau - - Transforming data into actionable insights.- Exploring with limitless visual analytics. - Building dashboards and performing ad hoc analyses in just a few clicks. - Sharing your work with anyone and making an impact on your business. Categorical (nominal data) - sorted into categories according to specified characteristics Categorical data naturally define - groups in a frequency distribution CHOOSE - returns a value from a list based on the position in the list, specified by index_num clustered column chart - compares values across categories using vertical rectangles coefficient of skewness - measures the degree of asymmetry of observations around the mean coefficient of variation (CV) - provides a relative measure of the dispersion in data relative to the mean and is defined as CV=Standard Deviation/Mean. Provides a relative measure of risk to return. The smaller the coefficient of variation, the smaller the relative risk is for the return provided. combination chart - displays multiple data series on the same chart using different chart types such as a column chart and a line chart Condition - is a statement about the value of a cell, either numeric or text construct a frequency distribution - you need only count the number of observations that appear in each category. This can be done using the Excel COUNTIF function.