MATH 1324 Fall 2015

We are only limited by our imagination, our motivation, and our understanding of mathematics.

If you have any questions send me an email. merwin@tarleton.edu

If you run the computer during class for me, send me an email and remind me so that I give you credit in the gradebook.

When you create an Excel file for this course use the following naming convention:

assignment_course number_section_number_last name

Example:

hw1_1324_050_smith.xlsx

Please do not put blank spaces in file names. Use underscores "_".

At the beginning of each excel spreadsheet page type the following in the top left:

assignment, course number, section number, last name

All of the Classroom Problem Sets are Due for HW.

I want the assignments emailed to me as a nicely organized Excel spreadsheet.

We are going to use Excel for this course.

We are not going to turn in paper assignments.

Math 1324 Course Syllabus

https://drive.google.com/file/d/0B3fIEnc46BYhZXFWSkVHc0h4N0U/view?usp=sharing

Vocabulary Document

https://drive.google.com/file/d/0B3fIEnc46BYhS1ctY2VxNF9aTXc/view?usp=sharing

HW 1:

Work through pages 2 - 13 of the Excel Intro link below.

Email me an Excel file with the examples from pages 2 - 13 in the Excel Intro worked out.

Due by the following class day.

Excel Intro

https://drive.google.com/file/d/0B3fIEnc46BYhMXlVS0lJTG9WbVE/view?usp=sharing

Desmos Graphing Calculator (This makes great looking line graphs.)

https://www.desmos.com/

Classroom Problem Set 1 (Due by 8/31) (This is HW)

https://drive.google.com/file/d/0B3fIEnc46BYhMF84OEVodmRuMGc/view?usp=sharing

Classroom Problem Set 2 (This is HW)

https://drive.google.com/file/d/0B3fIEnc46BYhMXcxWVNiUFQxN1U/view?usp=sharing

Classroom Problem Set 3 (Price - Demand, Section 2.1) (This is HW)

https://drive.google.com/file/d/0B3fIEnc46BYhcjVsbTVRWWtVYTQ/view?usp=sharing

We will move onto linear transformations, review and then test.

After we test we will cover linear regression.

Vertex Form of a Line Intro

https://drive.google.com/file/d/0B3fIEnc46BYhWUxjN0tjd3dXOU0/view?usp=sharing

Vertex Form of a Line HW (This is due for HW)

https://docs.google.com/spreadsheets/d/1MkFRvIegY64kJABRT2aBCj5QswZIv40xliMGseS4-d8/edit?usp=sharing

Vertex Form of a Line (In Class Group Project)

https://drive.google.com/file/d/0B3fIEnc46BYhNkFwWVFtTzR4MTA/view?usp=sharing

After this we will review and test.

Exam 1 Review

https://drive.google.com/file/d/0B3fIEnc46BYhaWJMTE9oNlFMVmc/view?usp=sharing

Actual Exams

https://drive.google.com/file/d/0B3fIEnc46BYhaHF6ZXhjczk3VWM/view?usp=sharing

https://drive.google.com/file/d/0B3fIEnc46BYhOG5MdkdacGJlNGc/view?usp=sharing

Answer Key to First Exam

https://docs.google.com/spreadsheets/d/1NLNL0MvH2PckdlSk17X9cr0wisVFhWmroSwCTf-eTBc/edit?usp=sharing

Daniel Bernoulli

https://drive.google.com/file/d/0B3fIEnc46BYhYXp3SDA0S2hvR2s/view?usp=sharing

Price-Demand with Regression Models

https://drive.google.com/file/d/0B3fIEnc46BYhNEZ5U2xzSXJ3SzA/view?usp=sharing

Linear Regression Notes

https://drive.google.com/file/d/0B3fIEnc46BYhUFpKcmJpa0ZlLXM/view?usp=sharing

This is a great read on the coefficient of determination

http://blog.minitab.com/blog/adventures-in-statistics/regression-analysis-how-do-i-interpret-r-squared-and-assess-the-goodness-of-fit

Making sense of residual plots (Another Great Read)

http://docs.statwing.com/interpreting-residual-plots-to-improve-your-regression/

Data Files (HW Determine a regression model which fits the data well. Provide a table with x, y, y-hat, & the residuals. Provide a plot of the regression model and the data points. Provide a second plot of the y-hat values vs the residuals.)

https://drive.google.com/folderview?id=0B3fIEnc46BYhMlJzQ3JDeE9WT3c&usp=sharing

More Data Files (HW Choose 4 out of the following 6 data files. Determine either a linear or a quadratic regression model for the data set. Provide a table with x, y, y-hat, & the residuals. Provide 3 graphs: the regression model, the residual plot, & the predicted vs. the actual values. For data files with multiple columns, Pick two concepts for which you think there would be a relationship.)

https://drive.google.com/folderview?id=0B3fIEnc46BYhbmVEcl9ZeU10S0U&usp=sharing

Graphs we will use to analyze regression models

The Regression Model

https://docs.google.com/drawings/d/1SOH0fTOMB3V5k70T8CuLtxf1z-lcgVTg76lghVGqdbE/edit?usp=sharing

The Residual Plot

https://docs.google.com/drawings/d/12Az4PT7rbcEBjy9TXzdGmUT5TewSPM9uF8ZtNgCq35k/edit?usp=sharing

Predicted vs. Actual

https://docs.google.com/drawings/d/15CJ73X1SZDJu6aTpNVueDW1dxgvKDewRlbHVz--I8g0/edit?usp=sharing

Regression AP Questions

https://drive.google.com/file/d/0B3fIEnc46BYha0tiUmJyM0dUaGc/view?usp=sharing

For 9/25 Pick a data set and discuss extrapolation & interpolation.

Discuss CPI.

Beef vs. Chicken

Do you know what CPI and the Real Price are?

https://drive.google.com/folderview?id=0B3fIEnc46BYhLXdjNk5oQ05aWjA&usp=sharing

Regression Practice Exam

https://drive.google.com/file/d/0B3fIEnc46BYhYk82ZElfb3diQTQ/view?usp=sharing

New Topics:

Section 2.4 - 3.4 of Textbook

The geometry of Break-Even Analysis

Simple Interest

Compound Interest

Future & Present Value of an Annuity

Sinking Funds

We will test on these concepts Monday 10/26 & Tuesday 10/27.

Bureau of Labor Statistics CPI Base Reference

http://www.bls.gov/cpi/cpifact8.htm

CPI Table

http://www.usinflationcalculator.com/inflation/consumer-price-index-and-annual-percent-changes-from-1913-to-2008/

Excel file on panty hose data

https://drive.google.com/file/d/0B3fIEnc46BYhbl9TVzVhcllZVGs/view?usp=sharing

Break-Even Graph WKS for data files

https://drive.google.com/file/d/0B3fIEnc46BYhZXZlNmVnWThnSjA/view?usp=sharing

Excel file on door data (HW 10/5)

For HW just finish the spreadsheet and email it to me.

Use the Break-Even Graph WKS during class.

We generate a cost function and a price-demand function based on data.

Then we analyze the break-even graph.

https://drive.google.com/file/d/0B3fIEnc46BYhR3MwUFB2YU9KSHM/view?usp=sharing

Excel file on small engine data (HW 10/7)

For HW just finish the spreadsheet and email it to me.

We generate a cost function and a price-demand function based on data.

Then we analyze the break-even graph.

https://drive.google.com/file/d/0B3fIEnc46BYhZ0ZrOVc3MDNxVG8/view?usp=sharing

The Geometry of the Break-Even Graph WKS

https://drive.google.com/file/d/0B3fIEnc46BYhUEhnd1BTRzJ3aUU/view?usp=sharing

Simple Interest vs. Compound Interest (HW Due by 10/16) We need to discuss withdraws

Omit questions 3 & 5 from your spreadsheet.

https://drive.google.com/file/d/0B3fIEnc46BYhNzN5a0IwYzhkcWM/view?usp=sharing

Class example from 10/12

https://docs.google.com/spreadsheets/d/1xRJY-dn-5eSEGX-4tOfrFfUNtZ9fSAqmT6D-hpQNra0/edit?usp=sharing

Logarithms (HW) We should start on this in class on 10/14

https://drive.google.com/file/d/0B3fIEnc46BYhamxTVVJhSUFnNnc/view?usp=sharing

class example

https://docs.google.com/spreadsheets/d/1NVBcEbONNlgfGSoChgByhSejBFAMhWIsLYj_3P5Cmtk/edit?usp=sharing

We will cut off midterm grades here. Have all of the above HW into me by Monday the 19th.

Excel Financial Functions

http://www.excelfunctions.net/Excel-Financial-Functions.html

Annuity 1

https://drive.google.com/file/d/0B3fIEnc46BYhT1RxaWJaYVJKQVU/view?usp=sharing

Future Value Excel vs. Textbook

(This is the Excel file you download for Annuity 1)

https://drive.google.com/file/d/0B3fIEnc46BYhbVViXzNkczZYc2M/view?usp=sharing

Long Term Inflation Webpage

http://inflationdata.com/Inflation/Inflation_Rate/Long_Term_Inflation.asp

Annuity 2 with Inflation (HW)

https://drive.google.com/file/d/0B3fIEnc46BYhWE1HOUI2WUpudTA/view?usp=sharing

Example from class

https://docs.google.com/spreadsheets/d/1fh4A2Vb71iPkRc4uOKoaVOczfDeQjz8GOVYZsVw9x60/edit?usp=sharing

From here, we discuss present value of an annuity, review, and then test.

Inflation class work

https://drive.google.com/file/d/0B3fIEnc46BYhYUdJMF9qY3JQNzQ/view?usp=sharing

Mortgage

https://drive.google.com/file/d/0B3fIEnc46BYhOEV3OXV5dldhVms/view?usp=sharing

Mortgage Excel File

https://drive.google.com/file/d/0B3fIEnc46BYheTBYZlN2bGZUWnc/view?usp=sharing

Present Value of an Annuity (HW)

https://drive.google.com/file/d/0B3fIEnc46BYhS1BIZlEzN29TMU0/view?usp=sharing

Example from class 10/26

https://docs.google.com/spreadsheets/d/1D7cEgTz6oFgghrjy4t44JF1OfNPrbJNxI6vDvCjVmtw/edit?usp=sharing

Review for FV, PV, and the Break-Even Graph (HW)

https://drive.google.com/file/d/0B3fIEnc46BYhdERDQkFvdXFNWU0/view?usp=sharing

Class work from 10/29

https://docs.google.com/spreadsheets/d/1mRgK9MToYSKbtm0l-nPYBFJVc0xdfEVCqsrMJJnzlFI/edit?usp=sharing

Credit Card Questions (HW)

https://drive.google.com/file/d/0B3fIEnc46BYhb201ekl3YjlpQlk/view?usp=sharing

Credit Card Excel File

https://drive.google.com/file/d/0B3fIEnc46BYhTVpjd1pIM3ZDaVk/view?usp=sharing

The Break-Even Graph in Excel

https://drive.google.com/file/d/0B3fIEnc46BYhZ0J5V1c5UXQtd0U/view?usp=sharing

We test the week of 11/2 to 11/6

Now we start Probability and Statistics

Course Timeline Update

https://drive.google.com/file/d/0B3fIEnc46BYhS040RWYweXVYNms/view?usp=sharing

Probability & Statistics Vocabulary

https://drive.google.com/file/d/0B3fIEnc46BYhbGdWaFFpVm9OYW8/view?usp=sharing

Qualitative Data PDF

https://drive.google.com/file/d/0B3fIEnc46BYhZEo1Mmp0UTROU1U/view?usp=sharing

Qualitative Data File Men vs. Women

https://drive.google.com/file/d/0B3fIEnc46BYhcUNJb0pVZXhQQkU/view?usp=sharing

Instructions for Qualitative Data HW

https://drive.google.com/file/d/0B3fIEnc46BYhWER5M2dxNWhmdDg/view?usp=sharing

Qualitative Data HW Excel file

https://drive.google.com/file/d/0B3fIEnc46BYhTVpiRDJLVmlyN2c/view?usp=sharing

Instructions for Multiple Linear Regression Excel Files

https://drive.google.com/file/d/0B3fIEnc46BYhTWFhVDlQZ0N3SUE/view?usp=sharing

Multiple Linear Regression Excel Files HW

https://drive.google.com/folderview?id=0B3fIEnc46BYhN055SzBiai05Mjg&usp=sharing

Characteristics of Data Notes

https://drive.google.com/file/d/0B3fIEnc46BYhZm5DOWc0NGRuREk/view?usp=sharing

Histograms

https://drive.google.com/file/d/0B3fIEnc46BYhQzBUWkVvX0VvRmM/view?usp=sharing

Excel files for Histograms HW

https://drive.google.com/folderview?id=0B3fIEnc46BYhUkd3dHFUc2tyLXM&usp=sharing

Descriptive Statistics

https://drive.google.com/file/d/0B3fIEnc46BYhUjhoSGFXdHBDWDQ/view?usp=sharing

Excel files for Descriptive Stats HW

https://drive.google.com/folderview?id=0B3fIEnc46BYhTy1TeXlnUjJGWms&usp=sharing

Normal Distribution Notes

https://drive.google.com/file/d/0B3fIEnc46BYhakVKZ2lldUV6NGM/view?usp=sharing

Normal Distribution Class Work & HW

https://drive.google.com/file/d/0B3fIEnc46BYhTWN3ODF4ZjdUZTA/view?usp=sharing

Normal Distribution Excel files

https://drive.google.com/folderview?id=0B3fIEnc46BYhYzVVZkJCeUkzcm8&usp=sharing

Now we will have to review for our last unit exam.

Statistics Practice Exam

https://drive.google.com/file/d/0B3fIEnc46BYhVDlCUG04SmdTQWs/view?usp=sharing

Excel files for Stats Practice Exam

https://drive.google.com/folderview?id=0B3fIEnc46BYhRTVsVjhKLWJSdm8&usp=sharing

Excel files for Statistics Exam

https://drive.google.com/folderview?id=0B3fIEnc46BYhMmRFaGR2d0VtTmM&usp=sharing

Practice Final Exam

https://drive.google.com/file/d/0B3fIEnc46BYhc2ItQU1NazNfYlk/view?usp=sharing

Excel files for Practice Final Exam

https://drive.google.com/folderview?id=0B3fIEnc46BYhTHpJR1dGUTRycDg&usp=sharing

Excel files for Final Exam

https://drive.google.com/folderview?id=0B3fIEnc46BYhRlozMFlfTmhvSUE&usp=sharing