Managers at the Turquoise Oasis Spa are interested in knowing whether there is a

Question

Managers at the Turquoise Oasis Spa are interested in knowing whether there is a relationship between the age of their clients and the amount of money they spend in the spa. Upon analyzing the data, they found a correlation coefficient of .672. Thus, the relationship between the two variables is _________.

strong

moderate

weak

very weak

Calculating the correlation coefficient using the_________ function is useful to determine the type and strength of a relationship between two variables.

CAUSATION

COVARIANCES

CORREL

COVARIANCEP

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 l to 10 cases, between 1 l and 20 cases, 2] to 30 cases, 31 to 40 cases, and more than 40 cases. This is an example of_________

grouping the data into bins

calculating variances

a probability distributions

sample populations

_________ is a calculation used in statistics to determine how far the data set varies from the mean.

Variance

Range

Standard deviation

Central tendency

Finding the central tendency may lead to incorrect assumptions about the data due to possible _________

variance

central tendency

standard deviation

outliers

_________ are only useful with discrete data that is sorted in either ascending or descending order.

Means

Medians

Modes

Central tendencies

The spa manager uses data such as time between sales transactions, the weight of a package for shipping, and the amount of money a customer spends in any given visit. These are examples of _________

probability distributions

discrete variables

continuous variables

populations

If a product is tested 100 times and the rate at which it fails is recorded on a scale of 1 to Io, then the average of all the product's failure rates on the scale could be useful. This is an example of _________ data.

nominal

ordinal

interval

ratio

_________ data measures the size of the difference between values.

Nominal

Ordinal

Interval

Ratio

_________ variables are often used to categorize responses in a survey.

Nominal

Ordinal

Interval

Ratio

If a manager learns that product I failed after I5 tests and product 2 failed after only 5, then _________ data could state that product I passed three times as many tests as product 2.

nominal

ordinal

interval

ratio

Solver can be used for _________

complex equation solving

conditional formatting

consolidating data

linear programming

All of the following statements are TRUE about auditing formulas EXCEPT:

Tracing formulas draws lines from a formula to cells that supply source data and to formulas that use the result of a formula.

Formula-auditing tools show you which cells are used in a formula and how they are used.

When you select to trace dependents, Excel finds and marks with arrows all the cells that supply values to the active cell.

Both tracing a formula and evaluating a formula are useful in understanding how a worksheet is structured, and they are particularly useful if a complex formula is not producing a correct result.

All of the following statements are TRUE regarding the Compare and Merge Workbooks command EXCEPT:

You can merge workbooks that are not shared.

You can only merge a shared workbook with copies of that workbook that were made from the same shared workbook.

The shared workbooks must have unique file names different from the original workbook.

All copies of the shared workbooks should be saved in the same folder as the shared workbook.

_________ allows a user to select an individual piece of data in a PivotTable and then create a copy of individual records that were used to get that summary data on another worksheet.

PivotChartData connection

Data linking

Drilling down

Content relating

By default, PivotTables show a _________ for both columns and rows.

grand total

count

average

subtotal

The ________ filter displays the values in the field that can be toggled on and off through the use of check boxes.

advanced

enhanced

standard

additional

Explanation / Answer

1) Strong is the asnwer of the first mcq as the ratio is above 0.5 we can take it as strong relationship

2) CORREL is the answer as it is the only way to calculate correlation coefficiant

3) grouping the data into bins -- as it can be easily seen how the question is formed

4) Variance -- is the answer as it is cacluated from mean

5) variance -- as is the only option that counts with the question

6) Modes -- are the discrete data stored in ascending or descending orders

7) continuous variables - we are measing three parameter with contineous change

8) ordinal data -- as we are measuring on the sacle of 1-10

9) interval -- can be stated as the diffrence of two valus's

10) Nominal variable are used for responses in survey

11) ratio can be calculated by the given data

12) solver can be used for linear programming

13)Both tracing a formula and evaluating a formula are useful in understanding how a worksheet is structured, and they are particularly useful if a complex formula is not producing a correct result.

14) All copies of the shared workbooks should be saved in the same folder as the shared workbook.

15) PivotChartData connection

16)count is displayed by default

17)advanced will display checkboxes

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.