Loose Leaf for Statistical Techniques in Business and Economics
17th Edition
ISBN: 9781260152647
Author: Douglas A. Lind
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 18, Problem 3SR
a.
To determine
Determine the logarithmic trend equation for the sales data.
b.
To determine
Find the percentage of increase in sales annually from 2013-2017.
c.
To determine
Estimate the projected sales amount for the year 2018.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The revenue for Google for the years 2010–2014 is shown in the following table (Wallstreet Journal, August 2014). Deflate the revenue in dollars based on the CPI (1982–1984base period). Comment on the company’s revenue in deflated dollars.
Year Revenue ($ billions) CPI2010 29.3 218.12011 37.9 224.92012 50.2 229.62013 59.8 233.02014 66.7 236.7
Q1. The table provided gives data on indexes of output per hour (X) and real compensation per hour (Y) for the business and nonfarm business sectors of the U.S. economy for 1960–2005. The base year of the indexes is 1992 = 100 and the indexes are seasonally adjusted.
a. Plot Y against X for the two sectors separately.
b. What is the economic theory behind the relationship between the two variables? Does the scattergram support the theory?
c. Estimate the OLS regression of Y on X.
Note: on the table ( 1. Output refers to real gross domestic product in the sector. 2. Wages and salaries of employees plus employers’ contributions for social insurance and private benefit plans. 3. Hourly compensation divided by the consumer price index for all urban consumers for recent quarters.)
Thank you!
The file P02_26.xlsx lists sales (in millions of dollars) of Dell Computer during the period 1987–1997 (where year 1 corresponds to 1987).
Year
Sales
1
69
2
159
3
258
4
389
5
546
6
890
7
2014
8
2873
9
3475
10
5296
11
7759
a. Fit a power and an exponential trend curve to these data. Which fits the data better?
b. Use your part a answer to predict 1999 sales for Dell.
c. Use your part a answer to describe how the sales of Dell have grown from year to year.
Chapter 18 Solutions
Loose Leaf for Statistical Techniques in Business and Economics
Ch. 18 - Prob. 1SRCh. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 2SRCh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 3SRCh. 18 - Prob. 7E
Ch. 18 - Prob. 8ECh. 18 - Prob. 4SRCh. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 5SRCh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17CECh. 18 - Prob. 18CECh. 18 - Prob. 19CECh. 18 - Prob. 20CECh. 18 - Prob. 21CECh. 18 - Prob. 22CECh. 18 - Prob. 23CECh. 18 - Prob. 24CECh. 18 - Prob. 25CECh. 18 - Prob. 26CECh. 18 - Prob. 27CECh. 18 - Prob. 28CECh. 18 - Prob. 29CECh. 18 - Prob. 30CECh. 18 - Prob. 31CECh. 18 - Prob. 32CECh. 18 - Prob. 33CECh. 18 - Prob. 34DACh. 18 - Prob. 35DACh. 18 - Prob. 36DACh. 18 - Prob. 37DACh. 18 - Prob. 1PCh. 18 - Prob. 2PCh. 18 - Prob. 3PCh. 18 - Prob. 1.1PTCh. 18 - Prob. 1.2PTCh. 18 - Prob. 1.3PTCh. 18 - Prob. 1.4PTCh. 18 - Prob. 1.5PTCh. 18 - Prob. 1.6PTCh. 18 - Prob. 1.7PTCh. 18 - Prob. 1.8PTCh. 18 - Prob. 1.9PTCh. 18 - Prob. 1.10PTCh. 18 - Prob. 2.1PTCh. 18 - Prob. 2.2PTCh. 18 - Prob. 2.3PT
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
- The table shows the historical in-state tuition rates for the University of Kalamazoo. Use the data to answer the questions and round your answers to two decimal places. Academic year Rate of tuition for one semester 2008–2009 $3,812 2009–2010 $4,002 2010–2011 $4,441 2011–2012 $4,905 2012–2013 $5,181 What is the percentage increase in tuition from the 2008–2009 school year to the 2012–2013 school year?arrow_forwardThe Following are the Index Numbers of prices (2002 = 100) %3D Year Index Year Index 2002 100 2007 410 2003 110 2008 400 2004 120 2009 380 2005 200 2010 370 2006 400 2011 340 Shift the base from 2002 – 2008 and recast the Index Numbers.arrow_forwardALZHEIMER'S DISEASE-As baby boomers enter their golden years, the number of people afflicted with Alzheimer's disease is expected to rise dramatically. In a study published in the Journal of Neurology, the number of people with Alzheimer's disease in the United States age 65 and over is projected to be 0.00525t2 0.075t + 4.7 N(t) (0 ts 4) million in decade t, where t=0 corresponds to 2010 a. What is the projected number of people with Alzheimer's disease in the United States age 65 years and over in 2030?arrow_forward
- The Internal Revenue Service Restructuring and Reform Act (RRA) was signed into law by President Bill Clinton in 1998. A major objective of the RRA was to promote electronic filing of tax returns. The data in the table that follows show the percentage of individual income tax returns filed electronically for filing years 2000–2008. Since the percentage P of returns filed electronically depends on the filing year y and each input corresponds to exactly one output, the percentage of returns filed electronically is a function of the filing year;so P(y) represents the percentage of returns filed electronically for filing year y. (a) Find the average rate of change of the percentage of e-filed returns from 2000 to 2002. (b) Find the average rate of change of the percentage of e-filed returns from 2004 to 2006. (c) Find the average rate of change of the percentage of e-filed returns from 2006 to 2008. (d) What is happening to the average rate of change as time passes?arrow_forward. Population Growth and Decline The table gives the population in a small coastal community for the period 1997–2006.Figures shown are for January 1 in each year.(a) What was the average rate of change of populationbetween 1998 and 2001?(b) What was the average rate of change of populationbetween 2002 and 2004?(c) For what period of time was the population increasing?(d) For what period of time was the population decreasing?arrow_forwardEnter the data from Table 2 into a graphing calculator and graph the ranking scatter plot. Determine whetherthe data from the table would likely represent a function that is linear, exponential, or logarithmic.arrow_forward
- Does a linear, exponential, or logarithmic model best fit the data in Table 2? Find the model.arrow_forwardQ. Table provided gives data on gross domestic product (GDP) for the United States for the years 1959–2005. a. Plot the GDP data in current and constant (i.e., 2000) dollars against time. b. Letting Y denote GDP and X time (measured chronologically starting with 1 for 1959, 2 for 1960, through 47 for 2005), see if the following model fits the GDP data: Yt = β1 + β2 Xt + ut Estimate this model for both current and constant-dollar GDP. c. How would you interpret β2? d. If there is a difference between β2 estimated for current-dollar GDP and that estimated for constant-dollar GDP, what explains the difference? e. From your results what can you say about the nature of inflation in the United States over the sample period?arrow_forwardThe population of a certain city was 118,000 in 1994, and the observed relative growth rate is 3% per year.arrow_forward
- Given:(1, 2.0), (1.5, 3.5), (2, 4.0), (4, 5.8), (6, 7.0), (8, 7.8).(a) use a graphing utility to create a scatter plot of the data, (b) decide whether the data could best be modeled by a linear model, an exponential model, or a logarithmic model, (c) explain why you chose the model you did in part (b), (d) use the regression feature of the graphing utility to find the model you chose in part (b) for the data and graph the model with the scatter plot, and (e) determine how well the model you chose fits the data.arrow_forwardThe tuition in the school year 2012–2013 at a certain university was $15,000. For the school year 2017–2018, the tuition was $17,850. Find an exponential growth function for tuition T (in dollars) at this university t years after the 2012–2013 school year. (Round your values to four decimal places.) T = Assuming it increases at the same annual rate, use the function to predict the tuition (in dollars) in the 2021–2022 school year. (Round your answer to the nearest integer.) $arrow_forwardIn 2013 the average houshold credit card balance was $9,884. In 2016 the average houshold credit card balance was $11,184. (a) Compute the average yearly change in credit card balance from 2013 to 2016 (b) Use this to predict what the average credit card balance was in:i. 2014ii. 2015iii. 2017iv. 2018 (c) In 2014 the avearge balance was $10,450 and in 2015 the avearge balance was $10,762. Where your predictions good for those years? (d) In 2017 the average balance was $10,821 and in 2018 the aveage balance was $9,333. Where your predictions good for those years?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
01 - What Is A Differential Equation in Calculus? Learn to Solve Ordinary Differential Equations.; Author: Math and Science;https://www.youtube.com/watch?v=K80YEHQpx9g;License: Standard YouTube License, CC-BY
Higher Order Differential Equation with constant coefficient (GATE) (Part 1) l GATE 2018; Author: GATE Lectures by Dishank;https://www.youtube.com/watch?v=ODxP7BbqAjA;License: Standard YouTube License, CC-BY
Solution of Differential Equations and Initial Value Problems; Author: Jefril Amboy;https://www.youtube.com/watch?v=Q68sk7XS-dc;License: Standard YouTube License, CC-BY