Statistical Techniques in Business and Economics
16th Edition
ISBN: 9780077639723
Author: Lind
Publisher: Mcgraw-Hill Course Content Delivery
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 18, Problem 25CE
a.
To determine
Graph the data.
b.
To determine
Determine the least squares trend equation.
Identify the most accurate forecast.
c.
To determine
Compute the points for the years 1993 and 1998 using the equation with the logarithm of price.
d.
To determine
Estimate the selling price in 2015 using the equation with the logarithm of price.
Explain whether it is a reasonable estimate based on the historical data.
e.
To determine
Obtain the average amount of increase (or decrease) in stock price per year during the given period.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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
Eloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's
been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data
to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next
Friday? Assume she works only on weekdays.
Day
Pages
Monday
425
Tuesday 431
Wednesday 449
Thursday 464
Friday
471
A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line?
The slope is
The intercept is
B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday?
Yes
mex PLC has gathered following information on the sales of face mask from April 2020 to
september 2020.
Month Sales ($)
April 17,000
May 18,000
June 19,500
July 22,000
August 21,000
September 23,000
You are required to3;
a. Using linear trend equation forecast the sales of face masks for October 2020.
Chapter 18 Solutions
Statistical Techniques in Business and Economics
Ch. 18 - Prob. 1SRCh. 18 - Calculate a four-quarter weighted moving average...Ch. 18 - Prob. 2ECh. 18 - Prob. 2SRCh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Sales at Tomlin Manufacturing from 2009 to 2013...Ch. 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 - Refer to Exercise 9 regarding the absences at...Ch. 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 - The quarterly production of pine lumber, in...Ch. 18 - Prob. 29CECh. 18 - Sales of roof material, by quarter, for 2007...Ch. 18 - Blueberry Farms Golf and Fish Club of Hilton Head,...Ch. 18 - Prob. 32CECh. 18 - Ray Anderson, owner of Anderson Ski Lodge in...Ch. 18 - Prob. 34CECh. 18 - Prob. 35CECh. 18 - Prob. 36CECh. 18 - Consider the variable mean amount per transaction...Ch. 18 - Prob. 38CECh. 18 - Prob. 39DECh. 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 - Listed below are the price and quantity of several...Ch. 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
- 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_forwardThe 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_forwardThe U.S. Census tracks the percentage of persons 25 years or older who are college graduates. That data forseveral years is given in Table 4[14]. Determine whether the trend appears linear. If so, and assuming the trendcontinues. in what year will the percentage exceed 35%?arrow_forward
- DVD Player sales The table shows the number of DVD play-ers sold in a small electronics store in the years 2003-2013. What was the average rate of change of sales between 2003 and 2013? Whatwas the average rate of change of sales between 2003 and 2004? What was the average rate of change of sales between 2004 and 2005? Between which two successive years did DVD player sales increase most quickly?arrow_forwardAnswer the circled onesarrow_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
- using the data from the images, compare and analyze the trends shown on the graphs and relate them to the question: does chronic cigarette smoking affect the birth weight and gestational period of a newborn baby? Also please mention something regarding parents who don't smoke and their baby's results. Birth weight Gestational period Birthweight Gestational period 2.65 33 1.92 33 2.9 39 2.05 35 2.92 34 2.37 37 3.03 39 2.51 39 3.11 37 2.66 35 3.15 40 2.74 39 3.2 41 2.75 40 3.23 38 2.78 37 3.27 40 3 38 3.35 41 3.14 41 3.42 38 3.18 38 3.63 38 3.19 41 3.65 42 3.32 40 3.77 40 3.32 39 3.93 38 3.41 39 3.94 42 3.53 40 4.07 44 3.55 41 4.1 41 3.59 40 4.32 40 3.64 40 4.55 44 3.86 39 (non smoking) 3.87 45 4.57 41arrow_forwardThe accompanying table gives the stock market indices for a certain company on the stock market. Use simple linear regression to forecast the data. What would be the forecasts for the next three days? Click the icon to view the stock market indices for the company on the stock market. Select the graph that shows the correct trendline forecast for the given data. O Click here to view the graph d. O Click here to view the graph b. • Click here to view the graph a. O Click here to view the graph c What would be the forecast for the next three days? (Round to two decimal places as needed.) Index Date 10/2/2010 10/3/2010 10/4/2010 B F G A H Date Index 9/3/2010 10448.19 9/7/2010 10340.44 9/8/2010 10386.08 9/9/2010 10414.94 9/10/2010 10461.14 9/13/2010 10545.98 9/14/2010 10527.68 9/15/2010 10574.14 0 9/16/2010 10596.74 1 9/17/2010 10606.46 2 9/20/2010 10752.05 3 9/21/2010 10759.95 4 9/22/2010 10738.52 5 9/23/2010 10661.03 16 9/24/2010 10859.59 17 9/27/2010 10810.12 18 9/28/2010 10856.59 19…arrow_forwardQ6 A. Plot the data points . Choose the correct graph below. B. Did the number of new products that contain the sweetener increase, decrease, stay approximately constant, or none of these? Choose the correct answer below. a. Increased b. None of these c. Decreased d. Stayed about the same C. Did the annual change in the number of new products that contain the sweetener increase, decrease, stay approximately constant, or none of these ? Choose the correct answer below. a. None of these b. Increased c. Decreased d. Stayed about the samearrow_forward
- 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.5arrow_forwardSuppose you ran a quadratic trend forecasting model on some time series data for 18 months. The Excel Data Analysis regression output provided the following: Intercept: 45.140 Slope 1: -1.940 Slope 2: 0.195 What is the forecast value for time period 21? 4.4 90.395 43.395 8.495arrow_forwardCalculate trend values by the method of Least Square from the data given below and estimate the sâles for 2007. Year 2000 2001 2002 2003 2004 Sales of G.A. (Rs. lakhs) 70 74 80 86 90arrow_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
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY