STAT TECH IN BUSINESS & ECON AC
18th Edition
ISBN: 9781264731657
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
STAT TECH IN BUSINESS & ECON AC
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_forwardNo 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_forward
- Explain trend projection with regression?arrow_forwardmake 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_forward
- make a regression analysis about any healthcare issuearrow_forwardThe scatter plot shows the annual profit for a certain airline (in millions of dollars) for years between 2000 and 2010. The equation of the trend line shown is y = 0.2x +4.1, where x represents the number of years since 2000 and y represents the profit. Use the equation to estimate the profit in 2002. Airline Revenue 10 8- 7. 4 10 Years Since 2000 In 2002, the profit was about $ million. (Type an integer or a decimal.)arrow_forwardPlease check the documents uploaded, which have my answers to the below questions. Please check if my answers are correct, especially the graph for the 2nd question, as I am unsure which one is correct. (USE ONLY EXCEL SHEET FOR DATA, FORMULAS, and the GRAPHS) For the following list of data (number of sold cars in every year ) , apply “exponential smoothing with trend” for all the years below. (i.e find the Forecast including trend) : case1 use : α= 0.01 and β = 0.3 case2 use: for α= 0.1 and β = 0.05 Calculate MAD for both cases. Decide which case values are better and why? Assume trend is zero for the 2012 years. Year Number of sold cars 2012 110 2013 123 2014 160 2015 133 2016 151 2017 175 2018 189 2019 211 2020 255 Based on least squared regression method find the projections for the years 2021, 2022, and 2023. Plot the number of sold cars versus years (points graph) and show the trend line…arrow_forward
- The reason why estimators have a sampling distribution is that: oooo Economics is not a precise science In real life you typically get to sample many times Individuals respond different to incentives The values of the explanatory variable and the error term differ across samples.arrow_forwardThe public school enrollment of a city is 13, 500. Enrollment is declining at a rate of 4.5% per year. Predict the enrollment in 10 years.arrow_forwardBased on the scatterplot and residual plot, what type of model would be appropriate for summarizing the relationship between days and number of views? A popular television show recently released a video preview for the upcoming season on its website. As fans of the show discover the video, the number of views of the preview video has grown each day during the last 2 weeks. The number of days since the release of the video and the natural log of the number of video views is shown in the scatterplot. O An exponential model is appropriate because the residual plot does not show a clear pattern. O A linear model is appropriate because the scatterplot shows a strong, positive linear relationship. In(Views) vs. Days O A power model is appropriate because the scatterplot of days and natural log of views is strong and linear. 10 9.5 An exponential model is appropriate because the relationship between days and the natural log of views is linear, and the residual plot does not show a clear…arrow_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