eBook roblem 6-21 (Algorithmic) The Centers for Disease Control and Prevention Office on Smoking and Health (OSH) is the lead federal agency responsible for comprehensive tobacco prevention and control. OSH was established in 1965 to reduce the death and disease caused by tobacco use and exposure to secondhand smoke. Om responsibilities of the OSH is to collect data on tobacco use. The following data show the percentage of U.S. adults who were users of tobacco for a recent 11-year period (http://www.cdc.gov/tobacco/data statistics/tables/trends/cig_smoking/index.htm). Year 1 2 3 5 6 7 B 9 10 11 Percentage of Adults Who Smoke 22.9 21.5 20.8 20.0 25 Percent of A 201 20.1 20.1 a. Choose the correct time series plot. (0) 10 18.9 19.4 20.3 20.3 19.4 18.8 (1) Percent of Adults Who S 15 10 Year (0 1 10 12 4

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
ic 2-Time Series Analysis and F
eBook
Problem 6-21 (Algorithmic)
The Centers for Disease Control and Prevention Office on Smoking and Health (OSH) is the lead federal agency responsible for comprehensive tobacco prevention and control. OSH was established in 1965 to reduce the death and disease caused by tobacco use and exposure to secondhand smoke. One of the many
responsibilities of the OSH is to collect data on tobacco use. The following data show the percentage of U.S. adults who were users of tobacco for a recent 11-year period (http://www.cdc.gov/tobacco/data_statistics/tables/trends/cig_smoking/index.htm).
Year
1
2
3
4
5
6
7
8
9
10
11
Percentage of Adults Who Smoke
22.9
25
Peremt of Adults Who St
20
15
21.5
20 8
20.8
a. Choose the correct time series plot.
(0)
10
20.1
20.1
18.0
18.9
19.4
19,4
20.3
20.3
20.3
19.4
18.8
4
Year (0)
$
10
12
(1)
Percent of Adults Who Smoke
25
20
15
10
Year (0)
S
10
12
4
Transcribed Image Text:ic 2-Time Series Analysis and F eBook Problem 6-21 (Algorithmic) The Centers for Disease Control and Prevention Office on Smoking and Health (OSH) is the lead federal agency responsible for comprehensive tobacco prevention and control. OSH was established in 1965 to reduce the death and disease caused by tobacco use and exposure to secondhand smoke. One of the many responsibilities of the OSH is to collect data on tobacco use. The following data show the percentage of U.S. adults who were users of tobacco for a recent 11-year period (http://www.cdc.gov/tobacco/data_statistics/tables/trends/cig_smoking/index.htm). Year 1 2 3 4 5 6 7 8 9 10 11 Percentage of Adults Who Smoke 22.9 25 Peremt of Adults Who St 20 15 21.5 20 8 20.8 a. Choose the correct time series plot. (0) 10 20.1 20.1 18.0 18.9 19.4 19,4 20.3 20.3 20.3 19.4 18.8 4 Year (0) $ 10 12 (1) Percent of Adults Who Smoke 25 20 15 10 Year (0) S 10 12 4
Time Series Analysis and F
(11)
10
12
Year (0)
(iv) 25
FF
20
15
10
5
10
12
0
0
25
20
15
10
2
y-intercept, bo-
Slope, bi-
2
What type of pattern exists in the data?
4
4
years
6
6
Year (0)
8
0
2
2
4
6
Year (1)
6
Year (0)
8
10
10
b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. Do not round your interim computations and round your final answers to three decimal places. For subtractive or negative numbers use a minus sign. (Example: -300)
12
12
MSE-
c. One of OSH's goals is to cut the percentage of U.S. adults who were users of tobacco to 12% or less within nine years of the last year of these data. Does your regression model from part (b) suggest that OSH is on target to meet this goal?
Use your model from part (b) to estimate the number of years that must pass after these data have been collected before OSH will achieve this goal. Round your answer to the nearest whole number
Transcribed Image Text:Time Series Analysis and F (11) 10 12 Year (0) (iv) 25 FF 20 15 10 5 10 12 0 0 25 20 15 10 2 y-intercept, bo- Slope, bi- 2 What type of pattern exists in the data? 4 4 years 6 6 Year (0) 8 0 2 2 4 6 Year (1) 6 Year (0) 8 10 10 b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. Do not round your interim computations and round your final answers to three decimal places. For subtractive or negative numbers use a minus sign. (Example: -300) 12 12 MSE- c. One of OSH's goals is to cut the percentage of U.S. adults who were users of tobacco to 12% or less within nine years of the last year of these data. Does your regression model from part (b) suggest that OSH is on target to meet this goal? Use your model from part (b) to estimate the number of years that must pass after these data have been collected before OSH will achieve this goal. Round your answer to the nearest whole number
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 7 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.