# 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

Vocabulary Document

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

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

https://www.desmos.com/

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

Classroom Problem Set 2 (This is HW)

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

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

After we test we will cover linear regression.

Vertex Form of a Line Intro

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

Vertex Form of a Line (In Class Group Project)

After this we will review and test.

Exam 1 Review

Actual Exams

Daniel Bernoulli

Price-Demand with Regression Models

Linear Regression Notes

This is a great read on the coefficient of determination

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.)

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.)

Graphs we will use to analyze regression models

The Regression Model

The Residual Plot

Predicted vs. Actual

Regression AP Questions

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?

Regression Practice Exam

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

Break-Even Graph WKS for data files

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.

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.

The Geometry of the Break-Even Graph WKS

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

Class example from 10/12

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

class example

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

Future Value Excel vs. Textbook

Long Term Inflation Webpage

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

Annuity 2 with Inflation (HW)

Example from class

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

Inflation class work

Mortgage

Mortgage Excel File

Present Value of an Annuity (HW)

Example from class 10/26

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

Class work from 10/29

Credit Card Questions (HW)

Credit Card Excel File

The Break-Even Graph in Excel

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

Now we start Probability and Statistics

Course Timeline Update

Probability & Statistics Vocabulary

Qualitative Data PDF

Qualitative Data File Men vs. Women

Instructions for Qualitative Data HW

Qualitative Data HW Excel file

Instructions for Multiple Linear Regression Excel Files

Multiple Linear Regression Excel Files HW

Characteristics of Data Notes

Histograms

Excel files for Histograms HW

Descriptive Statistics

Excel files for Descriptive Stats HW

Normal Distribution Notes

Normal Distribution Class Work & HW

Normal Distribution Excel files

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

Statistics Practice Exam

Excel files for Stats Practice Exam

Excel files for Statistics Exam