Math 1101 Semester Project

Due: Monday March 25th

On iCollege Drop box

Instructor: Dr. M. Alexander

Student Name: _____________________

Student Panther ID: (last 4 digits) _________________

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 spreadsheet, and attach an excel print out):

y = -0.5806x + 1182.8

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

is:

20.4

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

y = 15x

- 30x + 1017

y = -0.5806x + 1182.8

1960 1965 1970 1975 1980 1985 1990 1995 2000 2005

TOTAL POPULATION

YEAR

SCATTER PLOT

Part three (best-fit quadratic function)

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

Year

US Population (in millions)

1960

180.671

1965

194.303

1970

205.052

1975

215.973

1980

227.726

1985

238.466

1990

249.948

1995

263.044

1998

270.561

2000

281.422

2003

294.043

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.

y = 15x

- 30x + 1017

980

1000

1020

1040

1060

1080

1100

1120

1140

1160

-3 -2 -1 0 1 2 3 4

Chart Title

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

y = 0.0146x

+ 1.8413x + 183.46

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

population?

Yes, the estimate is very close to the actual population

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

= (0.0146 × 40

+ (1.8413 × 40) + 183.46

= 280.472 million

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

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

= (0.0146 × 45

+ (1.8413 × 45) + 183.46

= 295.8835 million

y = 0.0146x

+ 1.8413x + 183.46

100

150

200

250

300

350

0 10 20 30 40 50

US Population

Year

Scatter Plot

Place new order. It's free, fast and safe

Paper type

Deadline

Page count

550 words

Total price: $ 15.00

Our customers say

Jeff Curtis

USA, Student

"I'm fully satisfied with the essay I've just received. When I read it, I felt like it was exactly what I wanted to say, but couldn’t find the necessary words. Thank you!"

Ian McGregor

UK, Student

"I don’t know what I would do without your assistance! With your help, I met my deadline just in time and the work was very professional. I will be back in several days with another assignment!"

Shannon Williams

Canada, Student

"It was the perfect experience! I enjoyed working with my writer, he delivered my work on time and followed all the guidelines about the referencing and contents."