100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
QBA Final Exam Study Guide Latest Update Questions and 100% Verified Correct Answers Actual Exam Guaranteed A+ $20.49
Add to cart
Quickly navigate to
Preview
  2.  
  3. QBA
  4.  
  5. QBA

Exam (elaborations)

QBA Final Exam Study Guide Latest Update Questions and 100% Verified Correct Answers Actual Exam Guaranteed A+
 0 purchase
  • Course
  • QBA
  • Institution
  • QBA

QBA Final Exam Study Guide Latest Update Questions and 100% Verified Correct Answers Actual Exam Guaranteed A+

Preview 3 out of 18  pages

Document information

  • August 14, 2024
  • 18
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • qba final exam study guide latest update

Written for

  • QBA
  • QBA

Seller

avatar-seller
Tutordiligent

Reviews received

Content preview

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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$20.49
  • (0)
Add to cart
Added