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
The ________ distribution is used most often to predict demand for a product or service.
Free
(Short Answer)
4.8/5
(35)
Correct Answer:
Poisson
________ typically describe what has already happened and probability describes what is likely to happen in the future.
Free
(Short Answer)
4.9/5
(33)
Correct Answer:
Statistics
If the cumulative argument of the NORM.DIST function is set to TRUE,the result will be the probability of a value being less than or equal to the value of the x argument,known as the ________ distribution function.
Free
(Short Answer)
4.9/5
(40)
Correct Answer:
cumulative
Match the following terms with their description.
Correct Answer:
Premises:
Responses:
(Matching)
4.8/5
(45)
The correlation coefficient is represented by the letter "c" in statistics and is a unitless value that describes the strength and direction of a relationship between two variables.
(True/False)
4.9/5
(30)
A range is the simplest method to calculate the dispersion of a data set and can provide a rough idea of how the data set is dispersed.
(True/False)
4.9/5
(32)
In a data set consisting of gender,salary,and name of employees,the employees are the observational unit and the variables are the gender,salary,and names.
(True/False)
4.7/5
(35)
The more ________ the sample,the more accurate the statistical analysis will be.
(Short Answer)
4.9/5
(27)
________ characterizes the peakedness or flatness of a distribution compared to the normal distribution.
(Multiple Choice)
4.8/5
(32)
Descriptive statistics is the process of taking data from a sample of the population and making predictions about the entire population.
(True/False)
4.8/5
(36)
________ data can be used to create charts that show whether the value is trending upward or downward.
(Short Answer)
4.7/5
(28)
Regression analysis is a method used to predict future values by analyzing the relationships between two or more variables.
(True/False)
5.0/5
(37)
Moving averages can be useful in spotting trends over a period of time by smoothing out any fluctuations that may occur during each consecutive interval.
(True/False)
4.8/5
(31)
Nominal data are useful in situations where it is difficult to obtain accurate measurements.
(True/False)
4.8/5
(24)
In administering a survey where respondents answer "Yes" or "No" to a specific question,ordinal variables could be used to categorize the responses,such as 1 = Yes and 2 = No.
(True/False)
5.0/5
(33)
The ________ is the value at which a regression line will cross the y-axis and is used in the slope intercept formula to predict values.
(Multiple Choice)
4.9/5
(35)
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.
(Multiple Choice)
4.8/5
(41)
Depending on the options that were selected upon the installation of Excel,you may have to manually install the ________ add-in.
(Short Answer)
4.8/5
(34)
Match the following terms with their description.
Correct Answer:
Premises:
Responses:
(Matching)
4.8/5
(40)
Showing 1 - 20 of 103
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)