Dates: TBD
SECTION ONE: Vocabulary - Students should know all of the following terms learned throughout the school year. The style of test will be similar to past midterm exams. This series of short vocabulary tests will be scattered among the various days of finals testing.
Excel vocabulary definitions will match those provided in the hand-outs.
Key Terms: Lesson One Lesson Two Lesson Three Lesson Four
Lesson Five Lesson Six Lesson Seven Lesson Eight
Andres' Quizlet For Excel Vocab!!!
Andres' Quizlet For Sampling Survey Vocab!!!
SECTION TWO: Financial Functions - Students should review all of the applications that appeared on spring midterm #2. Three practice exams have been distributed in class. Answers are provided below in Excel worksheets. One more practice exam will be distributed in class in May.
EXCEL ANSWERS TO THURSDAY'S PRACTICE
Note: Answer to Practice Test B #8 NPV = $1,281,392 (Use 9%, not 8%)
Here's more instructional materials for your review of financial functions. This practice was provided earlier in the semester.
Practice Problems ANSWERS For Tests #1 & #2 EXCEL File
Practice Test #1 ANSWERS PDF File
Practice Test #2 ANSWERS PDF File
SECTION THREE: Mathematical Modeling
Students should be prepared to use data from a web resource, and forecast future values for the dependent variable using linear, exponential, power, logarithmic and quadratic models. Be prepared to report: (1) the coefficient of determination (R-squared), (2) the model equation in context, (3) the value of the independent variable ("X") that corresponds to a future date, and (4) evaluate the equation to determine the forecasted value as of the date provided. This section of the final will be identical in format to the spring midterms. Data may be provided annually or quarterly. Practice data are provided in the Excel file posted below. Answers will be provided in class.
SECTION FOUR: Univariate Describe Distributions - Students should be prepared to describe a distribution of data. The format of this exam will be identical to the fall semester exams.
NEW Data Analysis Practice Test 1 & 2
Answers Practice Tests 1 & 2 Excel File
Practice Test #1 PDF File Practice Test #2 PDF File
SECTION FIVE: Bivariate Analysis (Dropped due to time constraints) - Students should review the following practice questions and answers. The format of the exam will be identical to that of the fall final.
Bivariate Data Analysis Practice Questions & Answers EXCEL Spreadsheet
Bivariate Data Analysis Practice Questions & Answers PDF Version
SECTION SIX: Probability - Students should be prepared to know the basic probability rules, be able to calculate probabilities from a normal population distribution or a normal sampling distribution, and calculate expected value for a simple set of discrete probabilities. The format of this section of the exam will match the fall final.
Basic Rules, Normal Curves & Expected Value Practice Test #2
Answers Probability Test #2 EXCEL Answers Probability Test #2 PDF
ANSWERS TO WEDNESDAY'S PRACTICE TEST
Basic Rules, Normal Curves & Expected Value Practice Test #1
Answers Probability Test #1 EXCEL Answers Probability Test #1 PDF
Here's some practice conditional and marginal probability problems using table data.
Conditional and Marginal Probabilities (Categorical Bivariate Data)
Answers for Conditional & Marginal Probabilities (EXCEL File)
Answers for Conditional & Marginal Probabilities (PDF File)
SECTION SEVEN: Inference Procedures - Students should prepare for questions involving confidence intervals (mean and proportion) on the day of the final. Students will complete the final for one-sample tests of significance (means and proportions); and two-sample test of significance (mean only) as separate stand-alone tests on days to be determined in May. Advanced students will earn extra final points for performing a Chi Square goodness-of-fit test. Here's materials to review of all of these materials.
Instructional Inference Materials: Here's the two tests of significance that we went over in class. The first link is a word file with the questions. The second link is the Excel file that we went over in class.
Introductory Questions, One Mean Test & One Proportion Test
Test of Significance Mean & Proportion One Sample EXCEL File
As requested, I've created PDFs from the Excel Instructional file. They have been orgaized by mean and proportion.
MEAN FOUR-STEP TEST OF SIGNIFICANCE
Before Starting Details Step One Details Step Two Details
PROPORTION FOUR-STEP TEST OF SIGNIFICANCE
Before Starting Details Step One Details Step Two Details
Four-Step Iinference Procedure Forms - Here are the forms that will be provided on the final.
Confidence Interval, One Sample Mean
Confidence Interval, One Sample Proportion
Test of Significance, One Sample Mean
Test of Significance, One Sample Proportion
Test of Significance, Two Sample, Difference of Means
Chi Square Goodness of Fit Form