Exam 12: Business Statistics and Regression Analysis
Exam 2: Formatting, functions, and Formulas100 Questions
Exam 3: Cell References, named Ranges, and Functions102 Questions
Exam 4: Effective Charts98 Questions
Exam 5: Complex Conditional and Retrieval Functions100 Questions
Exam 6: Analyze Data Using Tables100 Questions
Exam 7: Multiple Worksheets workbooks and Templates100 Questions
Exam 8: Refine an Excel Application100 Questions
Exam 9: Organize, import, export, and Cleanse Data Sets100 Questions
Exam 10: Data Tables, scenario Manager, and Solver101 Questions
Exam 11: Loan Amortization, investment Analysis, and Asset Depreciation100 Questions
Exam 12: Business Statistics and Regression Analysis103 Questions
Exam 13: Excels Data Model, Power-pivot, and Power View96 Questions
Exam 14: Visual Basic for Applications99 Questions
Exam 15: Appendix:efficient Interaction With a Touch Screen67 Questions
Exam 16: The Common Features of Microsoft Office81 Questions
Select questions type
When creating a frequency table using the FREQUENCY function,you must select a range of cells that is one more than the cells containing the bin values.
(True/False)
4.9/5
(39)
Array functions are often referred to as "CDE" functions because of the keys pressed to create the function.
(True/False)
5.0/5
(27)
When working with large data sets,it can be useful to group the data into ________.
(Short Answer)
5.0/5
(34)
If a product is tested 100 times and the rate at which it fails is recorded on a scale of 1 to 10,then the average of all the product's failure rates on the scale could be useful.This is an example of ________ data.
(Multiple Choice)
4.8/5
(39)
________ data measures the size of the difference between values.
(Multiple Choice)
4.8/5
(37)
A(n)________ distribution takes on the shape of a bell and is often referred to as the "bell-shaped curve."
(Short Answer)
4.9/5
(29)
________ is the practice of collecting,analyzing,and interpreting data.
(Short Answer)
4.8/5
(41)
________ are only useful with discrete data that is sorted in either ascending or descending order.
(Short Answer)
4.8/5
(33)
Correlation coefficient values are easy to interpret,but it is often more powerful to create a ________ chart that illustrates that relationship visually.
(Multiple Choice)
4.8/5
(26)
The ________ distribution is a continuous probability function that models the times between events.
(Multiple Choice)
4.8/5
(38)
Each of these calculations,mean,median,and mode,attempt to define the ________ of a data set.
(Short Answer)
4.9/5
(29)
The Turquoise Oasis Spa places orders for cases of bath salts through a nearby wholesaler.To summarize several orders worth of data,it may prove beneficial to determine how many orders of bath salts were for 1 to 10 cases,between 11 and 20 cases,21 to 30 cases,31 to 40 cases,and more than 40 cases.This is an example of ________.
(Multiple Choice)
5.0/5
(36)
________ is a method used to predict future values by analyzing the relationships between two or more variables.
(Multiple Choice)
4.9/5
(38)
The ________ distribution is a discrete probability distribution that is used to model the number of successful trials based on the total number of trials and the rate of success.
(Short Answer)
4.8/5
(30)
All of the following statements are TRUE about finding relationships in data EXCEPT:
(Multiple Choice)
4.9/5
(41)
To calculate the ________,sum of all values in a data set and divide by the total number of values.
(Multiple Choice)
4.7/5
(33)
________ is the practice of collecting,analyzing,and interpreting data.
(Multiple Choice)
5.0/5
(37)
________ is the middle value(s)when all the values of the sample are sorted in ascending order.
(Multiple Choice)
4.7/5
(36)
Covariance is a formula that can calculate the relationship between two variables,like gender and dollars spent as well as the direction of the relationship.
(True/False)
4.8/5
(33)
The ________ provides a more conservative estimate of the independent variable's ability to predict the value of the dependent variable.
(Multiple Choice)
4.8/5
(38)
Showing 21 - 40 of 103
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)