STATISTICAL TECHNIQUES IN BUSINESS AND E
18th Edition
ISBN: 9781260570489
Author: Lind
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 18, Problem 1P
a.
To determine
To calculate: The index for 2018, using 2011 as the base period.
b.
To determine
To calculate: The index for 2018, using 2011 to 2013 as the base period.
c.
To determine
To calculate: The trend equation using
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Siena Ltd attempts to find the trend of its sales over the past five years. Siena is considering which model that best represent the trends of its sales. Following are the result of linear and exponential model trend analysis:
a. Calculate the MSE and MAD for the linear trend model
b. Calculate the MSE and MAD for the exponential trend model
c. Which model that performs better
Illustration 15.35. In trying to evaluate the effectiveness of its
advertising campaign, a firm compiled the following data:
Year:
1973 1974 1975 1976 1977 1978 1979 1980
48
Expenditure ('000): 12
Sale (lacs):
15
15
23
24
38
42
5.0
5.6
5.8
7.0
7.2
8.8
9.2
9.5
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Price/Book Value Ratio Return on Equity
13.032
1.405
8.305
2.113
6.654
1.239
3.262
2.449
5.291
2.398
7.719
0.353
2.569
7.593
5.104
2.012
4.797
2.182
4.129
1.918
1.549
1.951
5.046
2.417
2.159
3.011
1.725
5.582
4.698
Growth%
6.385
11.846 135.669
12.459
0.073
25.092
14.188
8.804
22.766
38.082
18.985
25.696
24.519
19.666
11.624
22.849
49.965
69.649 36.696
3.819 41.139
9.218
29.108
17.772
25.114
29.295 23.764
31.405
9.497
14.759
18.541
12.026
39.016
14.228
39.439
14.097
27.022
14.841
13.237
20.669
17.311
14.887
15.849
5.601
16.775
11.172
8.401
16.161
18.404
23.973 16.673
14.725 46.605
28.839
52.021
Chapter 18 Solutions
STATISTICAL TECHNIQUES IN BUSINESS AND E
Ch. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 1SRCh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 7ECh. 18 - Prob. 8ECh. 18 - Prob. 2SR
Ch. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 3SRCh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17ECh. 18 - Prob. 18ECh. 18 - Prob. 4SRCh. 18 - Prob. 19ECh. 18 - Prob. 20ECh. 18 - Prob. 21ECh. 18 - Prob. 22ECh. 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. 34CECh. 18 - Prob. 35CECh. 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
Similar questions
- The US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the trend appearslinear. Ifso, and assuming the trend continues, in what year will imports exceed 12,000 hectoliters?arrow_forwardTable 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_forwardThe following table gives the average monthly exchange rate between the U.S. dollar and the euro for 2009. It shows that 1 euro was equivalent to 1.289 U.S. dollars in January 2009. Develop a trend line that could be used to predict the exchange rate for 2010. Use this model to predict the exchange rate for January 2010 and February 2010. MONTH ______________________ EXCHANGE RATE January ....................................... 1.289 February ...................................... 1.324 March ......................................... 1.321 April .......................................... 1.317 May ........................................... 1.280 June ........................................... 1.254 July ........................................... 1.230 August ....................................... 1.240 September ................................... 1.287 October ..................................... 1.298 November .................................. 1.283 December…arrow_forward
- No need to answer everything! Just plot the actual visitors and the forecasts. Compare the accuracy of the forecasts in the 1985 to 1990 period with those subsequent to that period.arrow_forwardA sample of bacteria starts with 800 bacteria and doubles about every month. a. Describe the input variable. b. Describe the output variable. C. If linear, find and interpret the rate of change. If exponential, find and interpret the percent change. Approximate if needed. d. Write the equation that models the data, and define the variables in the equation.arrow_forwardIf an asset declines in value from $5,000 to $2,600 over nine years, what is the mean annual growth rate in the asset's value over these nine years? Enter your answer as a percentage. If needed, round your answer to two decimal digits.arrow_forward
- make a scatterplot of the data. Make sure to include an appropriate title as well as titles for your x and y-axis, including correct units. Use the Add Trendline Feature and choose exponential. Also, make sure to click on to display equation and display r-squared value to place these on your graph as well. You may also want to use the Forward feature and move forward 50 to help adjust the graph for making some predictions. For your first prediction, estimate the heart death rate for people who are 80 years old. Remember, the death rate is in deaths per 100,000 people. Write this prediction as a complete an interpretation, that is, as a complete sentence with correct units for measure describing the number of deaths per 100,000 for those who are in their 80's. Make sure to indicate if this is an example of interpolation or extrapolation. If this is extrapolation, make sure to mention there is some risk involved. For your second prediction, use the equation to predict the age of when…arrow_forwardFrom the question above predict the worldwide sales of e-cigarettes in 2012. Use the average growth rate for 2011-2014.arrow_forwardmake a regression analysis about any healthcare issuearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningGlencoe 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
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher: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