BUAD 310 EXCEL Exam term flashcards

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/98

encourage image

There's no tags or description

Looks like no tags are added yet.

99 Terms

1
New cards

Which function finds the average?

AVERAGE.

2
New cards

Which function finds the middle value?

MEDIAN.

3
New cards

Which function measures sample spread in the original units?

STDEV.S.

4
New cards

What is the difference between range and IQR?

Range is maximum minus minimum; IQR is Q3 minus Q1 and measures the spread of the middle 50%.

5
New cards

What do quartile arguments 1, 2, and 3 represent?

Q1, the median, and Q3.

6
New cards

What does COUNT count?

Cells containing numbers. It ignores text and empty cells.

7
New cards

When should you use IF?

When a condition determines which of two results to return, such as Small versus Large.

8
New cards

When should you use COUNTIF?

To count observations meeting one condition.

9
New cards

When should you use COUNTIFS?

To count observations meeting multiple conditions.

10
New cards

Do COUNTIFS conditions work as AND or OR?

AND. Every condition must be satisfied.

11
New cards

When should you use AVERAGEIFS?

To average values only for observations meeting specified conditions.

12
New cards

Which range comes first in AVERAGEIFS?

The range containing the numbers to average.

13
New cards

When do comparison criteria need quotation marks?

When entered as criteria such as ">150" in COUNTIF or COUNTIFS.

14
New cards

What does the ampersand do in a criterion such as ">"&Q2?

It joins the comparison operator to the value stored in Q2.

15
New cards

What does $A$1 lock?

Both column A and row 1.

16
New cards

What does $A1 lock?

Column A only; the row can change when copied.

17
New cards

What does A$1 lock?

Row 1 only; the column can change when copied.

18
New cards

What does A1 do when copied?

Both its row and column references can change.

19
New cards

What are the inputs to FREQUENCY?

The numeric data and the bin upper limits.

20
New cards

What does the first FREQUENCY bin count?

Values less than or equal to the first bin limit.

21
New cards

What do later FREQUENCY bins count?

Values greater than the preceding limit and less than or equal to the current limit.

22
New cards

What does the extra FREQUENCY output count?

Values above the largest bin limit.

23
New cards

How is FREQUENCY entered in older Excel versions?

Select the output cells and confirm with Ctrl+Shift+Enter. Modern Excel can spill the results automatically.

24
New cards

Which tool quickly creates a two-way count table?

A PivotTable.

25
New cards

How do you arrange a PivotTable for a two-way count table?

Put one categorical variable in Rows, another in Columns, and a field in Values summarized by Count.

26
New cards

What should you check in a PivotTable's Values settings?

That it uses Count when you need frequencies.

27
New cards

How can you check a completed contingency table?

Its inner cell counts should add to the grand total.

28
New cards

What wording signals a joint probability?

"And" or "both."

29
New cards

What is the denominator of a joint probability from a table?

The grand total.

30
New cards

What is a marginal probability?

The probability of one category regardless of the other variable.

31
New cards

Where are marginal counts located in a contingency table?

In the row and column totals.

32
New cards

What wording signals a conditional probability?

"Given that," "among," or wording restricting the group selected.

33
New cards

What is the denominator of a conditional probability?

The total for the group given in the condition.

34
New cards

When should you use NORM.DIST?

When given a value or cutoff and asked for a normal probability.

35
New cards

When should you use NORM.INV?

When given a normal probability or percentile and asked for a cutoff.

36
New cards

What does TRUE request in NORM.DIST?

The cumulative probability to the left of the cutoff.

37
New cards

What does FALSE request in NORM.DIST?

The density curve's height, not an area probability.

38
New cards

How do you recognize a right-tail normal probability?

The question says more than, greater than, above, or exceeds.

39
New cards

How do you recognize a left-tail normal probability?

The question says less than, below, or at most.

40
New cards

How do you calculate a normal probability between two values?

Subtract the lower cutoff's cumulative probability from the upper cutoff's cumulative probability.

41
New cards

What probability goes into NORM.INV for a cutoff exceeded 5% of the time?

0.95, because 95% lies to the left.

42
New cards

How should percentages be entered in normal return calculations?

As decimals: 2% is 0.02 and 0.5% is 0.005.

43
New cards

What must you do before using a stock price cutoff in a distribution of returns?

Convert the price change into a decimal return.

44
New cards

Which standard deviation belongs in NORM.DIST for an individual's spending?

The standard deviation of individual spending, not the standard error of the sample mean.

45
New cards

When should you use CONFIDENCE.T for a mean?

When the population standard deviation is unknown and you estimate it with the sample standard deviation.

46
New cards

When should you use CONFIDENCE.NORM for a mean?

When the population standard deviation is known. The class also uses a large-sample approximation with sample SD.

47
New cards

What do CONFIDENCE.T and CONFIDENCE.NORM return?

Only the margin of error.

48
New cards

How do you turn a margin of error into a confidence interval?

Subtract it from and add it to the sample mean.

49
New cards

What alpha corresponds to 90%, 95%, and 99% confidence?

0.10, 0.05, and 0.01, respectively.

50
New cards

Do CONFIDENCE.T and CONFIDENCE.NORM take alpha or alpha/2?

Alpha. Excel handles the two tails.

51
New cards

Does CONFIDENCE.T take sample size or degrees of freedom?

Sample size n.

52
New cards

Which test examines association between two categorical variables?

A chi-square test of independence.

53
New cards

What is H0 for a chi-square independence test?

The two variables are independent.

54
New cards

What is H1 for a chi-square independence test?

The two variables are associated.

55
New cards

What are observed counts?

The actual frequencies in the contingency table.

56
New cards

What are expected counts?

The frequencies predicted if the variables were independent, using the observed row and column totals.

57
New cards

Can expected counts be decimals?

Yes. Do not round them to whole numbers before testing.

58
New cards

What does CHISQ.TEST return?

The p-value.

59
New cards

Should CHISQ.TEST ranges include marginal totals?

No. Use only the corresponding inner cells.

60
New cards

What do you conclude when p is less than alpha?

Reject H0.

61
New cards

What do you conclude when p is greater than alpha?

Fail to reject H0.

62
New cards

Does failing to reject independence prove the variables are independent?

No. It means there is insufficient evidence of an association.

63
New cards

Which test compares the means of two independent groups in the review?

A two-sample t test assuming equal variances.

64
New cards

Where is the review's two-sample t test in Excel?

Data → Data Analysis → t-Test: Two-Sample Assuming Equal Variances.

65
New cards

How should the data be arranged for the ToolPak two-sample t test?

Each group's observations should be in a separate column or range.

66
New cards

When should you check Labels in the ToolPak?

When the selected ranges include headers.

67
New cards

What is the hypothesized mean difference when testing whether means differ?

0.

68
New cards

What is H0 when testing whether two population means differ?

μ1−μ2=0.

69
New cards

What is H1 when testing whether two population means differ?

μ1−μ2≠0.

70
New cards

Does the word "different" indicate a one-tailed or two-tailed test?

Two-tailed.

71
New cards

Which ToolPak p-value should you use for a difference in either direction?

P(T<=t) two-tail.

72
New cards

Which ToolPak output measures the estimated common variance?

Pooled Variance.

73
New cards

Which ToolPak output is the calculated test statistic?

t Stat.

74
New cards

Which ToolPak output is the cutoff for a two-sided test?

t Critical two-tail.

75
New cards

How do you compare t Stat with a positive two-tail critical value?

Compare the absolute value of t Stat with t Critical two-tail.

76
New cards

What does a negative two-sample t statistic indicate when the null difference is zero?

The first sample mean is below the second sample mean; the sign alone does not establish significance.

77
New cards

What does a confidence interval for a mean difference containing 0 indicate?

The corresponding two-sided test fails to reject a zero difference at the same alpha.

78
New cards

Can CONFIDENCE.T directly calculate the pooled two-sample mean-difference margin of error?

No. Use the t critical value multiplied by the pooled standard error of the difference.

79
New cards

Which chart displays the relationship between two quantitative variables?

A scatterplot.

80
New cards

Which variable belongs on the X-axis?

The explanatory or predictor variable.

81
New cards

Which variable belongs on the Y-axis?

The response or outcome variable.

82
New cards

Which function calculates the strength and direction of a linear relationship?

CORREL.

83
New cards

What is the possible range of correlation?

−1 to +1.

84
New cards

What does the sign of correlation tell you?

The direction of the linear relationship.

85
New cards

What does the absolute size of correlation tell you?

The strength of the linear relationship.

86
New cards

Which is stronger: r=0.3 or r=−0.8?

r=−0.8, because its absolute value is larger.

87
New cards

Does a strong correlation prove causation?

No.

88
New cards

Does correlation near zero rule out every relationship?

No. It indicates little or no linear relationship.

89
New cards

Where do you run regression in Excel?

Data → Data Analysis → Regression.

90
New cards

What goes in Input Y Range?

The response variable you want to predict.

91
New cards

What goes in Input X Range?

The explanatory variable used to predict Y.

92
New cards

Where do you find the regression intercept?

The Coefficients column in the Intercept row.

93
New cards

Where do you find the regression slope?

The Coefficients column in the predictor's row, often labeled X Variable 1.

94
New cards

How do you interpret the slope?

The predicted change in Y for a one-unit increase in X.

95
New cards

How do you interpret the intercept?

The predicted Y when X=0; it may lack a useful practical meaning.

96
New cards

What should you calculate before finding a prediction interval?

The predicted Y at the specified X.

97
New cards

What approximate 95% prediction interval does the review use?

Predicted Y ± 2 times the model's Standard Error.

98
New cards

Which Standard Error belongs in the review's prediction interval?

The model's Standard Error under Regression Statistics, not a coefficient's standard error.

99
New cards

What is extrapolation?

Predicting outside the observed range of X, where the fitted relationship may not hold.