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 residuals for data set A and data set B were calculated and plotted on
separate residual plots. If the residuals for data set A do not form a pattern
and the residuals for data set B do not form a pattern, what can be
concluded?
OA. A linear model is a good fit for data set A but not data set B.
O B. A linear model is a good fit for data set B but not data set A.
AC. A linear model is a good fit for both data sets.
D. A linear model is not a good fit for either data set.
i need help on parts a,b and c.
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…
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_forwardThe following ACF plots were produced for raw data of monthly sales of two different variables, A and B. a) Explain which variable is likely to be easier to forecast. b) Explain how your answer to part a) would change if these were residuals of an ARIMA model instead of “raw data of monthly sales”.arrow_forwardPlese show steps on how to put into exel spreedsheetarrow_forward
- I need help with part 3arrow_forward4. 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_forwardFor 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.arrow_forward
- In 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_forward1. (10 ) According to the PayScale data from 2021, the average starting salaries by college major for bachelor's degree are as follows: $70,600 for mechanical engineering, $56,700 for economics, $43,500 for chemistry, and $47,000 for philosophy. In order to estimate the true difference in the average starting salaries by college major in 2022, 60 graduates with these four majors from the class of 2022 were contacted and questioned about their starting salaries. Propose a regression model with dummy variables that could be used to investigate if starting salaries are different by college major and interpret all the coefficients in the model. 0.000arrow_forwardTable 2.16, from a recent General Social Survey, cross-classifies the degree of fundamentalism of subjects’ religious beliefs by their highest degree of education. The table also shows standardized residuals. For these data, X2 = 69.2. Write a report of about 200 words, summarizing description and inference for these data.arrow_forward
- This problem is based on problems 18.1, 18.2, 18.9, & 18.10 from Lomax & Hahs-Vaughn, 3rd ed.You are given the following data, where X1 (years of working experience at current position) and X2 (salary in thousands) are used to predict Y (morale): Y X1 X2 150 4 42 180 10 52 115 2 28 180 7 38 185 3 31 175 9 53 160 6 49 120 2 33 130 2 30 195 9 56 Determine the following multiple regression values.Report intercept and slopes for regression equation accurate to 3 decimal places: Intercept: a= Partial slope X1: b1= Partial slope X2: b2=Report sum of squares and coefficient of multiple determination accurate to 3 decimal places: R2= SSTotal=Test the significance of the overall regression model (report F-ratio accurate to 3 decimal places and P-value accurate to 4 decimal places): F-ratio = P-value = Report the variance of the residuals accurate to 3 decimal places: s2res=Report the results for the hypothesis test for the…arrow_forwardThe director of a local Tourism Authority would like to know whether a family’s annual expenditure on recreation (y), measured in $000s, is related to their annual income (x), also measured in $000s. In order to explore this potential relationship, the variables x and y were recorded for 10 randomly selected families that visited the area last year. The results were as follows: Week 1 2 3 4 5 6 7 8 9 10 x 41.2 50.1 52.0 62.0 44.5 37.7 73.5 37.5 56.7 65.2 y 2.4 2.7 2.8 8.0 3.1 2.1 12.1 2.0 3.9 8.9 The summary statistics for these data are: Sum of x data: 520.4 Sum of the squares of x data: 28431.42 Sum of y data: 48 Sum of the squares of y data: 343.74 Sum of the products of x and y data: 2858.63 Calculate the sample correlation coefficient. Interpret the findings.arrow_forwardThe director of a local Tourism Authority would like to know whether a family’s annual expenditure on recreation (y), measured in $000s, is related to their annual income (x), also measured in $000s. In order to explore this potential relationship, the variables x and y were recorded for 10 randomly selected families that visited the area last year. The results were as follows: Week 1 2 3 4 5 6 7 8 9 10 x 41.2 50.1 52.0 62.0 44.5 37.7 73.5 37.5 56.7 65.2 y 2.4 2.7 2.8 8.0 3.1 2.1 12.1 2.0 3.9 8.9 The summary statistics for these data are: Sum of x data: 520.4 Sum of the squares of x data: 28431.42 Sum of y data: 48 Sum of the squares of y data: 343.74 Sum of the products of x and y data: 2858.63 (i) Draw a scatter diagram of these data.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
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