FALL FINAL PREPARATION

Identification of present value (PV), future value (FV), payment (PMT), rate, and number of periods (Nper). Here's a great example of how to use color coding of the worksheets to help you match the prompts in the question with their correct interpretation.

Financial Function Annotation Guide

Financial Function Color Coded Prompt Identification Example

SECTION II: DESCRIBE A DISTRIBUTION (DAY OF FINAL)

Practice Test #A & #B

Practice Test #A & #B Solutions Excel

SECTION III: BIG DATA (Wednesday, December 2 )

Chapters One - Six - Notes limited to a single blank 4X6” notecard for each of the three tests. You may write terms or other prompts. You cannot write the words “true” or “false” (or any other reference thereto, such as “ T“ or “F”), nor can you wirte the single letters “A”, “B”, “C”, “D” (or other means of reference thereto). Basically, you have to record the facts and terms underlying the answers. You prioritize what goes onto the card.

IF YOU MISS THE REVIEW SESSION, YOU WILL BE AT A DISADVANTAGE FOR THIS SECION OF THE MIDTERM. In that case, you have two choices: 1) Take the test as scheduled (copying someone else’s notes would be acceptable), OR 2) Use the % of your cumulative midterm scores as your final score.

Monday, December 6 Last Section of Midterm - Chapters Five - Six Only (Open Note) Notes will be collected for a grade upon completion of this last midterm. If you are absent, you will take this last section of the midterm on the day of the final.

SECTION IV: EXCEL VOCABULARY (Monday, December 7)

Definitions will match those provided in the hand-outs. Review all key terms for all lessons. Here's the lists.

Key Terms: Lesson One Lesson Two Lesson Three Lesson Four

Lesson Five Lesson Six Lesson Seven Lesson Eight

CHASE's QUIZLET Lessons 1-3 & 5

HANNAH's QUIZLET Lessons 4-8

SECTION V BIVARIATE ANALYSIS: (Monday, December 7)

Optional Text Reading: Page 121-122 (Response Variable vs. Explanatory Variable); bottom Page 123 - 124 & Pages 126-128(Scatterplots); Pages 140-145 (Correlation); bottom Page 149 - 156 & bottom Page 157 - 165 (Least Square Regression Line or LSRL); Page 167 - 172 (Residuals & Influential Points). IGNORE ALL EXERCISES & CALCULATOR INSTRUCTIONS.

Two Practice Tests With Annotated Answers EXCEL format

Practice Test #1 Bivariate PDF Answers Practice Test #1 Bivariate PDF

MORE PRACTICE

MIDTERM BIVARIATE EXAMS

SECTION VI: PROBABILITY (DAY OF FINAL)

(Basic Rules, Conditional/Marginal, Normal Distributions, Expected Value)

Here's A Good Review Of Basic Probability Rules: Basic Rules of Probability

Here's some practice probability problems.

Conditional and Marginal Probabilities (Categorical Bivariate Discrete Data)

Answers for Conditional & Marginal Probabilities (EXCEL File)

Answers for Conditional & Marginal Probabilities (PDF File)

MORE CLASS PRACTICE

Basic Probability Rules, Normal Curves, & Expected Value (Midterm Practice)

Answers for Basic Probability, Normal & EV (Excel File)

Answers for Basic Probability, Normal & EV (PDF File)

Basic Probability, Normal Curves & Expected Value Practice Final

Basic Probability, Normal Curves & Expected Value Practice Final Answers Excel

Basic Probability, Normal Curves & Expected Value Practice Final Answers PDF

BUSINESS STATISTICS STUDENTS

IGNORE ALL BELOW LINE

DONUT REVIEW PRACTICE PROBLEM ANSWERS

The Excel Spreadsheet above provides solutions for the problems provided at the Saturday review session and in class on Monday. They should help you in your last hour preparations.

MR. NELSON'S BUSINESS STATISTICS

Site Navigation[Skip]