Math 1101 Semester Project

Due: On 7/29/19 at 11:00 pm SHARP!

On iCollege Drop box

Instructor: Dr. M. Alexander

Student Name:_____________________

Student Panther ID: (last 4 digits) _________________

Turn in your project in the iCollege Drop Box with:

This cover sheet

The following pages with your answers on them

The excel print out that shows your work and supports your answers.

Semester Project

Part one (regression line or best-fit linear function)

The following table shows (for the years 1965 to 2000 and for people 18 and over) the total percentage of cigarette smokers, the percentage of males who are smokers, and the percentage of females who are smokers.

Percentage of Smokers

_________________________________________________________________________________________________

Year Total Population All Males All Females

_________________________________________________________________________________________________

1965 42.4 51.9 33.9

1974 37.1 43.1 32.1

1979 33.5 37.5 29.9

1983 32.1 35.1 29.5

1985 30.1 32.6 27.9

1987 28.8 31.2 26.5

1990 25.5 28.4 22.8

1992 26.5 28.6 24.6

1993 25.0 27.7 22.5

1995 24.7 27.0 22.6

2000 23.3 25.7 21.0

1)Using Excel, draw a Scatter Plot and generate a regression line for the percentages of total population who are smokers versus time.

2) The Regression Line for the Percentage of total population who are smokers is (just copy the equation from your Excel spread

sheet , and attach an excel print out) :

______________________________________________

3) According to the model , the percentage of total population who are smokers in the year 2002 is:

__________________________________________________

Part two (quadratic function passing three points)

Use excel to find the quadratic function whose graph is a parabola containing the points (-2,1137), (2,1017), (3,1062).

The quadratic function is (attach an excel print out) :

__________________________________________________

Part three (best-fit quadratic function)

The table below gives the US population, in millions, for selected years.

EMBED Excel.Sheet.12

1) Create a scatter plot of the data points, with x equal to the number of years after 1960.

2) Create a best-fit quadratic function that models the data, using the number of years after 1960 as the input x.

The best-fit quadratic function is (attach an excel print out):

__________________________________________

3) Use the model to estimate the population of US in 2000. Is the estimate close to the actual population?

According to the model, the estimate of US population in 2000 is:

_______________________

4) Use the model to predict the US population in 2005.

According to the model , the US population in 2005 is: _______________________________

Turn in: The coversheet and these three sheets with your answers on them as well as the excel print showing your work (tables/graphs/equations/etc).

You do not need to turn in this page

How to Make a Scatter Plot and Regression Line (for users of Excel 2003 and before) :

Type your data into two columns side-by-side. Note The first column is always going to be on your X-axis by default

Highlight the data and select Chart Wizard from Insert Menu or the icon

Select XY (Scatter) from Chart Type.

Select the FIRST Diagram from the First Column (Scatter. Compares pairs of values) in the Chart sub-type

Click on Press and Hold to view sample of what you have made

Click on next to continue

Under Data Range; check Columns for Series in and click next

Under Titles,

Type in a title for your Bar Graph

Label both axes

Do not change anything under the Axes tab

Select the Gridlines tab and uncheck every box

Select the Legend tab and uncheck show legend

Select the Data Labels tab and ensure that no box has been checked and then click on next

For Place Chart; Select As object in to show both Data and Diagram

To include a Regression Line;

Right click on any of the plotted data:

Select Add Trend line

Under the Type tab select the appropriate type of graph your data fit

Under Options check Display equation on chart.

How to make a Scatter Plot and Regression Line (for users of Excel 2007) :

Type your data into two columns side-by-side. Note The first column is always going to be on your X-axis by default

Highlight the data and then “Insert “a Scatter Plot.

“Layout” to add title to your chart and turn off the legend and gridlines

To include a Regression Line,

Right click on any of the plotted data point:

Select Add Trend line

Under the Type tab select the appropriate type of graph your data fit

Under Options check Display equation on chart.