Final Exam PreparationFORMAT OF THE FINAL EXAM

• In-Person
• Friday, August 2nd
• 6PM-8PM
• R202 (the schedule of classes gives a different room but we need a computer lab)
• Open notes/open computer
  • Bring your own laptop/ipad if you wish or else you can use the computers in the lab
• Two Parts:
  • Part 1:
    • Four fill in blank/short answer/multiple choice questions
    • Some of them are multiple parts
    • Worth 15 points
    • You will have 2 attempts
  • Part 2: Excel- Given set of data perform tasks

WHAT'S ON THE EXAM?PART 1 (4 multiple choice/fill in blank worth 15 points)

• Mean and Median:
  • What are they? When do you use what?
• Standard Deviation
  • What is it? When should it be used?
• 5-Number Summary
  • What does each number (min, Q1, Median, Q3, max) stand for
  • How do outliers effect them (if at all)
• Linear Regression Equation: y=B+Ax
  • What does each letter stand for/mean? (i.e. What is A called and what does it mean for the equation?)
  • Use it to make a prediction.
• Probability
  • Given a table be able to answer probability questions like in Week 4- DId I Get This? Quiz #3

PART 2: EXCEL

• Find the Mean using Excel
  • =AVERAGE(data range you want to find the mean for)
• Find the Standard Deviation using Excel
  • =STDEV(data range you want to find the mean for)
• Graphs (you end up creating 2 histograms)
  • Create a histogram and be able to write a few sentences on SHAPE, CENTER, SPREAD
    • How to create a histogram using excel
• Binomial Distribution (2 problems)
  • Be able to find probabilities like in the module using the 2 commands:
  • =BINOM.DIST(# of successes, n, p, False)
  • =BINOM.DIST(# of successes, n, p, True)
• Normal Distribution (2 problems)
  • Find probabilities when given a value like in the module
  • =NORM.DIST(x-value, Mean, Stdev, True)
• Hypothesis Test (1 problem)
  • Go through the 4-steps of hypothesis testing described in the module
  • Find the p-value in Excel