Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
The total number of thousands of tons of coal produced per year over a 10-year period for a certain region is provided in the accompanying dataset. Use double exponential smoothing to determine which pairs of values for
alphaα
and
betaβ
minimize MAD for this dataset.
alphaαequals=0.10.1,
betaβequals=0.80.8;
alphaαequals=0.40.4,
betaβequals=0.30.3;
alphaαequals=11,
betaβequals=0.60.6
Question content area bottom
Part 1
First find the MAD for each pair of values,
alphaα
and
betaβ.
(Type integers or decimals rounded to two decimal places as needed.)
alphaα
betaβ
MAD
0.10.1
0.80.8
enter your response here
0.40.4
0.30.3
enter your response here
11
0.60.6
enter your response here
Part 2
Which pair of values for
alphaα
and
betaβ
minimize MAD for this dataset?
alphaαequals=enter your response here
and
betaβequals=enter your response here
(Type integers or decimals. Do not round.)
USING EXCEL SOLVER
Check the image for clarification
Q&H Company advertises during soap operas and football games. Each soap opera ad costs $75,000, and each football game ad costs $130,000. If S soap opera ads are purchased, they will be seen by 4S^1/2 million men and 22S^1/2 million women. If F football ads are purchased, they will be seen by 28F^1/2 million men and 10F^1/2 million women. The company wants at least 60 million men and at least 50 million women to see its ads.
Determine how to minimize Q&H’s cost of reaching the required number of viewers.
*Please show the equations in the cells
One of the assumptions made in simple regression is that ______________.
a.
the error terms are exponentially distributed
b.
the error terms have unequal variances
c.
the model is linear
d.
the error terms are dependent
e.
the model is nonlinear
Knowledge Booster
Similar questions
- Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.arrow_forwardWhat is the implication of a data distribution with mean, median and mode being approximately equal? Group of answer choices 1. The spread in the data are equal 2. The data are unstable 3. The data can not be plotted using a Histogram 4. The data are normally distributed 5. The data can not be plotted using a Box Plotarrow_forwardTrue or False: R-squared is a non-decreasing function for the number of independent variables we include in a multiple linear regression, so we should include as many explanatory variables in a regression model as possible.arrow_forward
- I need answer typing clear urjent no chatgpt used i will give upvotes both answers plsarrow_forwardTo better plan for future growth of the restaurant, Karen needs to develop a system that will enable her to forecast food and beverage sales by month for up to one year in advance. Table shows the value of food and beverage sales ($1000s) for the first three years of operation. Food and Beverage Sales for the Vintage Restaurant ($1000s) Month First Year Second Year Third Year January 242 263 282 February 235 238 255 March 232 247 265 April 178 193 205 May 184 193 210 June 140 149 160 July 145 157 166 August 152 161 174 September 110 122 126 October 130 130 148 November 152 167 173 December 206 230 235 Managerial Report Perform an analysis of the sales data for the Vintage Restaurant. Prepare a report for Karen that summarizes your findings, forecasts, and recommendations. Include the following: A time series plot. Comment on the underlying pattern in the time series.…arrow_forwardTrue or False: If our explanatory variables do not vary, our model will produce no estimatesarrow_forward
- In the simple regression model under MLR.1 through MLR.4, we argued that the slope estimator, Bi. is consistent for B1. Using Bo = y – Biữi, show that plim Bo = Bo- [You need to use the consistency of Bị and the law of large numbers, along with the fact that o = E(y) – B,E(x).]arrow_forward0 is a wrong answer!! Please provide other answers.arrow_forwardThis question has multiple correct answers. Pick all the correct answers. If you had to present quantitative data, select all the ones you can use to do so. Group of answer choices position shape different colors size color intensity lengtharrow_forward
- In linear programming, sensitivity analysis is associated with: (I) objective function coefficient (II) right-hand side values of constraints (III) constraint coefficient A. I and II B. II and III C. I, II and III D. I and III E. none of the abovearrow_forwardFocastingarrow_forwardA GMAC MBA new-matriculants survey provided the following data for 2018 students. Excel File: data04-53.xlsx Applied to More Than One School Yes No 23 and under 207 201 24-26 299 379 Age Group 27-30 185 268 31-35 66 193 36 and over 51 169 a. Given that a person applied to more than one school, what is the probability that the person is 24 - 26 years old (to 2 decimals)? b. Given that a person is in the 36 and over age group, what is the probability that the person applied to more than one school (to 4 decimals)? c. What is the probability that a person is 24 - 26 years old or applied to more than one school (to 4 decimals)? d. Suppose a person is known to have applied to only one school. What is the probability that the person is 31 or more years old (to 4 decimals)? e. Is the number of schools applied to independent of age? Explain. Select your answer -arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,