\ufeffMath 1101 Semester Project<\/p>\n
Due: On 7\/29\/19 at 11:00 pm SHARP!<\/p>\n
On iCollege Drop box <\/p>\n
Instructor: Dr. M. Alexander<\/p>\n
Student Name:_____________________<\/p>\n
Student Panther ID: (last 4 digits) _________________<\/p>\n
Turn in your project in the iCollege Drop Box with:<\/p>\n
This cover sheet<\/p>\n
The following pages with your answers on them<\/p>\n
The excel print out that shows your work and supports your answers.<\/p>\n
Semester Project <\/p>\n
Part one (regression line or best-fit linear function)<\/p>\n
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.<\/p>\n
Percentage of Smokers <\/p>\n
_________________________________________________________________________________________________<\/p>\n
Year Total Population All Males All Females<\/p>\n
_________________________________________________________________________________________________<\/p>\n
1965 42.4 51.9 33.9<\/p>\n
1974 37.1 43.1 32.1<\/p>\n
1979 33.5 37.5 29.9<\/p>\n
1983 32.1 35.1 29.5<\/p>\n
1985 30.1 32.6 27.9<\/p>\n
1987 28.8 31.2 26.5<\/p>\n
1990 25.5 28.4 22.8<\/p>\n
1992 26.5 28.6 24.6<\/p>\n
1993 25.0 27.7 22.5 <\/p>\n
1995 24.7 27.0 22.6<\/p>\n
2000 23.3 25.7 21.0<\/p>\n
1)Using Excel, draw a Scatter Plot and generate a regression line for the percentages of total population who are smokers versus time.<\/p>\n
2) The Regression Line for the Percentage of total population who are smokers is (just copy the equation from your Excel spread <\/p>\n
sheet , and attach an excel print out) :<\/p>\n
______________________________________________<\/p>\n
3) According to the model , the percentage of total population who are smokers in the year 2002 is:<\/p>\n
__________________________________________________<\/p>\n
Part two (quadratic function passing three points) <\/p>\n
Use excel to find the quadratic function whose graph is a parabola containing the points (-2,1137), (2,1017), (3,1062).<\/p>\n
The quadratic function is (attach an excel print out) :<\/p>\n
__________________________________________________<\/p>\n
Part three (best-fit quadratic function) <\/p>\n
The table below gives the US population, in millions, for selected years. <\/p>\n
EMBED Excel.Sheet.12 <\/p>\n
1) Create a scatter plot of the data points, with x equal to the number of years after 1960.<\/p>\n
2) Create a best-fit quadratic function that models the data, using the number of years after 1960 as the input x.<\/p>\n
The best-fit quadratic function is (attach an excel print out):<\/p>\n
__________________________________________<\/p>\n
3) Use the model to estimate the population of US in 2000. Is the estimate close to the actual population?<\/p>\n
According to the model, the estimate of US population in 2000 is:<\/p>\n
_______________________<\/p>\n
4) Use the model to predict the US population in 2005.<\/p>\n
According to the model , the US population in 2005 is: _______________________________<\/p>\n
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).<\/p>\n
You do not need to turn in this page<\/p>\n
How to Make a Scatter Plot and Regression Line (for users of Excel 2003 and before) :<\/p>\n
Type your data into two columns side-by-side. Note The first column is always going to be on your X-axis by default<\/p>\n
Highlight the data and select Chart Wizard from Insert Menu or the icon<\/p>\n
Select XY (Scatter) from Chart Type. <\/p>\n
Select the FIRST Diagram from the First Column (Scatter. Compares pairs of values) in the Chart sub-type<\/p>\n
Click on Press and Hold to view sample of what you have made<\/p>\n
Click on next to continue<\/p>\n
Under Data Range; check Columns for Series in and click next<\/p>\n
Under Titles, <\/p>\n
Type in a title for your Bar Graph<\/p>\n
Label both axes<\/p>\n
Do not change anything under the Axes tab<\/p>\n
Select the Gridlines tab and uncheck every box<\/p>\n
Select the Legend tab and uncheck show legend <\/p>\n
Select the Data Labels tab and ensure that no box has been checked and then click on next<\/p>\n
For Place Chart; Select As object in to show both Data and Diagram<\/p>\n
To include a Regression Line;<\/p>\n
Right click on any of the plotted data:<\/p>\n
Select Add Trend line<\/p>\n
Under the Type tab select the appropriate type of graph your data fit<\/p>\n
Under Options check Display equation on chart.<\/p>\n
How to make a Scatter Plot and Regression Line (for users of Excel 2007) :<\/p>\n
Type your data into two columns side-by-side. Note The first column is always going to be on your X-axis by default<\/p>\n
Highlight the data and then \u201cInsert \u201ca Scatter Plot.<\/p>\n
\u201cLayout\u201d to add title to your chart and turn off the legend and gridlines<\/p>\n
To include a Regression Line,<\/p>\n
Right click on any of the plotted data point:<\/p>\n
Select Add Trend line<\/p>\n
Under the Type tab select the appropriate type of graph your data fit<\/p>\n
Under Options check Display equation on chart.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ufeffMath 1101 Semester Project Due: On 7\/29\/19 at 11:00 pm SHARP! On iCollege Drop box Instructor: Dr. M. Alexander Student<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-52780","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\n