Homework Help is Here – Start Your Trial Now!
Math
Statistics
Useful information Table 1 Tobacco smoking status of people aged 14 years or older 1991-2019 (percentage) Year 1991 Years since 1991 0 Daily Smokers % 24.3 Never Smoked % 49

Useful information Table 1 Tobacco smoking status of people aged 14 years or older 1991-2019 (percentage) Year 1991 Years since 1991 0 Daily Smokers % 24.3 Never Smoked % 49

Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
1st Edition
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:HOUGHTON MIFFLIN HARCOURT
Chapter9: Solving Quadratic Functions
Section: Chapter Questions
Problem 4CA
See similar textbooks
icon
Related questions
Question
Can someone please answer this and tell me how to create a scatter plot in MS excel
Useful information. Table 1 Tobacco smoking status of people aged 14 years or older 1991-2019 (percentage) ● For the conclusion ● Year 1991 1993 1995 1998 2001 2002 2004 2007 2010 2013 2016 2019 2023 ● ● Years since 1991 0 2 4 7 10 Hints to help answer this question Use Microsoft Excel to graph the data in Table 1 using two scatterplots. Display 'Daily Smokers' and 'Never Smoked' on separate graphs. Ensure you include the trend line, equation and coefficient of determination (R2) on each of the graphs (Hint: go back and revise Module 5). Now verify the excel produced linear equation by using the manual methods for finding the equation for a straight line. For this, select and use either the 'Daily Smokers' OR 'Never Smoked' data. Use the Excel generated equations to manually (e.g. write all steps of the calculations) predict what the 'Daily Smokers' and 'Never Smoked' data will be in 2023. 11 13 16 19 22 25 28 ?? Daily Smokers % 24.3 25 23.8 21.8 19.4 18.3 17.5 16.6 15.1 12.8 12.2 11.8 ?? Never Smoked % 49 49.1 52.6 49.2 50.6 51.7 52.9 55.4 57.8 60.1 62.3 63.1 ?? Discuss the trends in the data using your knowledge of linear equations. Comment on the accuracy of the equations and predictions. Discuss the assumptions/decisions you made when doing the calculations Discuss the relevance to real-world problem-solving. 8
Transcribed Image Text:Useful information. Table 1 Tobacco smoking status of people aged 14 years or older 1991-2019 (percentage) ● For the conclusion ● Year 1991 1993 1995 1998 2001 2002 2004 2007 2010 2013 2016 2019 2023 ● ● Years since 1991 0 2 4 7 10 Hints to help answer this question Use Microsoft Excel to graph the data in Table 1 using two scatterplots. Display 'Daily Smokers' and 'Never Smoked' on separate graphs. Ensure you include the trend line, equation and coefficient of determination (R2) on each of the graphs (Hint: go back and revise Module 5). Now verify the excel produced linear equation by using the manual methods for finding the equation for a straight line. For this, select and use either the 'Daily Smokers' OR 'Never Smoked' data. Use the Excel generated equations to manually (e.g. write all steps of the calculations) predict what the 'Daily Smokers' and 'Never Smoked' data will be in 2023. 11 13 16 19 22 25 28 ?? Daily Smokers % 24.3 25 23.8 21.8 19.4 18.3 17.5 16.6 15.1 12.8 12.2 11.8 ?? Never Smoked % 49 49.1 52.6 49.2 50.6 51.7 52.9 55.4 57.8 60.1 62.3 63.1 ?? Discuss the trends in the data using your knowledge of linear equations. Comment on the accuracy of the equations and predictions. Discuss the assumptions/decisions you made when doing the calculations Discuss the relevance to real-world problem-solving. 8
Expert Solution
steps

Step by step

Solved in 7 steps with 13 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
SEE MORE TEXTBOOKS