EBK ELEMENTARY STATISTICS USING EXCEL
7th Edition
ISBN: 9780136937401
Author: Triola
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 2.3, Problem 9BSC
To determine
To construct: The time series graph for the provided data set. Also, check if there any trend exists.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Percentage Identifying as Political Independents by Generation, 2000-2014
50%
50%
39%
37%
40%
Millennial 1981–1998
32%
Gen X 1965-1980
30%
Boomer 1946–1964
20%
Silent 1928-1945
0.0
2000
+
2005
2010
2014
Use the line graph to answer the following questions.
A. Identify the percentage of baby boomers who identified as Independents in 2014.
B. Describe a trend in the data.
C. Explain how that trend might affect political campaigns in the future.
D. Explain how political parties should adapt based on the data shown in the line graph.
Time Series Graphing Exercise
Air Quality The following data show the number of days the air quality for Atlanta, Georgia, was below the accepted standards.
Draw a time series graph for the data shown below. The times series graph maybe completed using excel or hand generated.
If hand generated take a picture of the graph and attach the photo.
Interpret the results.
.
.
Exercise Data
Year
Days
2005
5
2006
14
2007
15
2008
4
The folloiwing table shows data for U.S. movie theater admissions (per week). Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns.
Year Admissions Year Admissions
1945 79.0 1985 20.30
1955 39.9 1995 23.3
1965 19.8 2005 26.5
1975 19.9 2015 25.4
Chapter 2 Solutions
EBK ELEMENTARY STATISTICS USING EXCEL
Ch. 2.1 - Prob. 1BSCCh. 2.1 - Prob. 2BSCCh. 2.1 - Prob. 3BSCCh. 2.1 - Prob. 4BSCCh. 2.1 - Prob. 5BSCCh. 2.1 - Prob. 6BSCCh. 2.1 - Prob. 7BSCCh. 2.1 - Prob. 8BSCCh. 2.1 - Prob. 9BSCCh. 2.1 - Prob. 10BSC
Ch. 2.1 - Prob. 11BSCCh. 2.1 - Prob. 12BSCCh. 2.1 - Prob. 13BSCCh. 2.1 - Prob. 14BSCCh. 2.1 - Prob. 15BSCCh. 2.1 - Prob. 16BSCCh. 2.1 - Prob. 17BSCCh. 2.1 - Prob. 18BSCCh. 2.1 - Prob. 19BSCCh. 2.1 - Prob. 20BSCCh. 2.1 - Prob. 21BSCCh. 2.1 - Prob. 22BSCCh. 2.1 - Prob. 23BSCCh. 2.1 - Prob. 24BSCCh. 2.1 - Prob. 25BSCCh. 2.1 - Prob. 26BSCCh. 2.1 - Prob. 27BSCCh. 2.1 - Prob. 28BSCCh. 2.1 - Prob. 29BSCCh. 2.1 - Prob. 30BSCCh. 2.1 - Prob. 31BSCCh. 2.1 - Prob. 32BSCCh. 2.1 - Prob. 33BSCCh. 2.1 - Prob. 34BSCCh. 2.2 - 1. Heights Heights of adult males are normally...Ch. 2.2 - Prob. 2BSCCh. 2.2 - Prob. 3BSCCh. 2.2 - Prob. 4BSCCh. 2.2 - Interpreting a Histogram. In Exercises 5–8, answer...Ch. 2.2 - Interpreting a Histogram. In Exercises 5–8, answer...Ch. 2.2 - Interpreting a Histogram. In Exercises 5–8, answer...Ch. 2.2 - Interpreting a Histogram. In Exercises 5–8, answer...Ch. 2.2 - Prob. 9BSCCh. 2.2 - Prob. 10BSCCh. 2.2 - Prob. 11BSCCh. 2.2 - Prob. 12BSCCh. 2.2 - Prob. 13BSCCh. 2.2 - Prob. 14BSCCh. 2.2 - Prob. 15BSCCh. 2.2 - Prob. 16BSCCh. 2.2 - Prob. 17BSCCh. 2.2 - Prob. 18BSCCh. 2.2 - Prob. 19BBCh. 2.3 - Prob. 1BSCCh. 2.3 - Prob. 2BSCCh. 2.3 - 3. Ethics There are data showing that smoking is...Ch. 2.3 - Prob. 4BSCCh. 2.3 - Pulse Rates Listed below are pulse rates (beats...Ch. 2.3 - Diastolic Blood Pressure Listed below are...Ch. 2.3 - Pulse Rates Refer to the data listed in Exercise...Ch. 2.3 - Diastolic Blood Pressure Refer to the data listed...Ch. 2.3 - Prob. 9BSCCh. 2.3 - Prob. 10BSCCh. 2.3 - Prob. 11BSCCh. 2.3 - Prob. 12BSCCh. 2.3 - Prob. 13BSCCh. 2.3 - Prob. 14BSCCh. 2.3 - Prob. 15BSCCh. 2.3 - Prob. 16BSCCh. 2.3 - Prob. 17BSCCh. 2.3 - Deceptive Graphs. In Exercises 17-20, identify how...Ch. 2.3 - Prob. 19BSCCh. 2.3 - Prob. 20BSCCh. 2.3 - Prob. 21BBCh. 2.3 - Prob. 22BBCh. 2.4 - 1. Linear Correlation In this section we use r to...Ch. 2.4 - Prob. 2BSCCh. 2.4 - Prob. 3BSCCh. 2.4 - Prob. 4BSCCh. 2.4 - Prob. 5BSCCh. 2.4 - Prob. 6BSCCh. 2.4 - Prob. 7BSCCh. 2.4 - Prob. 8BSCCh. 2.4 - Prob. 9BSCCh. 2.4 - Prob. 10BSCCh. 2.4 - Prob. 11BSCCh. 2.4 - Prob. 12BSCCh. 2.4 - Prob. 13BBCh. 2.4 - Prob. 14BBCh. 2.4 - Prob. 15BBCh. 2.4 - Prob. 16BBCh. 2 - Prob. 1CQQCh. 2 - Prob. 2CQQCh. 2 - Prob. 3CQQCh. 2 - Prob. 4CQQCh. 2 - Prob. 5CQQCh. 2 - Prob. 6CQQCh. 2 - Prob. 7CQQCh. 2 - Prob. 8CQQCh. 2 - Prob. 9CQQCh. 2 - Prob. 10CQQCh. 2 - Prob. 1RECh. 2 - Prob. 2RECh. 2 - Prob. 3RECh. 2 - Prob. 4RECh. 2 - Prob. 5RECh. 2 - Prob. 6RECh. 2 - Prob. 7RECh. 2 - Prob. 8RECh. 2 - Prob. 1CRECh. 2 - Prob. 2CRECh. 2 - Prob. 3CRECh. 2 - Prob. 4CRECh. 2 - Prob. 5CRECh. 2 - Prob. 1EPCh. 2 - Prob. 1FDDCh. 2 - Prob. 2FDDCh. 2 - Prob. 3FDDCh. 2 - Prob. 4FDD
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?arrow_forwardYear Bonus ($000) 2000 102.5 2001 73.1 2002 63.3 2003 95.6 2004 115.8 2005 144.1 2006 192.2 2007 185.9 2008 98.3 2009 136.9 2010 144.4 2011 114.1 2012 143.9 2013 164.7 2014 161.9 2015 135.1 2016 143.8arrow_forwardPart 2. Complete the following statements. A) The cumulative enrolment is the ________ of the enrolment of the intervals smaller than the interval in question or equal to the latter. The graph of cumulative enrolment is represented by a function in ___________. B) The average, median and mode are three measures of _________ ____________. C) The term ________ refers to any data that deviates disproportionately from others. D) When the residual values are zero, then the correlation is called _________arrow_forward
- Derby speeds 2011 How fast do horses run? KentuckyDerby winners top 30 miles per hour, as shown in thisgraph. The graph shows the percentage of Derby winnersthat have run slower than each given speed. Note that fewhave won running less than 33 miles per hour, but about86% of the winning horses have run slower than 37 milesper hour. (A cumulative frequency graph like this iscalled an “ogive.”)a) Estimate the median winning speed.b) Estimate the quartiles.c) Estimate the range and the IQR.d) Create a boxplot of these speeds.e) Write a few sentences about the speeds of theKentucky Derby winners.arrow_forwardthe table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.arrow_forwardUse the graph below to answer the question. Cost per Gallon What was a likely result of the trend shown in the graph? Construction of highways decreased. Demand for public transportation declined. U.S. consumers bought fewer fuel efficient cars. O U.S. consumers had less money to spend on goods. Annual Gas Prices 1978-1982 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 T 1978 1979 1980 1981 1982 Year Source: Department of Energyarrow_forward
- Education pays off, according to some data from a study. The median weekly earnings and the unemployment rates for eight different levels of education are shown in the table. Educational Attainment Doctoral degree (Dr) Professional degree (Prf) Master's degree (MS) Bachelor's degree (BS) Associate degree (AS) Some college, no degree (SC) High school diploma (HS) Less than a high school diploma (NHS) Unemployment Rate (%) 1.7 1.7 2.5 2.6 3.5 4.3 5.3 7.5 Median Usual Weekly Earnings ($) 1,665 1,747 1,382 1,155 820 757 690 505 Note: Data are for persons aged 25 and over. Earnings are for full-time wage and salary workers.arrow_forward不 The data in the table represent the stock price for a company at the end of each month in 2015. (a) Construct a time-series plot and comment on any trends. (b) What was the percent change in the stock price of the company from January 2015 to December 2015? Date 1/15 2/15 3/15 4/15 5/15 6/15 7/15 8/15 9/15 10/15 11/15 12/15 Closing Price D 28.78 28.98 31.45 35.08 31.50 31.88 30.66 31.55 32.14 36.17 36.63 37.28 (a) Which of the following is a time-series plot of the data? OB. Closing Price Closing Price 40- Andrea Jan Jun Dec Month 251 40- 30- 25TTT Jan Jun Month Dec Q Closing Price Closing Price 40- 251TT Jan Jun Month Dec Jan Jun Dec Month Comment on any trends. Choose the correct answer below. OA. The stock price generally remained the same throughout the year. Q OB. The stock price generally decreased throughout the year. C. There was no discernible trend in the stock price throughout the year. D. The stock price generally increased throughout the year. (b) The percent change in…arrow_forwardThe accompanying table gives the population (in hundred thousands) and number of people not covered by health insurance (in hundred thousands) for a certain country. Find the percentage of people not covered by health insurance for each of the given years and describe the trend. Year Uninsured Total Population 1990 35,513 251,867 2000 36,872 281,466 2015 29,470 313,513 ..... Find the percentage of people not covered by health insurance for each of the given years. Year % Uninsured 1990 % 2000 2015 % (Round to one decimal place as needed.) -....arrow_forward
- The following graph shows the annual number of car accidents in California. Which of the following statements about the annual number of car accidents is an accurate conclusion? Yearly Car Accidents 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 2000 2005 Year 1985 1990 1995 2010 2015 2020 e 2018 Glynlyon, Inc. O There is a greater decrease in the annual number of car accidents from 1994 to 1995 than from 1997 to 1998. O There is a smaller decrease in the annual number of car accidents from 1999 to 2000 than from 1997 to 1998. O There is a smaller increase in the annualnumber of car accidents from 1995 to 1996 than from 1998 to 1999. O There is a greater increase in the annual number of car accidents from 1993 to 1994 than from 1996 to 1997. Car Accidentsarrow_forwardA magazine published data on the best small firms in a certain year. These were firms which had been publicly traded for at least a year, have a stock price of at least $5 per share, and have reported annual revenue between $5 million and $1 billion. Thtable below shows the ages of the chief executive officers for the first 66 ranked firms. Age Frequency Relative Frequency Cumulative Relative Frequency 40-44 45-49 50-54 55-59 60-64 10 65-69 6 70-74 1 (a) What is the frequency for CEO ages between (but not including) 54 and 65? (Enter your answer as a whole number.) 22 (b) What percentage of CEOS are 65 years or older? (Round your answer to the nearest whole number.) (c) What is the relative frequency of ages under 50? (Round your answer to two decimal places.) 0.29 (d) What is the cumulative relative frequency for CEOS younger than 55? (Round your answer to two decimal places.) 0.59arrow_forwardUsing the index on housing starts in the United States per year from 2006 to 2017 given in the table below, forecast the index for 2018 using a three-year and a five year moving average. Year Actual Sales 2006 116 2007 122 2008 121 2009 121 2010 111 2011 97 2012 113 2013 125 2014 146 2015 142 2016 156 2017 162 2018arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY