Document Preview:
Math 1101 Semester Project Instructor: Dr. Francis Adams Student Name:_____________________ Student Panther ID: _________________ Semester Project Part one (regression line) 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 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) Type your data into two columns side-by-side. Note The first column is always going to be on your X-axis by default ii) Highlight the data and then “Insert “a Scatter Plot. iii) “Layout” to add title to your chart and turn off the legend and gridlines iv) 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. [...]
Order Description:
Attached is the assignment. This is an Excel Project and directions must be followed exactly and all components included as it is a big part of my final grade. Project sheets must be completed and Excel printouts included as instructed in project directions.
Subject Area: Mathematics
Document Type: Dissertation Proposal