QBA Final Exam Study Guide Latest Update
2024-2025 155 Questions and 100% Verified
Correct Answers Actual Exam Guaranteed A+
"33.2%" is a - CORRECT ANSWER: sample statistic
Amazon wants to determine if how many of their Ohio customers are part of the
'Subscribe & Save' program. They take a sample of 15 customers from each zip code in
Ohio (for a total of 11,890 customers). They find that 28.56% of those customers have
received a 'Subscribe & Save' delivery in the past 3 months. - CORRECT ANSWER:
11,890 customers
Are pivot tables updatable? - CORRECT ANSWER: Yes, but not automatically; the
"refresh" button must be pushed to sync with updated data
Assume you have data for sales generated by all employees in a company. In which
scenario would you choose to use a regular SUM function rather than a SUMIFS
function? - CORRECT ANSWER: Find the total sales for all employees
Based on the empirical rule ________ percent of the observations will be contained
within 1 standard deviations around the arithmetic mean, ________ percent of the
observations will be contained within 2 standard deviations around the arithmetic mean,
and ________ percent of the observations will be contained within 3 standard
deviations around the arithmetic mean. - CORRECT ANSWER: about 68, about 95, and
about 99
Can you use a mixture of absolute and relative references in a single formula? -
CORRECT ANSWER: Yes
Employees whose sales exceeded $5000 receive a bonus of $250. Employees whose
sales are $3001 -$5000 get a bonus of $100. Employees whose sales are $1000-3000
get a bonus of $50. What is the correct syntax? - CORRECT ANSWER: IFS(F4>5000,
250, F4>3000, 100, F4>1000, 50)
,Given this syntax: IF(Logical_Test, Value_If_True, Value_If_False) what would be an
example of a "Logical_Test" - CORRECT ANSWER: C4 <= B5
How are COUNTIFS different from SUMIFS and AVERAGEIFS? - CORRECT
ANSWER: SUMIFS and AVERAGEIFS have one more required argument in the syntax
How do Mean and Median differ? - CORRECT ANSWER: The mean is influenced by
outliers but the median is not.
How do you know how to format a spreadsheet in the "real world"? - CORRECT
ANSWER: You'll need to create or conform to the specific standards for an individual
company or industry
How is the ROUND function different from using the decrease decimal button? -
CORRECT ANSWER: The round function actually removes extra digits; the decrease
button only hides extra decimal places from view
How many arguments (inputs) does this syntax REQUIRE? - CORRECT ANSWER:
One
If the correlation coefficient between 2 variables is -0.89, what is the strength of the
correlation? - CORRECT ANSWER: Very strong negative correlation
If the mean and median are similar, which should be used and why? - CORRECT
ANSWER: The mean because that is what you should report if you have a normal
distribution.
If you create a formula in this tab that refers to a cell in the 1 Formatting tab, how would
that tab name appear in the formula? - CORRECT ANSWER: ''1 Formatting!'
If you have qualitative data, which of the following is appropriate to report? - CORRECT
ANSWER: Mode
, If you think that your dataset will change or be updated, what is the best way to
compute descriptive statistics? - CORRECT ANSWER: Use functions (e.g.,
=AVERAGE, =MEDIAN)
If you want to show the total sales for each employee in a pivot table, what categories
would you use for the rows and values, respectively? - CORRECT ANSWER: Employee
for row; Sales for values
If you wanted to lock your reference to cell D2 in a formula and copy that formula across
a row, what should it look like? - CORRECT ANSWER: $D2
If you wanted to lock your reference to cell D7 in a formula and copy that formula down
a column, what should it look like? - CORRECT ANSWER: D$7
In a copyable Index Match Match command, all values are locked except: - CORRECT
ANSWER: The row of the first lookup value and the column of the second lookup value
In a standard normal distribution, what is 1 equal to? - CORRECT ANSWER: The
standard deviation
In function syntax, what do square brackets mean?
Ex: = SUM(number1, [number2],...)
Ex: = MATCH(lookup_value, lookup_array, [match_type]) what do the square brackets
mean? - CORRECT ANSWER: That portion of the function is optional
In the Index function syntax. = Index (array, row_number, col_number) what does
"array" mean? - CORRECT ANSWER: All of the data cells in the table
In the Regression Equation, what is the Y-intercept? - CORRECT ANSWER: The value
of Y when X is 0
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Tutordiligent. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $20.49. You're not tied to anything after your purchase.
