Basic Business Statistics, Student Value Edition
14th Edition
ISBN: 9780134685113
Author: Mark L. Berenson, David M. Levine, David F. Stephan, Kathryn Szabat
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 16, Problem 37PS
a.
To determine
Perform a residual analysis.
b.
To determine
Compute
c.
To determine
Compute the MAD.
d.
To determine
Discuss which forecasting model should be selected.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The sales manager of a large automotive parts distributor wants to estimate the total annual sales for each of the company’s regions. Three factors appear to be related to regional sales: the number of retail outlets in the region, the total personal income of the region, and the number of cars registered in the region. The following table shows the data for 10 regions that were gathered for last year sales.
The excel data file for this problem is:final exam question 6B spring 2021.xlsx
Region
Annual sales ($ million)
Number of retail outlets
Number of automobiles registered (million)
Personal income ($ billion)
1
37.702
1,739
9.27
85.4
2
24.196
1,221
5.86
60.7
3
32.055
1,846
8.81
68.1
4
3.611
120
4.81
20.1
5
17.625
1,096
10.31
33.8
6
45.919
2,290
11.62
95.1
7
29.600
1,687
8.96
69.3
8
8.114
241
6.28
16.5
9
20.116
649
7.77
34.9
10
12.994
1,427
10.92…
For each of the following situations, state the independent variable and the dependent variable.
a. A study is done to determine if elderly drivers are involved in more motor vehicle fatalities than other drivers. The number of fatalities per 100,000 drivers is compared to the age of drivers.
b. A study is done to determine if the weekly grocery bill changes based on the number of family members.
c. Insurance companies base life insurance premiums partially on the age of the applicant.
d. Utility bills vary according to power consumption.
e. A study is done to determine if a higher education reduces the crime rate in a population.
Only b.ii, iii and iv please.
The output of a solar panel (photovoltaic) system depends on its size. A manufacturer states that the average daily production of its 1.5 kW system is 6.6 kilowatt hours (kWh) for Perth conditions. A consumer group monitored this 1.5 kW system in 20 different Perth homes and measured the average daily production by the systems in these homes over a one month period during October. The data is provided here.
(a) Analyse the consumer group’s data to test if the manufacturer’s claim of an average of 6.6 kWh per day is reasonable. State appropriate hypotheses, assumptions and decision rule at α = 0.10. What conclusions would you report to the consumer group? Hint: You will need to find Descriptive Statistics first.)
(b) If 48 homes in the central Australian city of Alice Springs had this system installed and similar data wascollected, in order to assess whether average daily production in Alice Springs exceeded 6.6 kWh,
(i) what would the alternate hypothesis…
Chapter 16 Solutions
Basic Business Statistics, Student Value Edition
Ch. 16 - If you are using exponential smoothing for...Ch. 16 - Consider a nine-year moving average used to smooth...Ch. 16 - You are using exponential smoothing on an annual...Ch. 16 - Prob. 4PSCh. 16 - Prob. 5PSCh. 16 - How have stocks performed in the past? The...Ch. 16 - Prob. 7PSCh. 16 - Prob. 8PSCh. 16 - Prob. 9PSCh. 16 - Prob. 10PS
Ch. 16 - The linear trend forecasting equation for an...Ch. 16 - There has been much publicity about bounces paid...Ch. 16 - Prob. 13PSCh. 16 - Prob. 14PSCh. 16 - Prob. 15PSCh. 16 - The data shown in the following table and stored...Ch. 16 - Prob. 17PSCh. 16 - Prob. 18PSCh. 16 - Prob. 19PSCh. 16 - Prob. 20PSCh. 16 - Prob. 21PSCh. 16 - Prob. 22PSCh. 16 - You are given an annual time series with 40...Ch. 16 - Prob. 24PSCh. 16 - Prob. 25PSCh. 16 - Prob. 26PSCh. 16 - Prob. 27PSCh. 16 - Prob. 28PSCh. 16 - Prob. 29PSCh. 16 - Using the average baseball salary from 200 through...Ch. 16 - Using the yearly amount of solar power generated...Ch. 16 - The following residuals are from a linear trend...Ch. 16 - Prob. 33PSCh. 16 - Prob. 34PSCh. 16 - Prob. 35PSCh. 16 - Prob. 36PSCh. 16 - Prob. 37PSCh. 16 - Prob. 38PSCh. 16 - Prob. 39PSCh. 16 - Prob. 40PSCh. 16 - In forecasting daily time-series data, how many...Ch. 16 - In forecasting a quarterly time series over the...Ch. 16 - Prob. 43PSCh. 16 - Prob. 44PSCh. 16 - Are gasoline prices higher during the height of...Ch. 16 - Prob. 46PSCh. 16 - Prob. 47PSCh. 16 - The file Silver-Q contains the price in London for...Ch. 16 - Prob. 49PSCh. 16 - What is a time series?Ch. 16 - What are the different components of a time-series...Ch. 16 - What is the difference between moving average and...Ch. 16 - Prob. 53PSCh. 16 - How does the least-squares linear trend...Ch. 16 - How does autoregressive modelling differ from the...Ch. 16 - What are the different approaches to choosing an...Ch. 16 - What is the major difference between using SYX and...Ch. 16 - How does forecasting for monthly or quarterly data...Ch. 16 - Prob. 60PSCh. 16 - The monthly commercial and residential prices for...Ch. 16 - The data stored in McDonalds represent the gross...Ch. 16 - Teachers’ Retirement System of the City of New...Ch. 16 - Prob. 64PS
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
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forward(C) If the number of licensed drivers in state J in 2014 was about 1,037,000, use the model to estimate the population of state J in 2014. The estimated population of state J in 2014 is screenshot attached belowarrow_forwardCalculate Mode from the following data: Class 0-5 5-10 10-15 15-20 20-25 F 2 a. 10 b. 3 С. 12.5 d. None of these answers.arrow_forward
- 4. 2. 2. 3. Express the varia If a truck were driven 80,000 KI expect to be incurred? Archer Company is a wholesaler of custom-built air-conditioning units for commercial buildings. It gathered the following monthly data relating to units shipped and total shipping expense: EXERCISE 5A-4 High-Low Method; Scattergraph Analysis LO5-10 Month January... February. March April.... May June.......**** July Units Shipped 3 6 4 5 7 8 2 Total Shipping Expense $1,800 $2,300 $1,700 $2,000 $2.300 $2.700 $1,200 Required: 1. Prepare a scattergraph using the data given above. Plot cost on the vertical axis and activity on the horizontal axis. Is there an approximately linear relationship between shipping expense and the number of units shipped? Cost-Volume-Profit Relationships Using the high-low method, estimate the cost formula for shipping expense. Draw a straight line through the high and low data points shown in the scattergraph you prepared in require- ment (1). Make sure your line intersects the…arrow_forwardIn this problem, you are to test the validity of your forecasting model. Here are the forecasts for a model you have been using and the actual demands that occurred: WEEK FORECAST ACTUAL 780 890 2 840 990 3 940 1,040 4 940 890 990 890 6. 965 1,060 a. Use the method stated in the text to compute the MAD and tracking signal for each week. (Negative values should be indicated by a minus sign. Round your "Tracking Signal" to 1 decimal place and all other answers to the nearest whole number.) Running Sum of Forecast Errors Sum of Absolute Deviation Mean Absolute Deviation Tracking Signal Absolute Week Forecast Actual Deviation Deviation 1 780 890 840 990 940 1,040 4 940 890 990 890 965 1,060 b. Decide whether the forecasting model you have been using is giving reasonable results. O The forecasting model is acceptable O The forecasting model is unacceptablearrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Calculus For The Life SciencesCalculusISBN:9780321964038Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.Publisher:Pearson Addison Wesley,
Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Calculus For The Life Sciences
Calculus
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:Pearson Addison Wesley,
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY