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
UGBA 104 PRACTICE REVIEW QUESTIONS 2024. $10.99   Add to cart
Quickly navigate to
Preview
  2.  
  3. UGBA
  4.  
  5. UGBA

Exam (elaborations)

UGBA 104 PRACTICE REVIEW QUESTIONS 2024.
 7 views  0 purchase
  • Course
  • UGBA
  • Institution
  • UGBA

UGBA 104 PRACTICE REVIEW QUESTIONS 2024. Example of a Quantitative Variable - correct answer Age, Income Example of a Categorical Variable - correct answer Religion, Zip Code, Rent vs Own Example of a Binary Categorical Variable - correct answer Rent vs Own, Paid vs Not What is the diff...

[Show more]

Preview 2 out of 7  pages

Document information

  • April 23, 2024
  • 7
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers

Subjects

  • ugba 104
  • ugba 104 practice review questions 2024

Written for

  • UGBA
All documents for this subject (276)

Seller

avatar-seller
ROSEGRADES

Reviews received

Content preview

UGBA 104 Final Review

Example of a Quantitative Variable - correct answer Age, Income



Example of a Categorical Variable - correct answer Religion, Zip Code, Rent vs Own



Example of a Binary Categorical Variable - correct answer Rent vs Own, Paid vs Not



What is the difference between Sorting and Filtering? - correct answer Sort puts things in different
orders whereas Filtering only shows the results you filtered for



What are some of the uses of Conditional Formatting? - correct answer Highlights cells with rules:

-Greater than/less than

-Top X%, Bottom X%

-Data Bars, Color Scales



For a Categorical Variable, what is the difference between a Frequency Distribution, a Relative Frequency
Distribution, and a Percent Frequency Distribution? - correct answer Frequency Distribution = How often
it shows up

Relative Frequency Distribution = How often it shows up in total-- #times/total

Percent Frequency Distribution = % of total that it makes up



What is the difference between Excel's COUNT, SUM & AVERAGE functions? - correct answer COUNT:
number of times something shows up

SUM: totals the numbers

AVERAGE: takes the average of the numbers



WHat is the difference between Excel's COUNTIF, SUMIF, & AVERAGEIF functions? - correct answer
COUNTIF: conditional counting

, SUMIF: conditional summation

AVERAGEIF: conditional averaging



What is the role of Bins when summarizing a quantitative variable with either a frequency distribution or
histogram? - correct answer Bins organize data so that it can be summarized into a frequency
distribution or histogram



For a Quantitative Variable, compare the information provided by using Excel's FREQUENCY function to
the information provided by using Excel to generate a Histogram - correct answer The FREQUENCY
function gives the data necessary to create a Histogram



What are the reasons to identify an outlier?(3) - correct answer Incorrectly included in data set

Typo in data

Fraudulent data



For a Quantitative Variable, what is the Interquartile Range? - correct answer Q3-Q1



How do you identify an Outlier using the Interquartile Range? - correct answer Upper Limit: Q3+1.5*IQR

Lower Limit: Q1 - 1.5*IQR



How do you Standardize the values for a data set's quantitative variable? - correct answer (Value -
mean)/STD of ALL



How do you identify an Outlier using the Empirical Rule for the Normal Distribution? - correct answer
(+)3 or (-)3 from the z-score = outlier



13. In a Box-and-Whisker Chart

What is represented by the box?

What is represented by the solid line within the box?

What is represented by the "x"?

What is represented by the two whiskers, including the solid line at the end of each whisker?

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 ROSEGRADES. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $10.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67866 documents were sold in the last 30 days

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

Start selling
$10.99
  • (0)
  Add to cart