Using Excel to create a scatter Plot graph

I need help with a project for my MATH1101 class. I don't know what the 3rd question in part one is asking me to do. 

Math 1101 Semester Project Due: Wednesday, May 28, 2014
Instructor: Dr. Student Name:_____________________ Student Panther ID: _________________ Student Course No:_________ 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. 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 your project with the excel print out and with coversheet. How to Make a Scatter Plot and Regression Line (for users of Excel 2003 and before) :
i)
ii)
iii)
iv)
v)
vi)
vii)
viii)
ix)
x)
xi)
xii)
xiii)
xiv) 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,
a) Type in a title for your Bar Graph
b) 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:
1) Select Add Trend line
2) Under the Type tab select the appropriate type of graph your data fit
3) Under Options check Display equation on chart. How to make a Scatter Plot and Regression Line (for users of Excel 2007) :
i)
ii)
iii)
iv) 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:
1. Select Add Trend line 2. Under the Type tab select the appropriate type of graph your data fit 3. Under Options check Display equation on chart.

• 1492751008-Math1101_Project.doc

ComputerScienceExpert

(11)

Status NEW Posted 21 Apr 2017 04:04 AM My Price 9.00

-----------

Attachments

file 1492751005-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer