Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17.5, Problem 30E
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow.
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Use the following dummy variables to develop an estimated regression equation to account for any seasonal effects in the data: Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise.
- c. Compute the quarterly forecasts for next year.
- d. Let t = 1 to refer to the observation in quarter 1 of year 1; t = 2 to refer to the observation in quarter 2 of year 1; … and t = 12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part (b) and t, develop an estimated regression equation to account for seasonal effects and any linear trend in the time series. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
An Arts group holds a raffle. Each raffle ticket costs $2 and the raffle consists of 2500 tickets. The prize is a vacation worth $3,000.
a. Determine your expected value if you buy one ticket.
b. Determine your expected value if you buy five tickets.
How much will the Arts group gain or lose if they sell all the tickets?
Please show as much work as possible to clearly show the steps you used to find each solution. If you plan to use a calculator, please be sure to clearly indicate your strategy.
Consider the following game. It costs $3 each time you roll a six-sided number cube. If you roll a 6 you win $15. If you roll any other number, you receive nothing.
a) Find the expected value of the game.
b) If you play this game many times, will you expect to gain or lose money?
=
12:02
WeBWorK / 2024 Fall Rafeek MTH23 D02
/ 9.2 Testing the Mean mu / 3
38
WEBWORK
Previous Problem
Problem List
Next Problem
9.2 Testing the Mean mu:
Problem 3
(1 point)
Test the claim that the population of sophomore college
students has a mean grade point average greater than 2.2.
Sample statistics include n = 71, x = 2.44, and s = 0.9.
Use a significance level of a = 0.01.
The test statistic is
The P-Value is between :
The final conclusion is
< P-value <
A. There is sufficient evidence to support the claim that
the mean grade point average is greater than 2.2.
○ B. There is not sufficient evidence to support the claim
that the mean grade point average is greater than 2.2.
Note: You can earn partial credit on this problem.
Note: You are in the Reduced Scoring Period. All work counts for
50% of the original.
Preview My Answers Submit Answers
You have attempted this problem 0 times.
You have unlimited attempts remaining.
.
Oli
wwm01.bcc.cuny.edu
Chapter 17 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 17.2 - 1. Consider the following time series...Ch. 17.2 - 2. Refer to the time series data in exercise 1....Ch. 17.2 - Prob. 3ECh. 17.2 - 4. Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Prob. 8ECh. 17.3 - 9. With the gasoline time series data from Table...Ch. 17.3 - 10. With a smoothing constant of α = .2, equation...
Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in $...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - Prob. 16ECh. 17.4 - Consider the following time series...Ch. 17.4 - Prob. 18ECh. 17.4 - Prob. 19ECh. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - The following data shows the average interest rate...Ch. 17.4 - Quarterly revenue ($ millions) for Twitter for the...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series.
Construct a...Ch. 17.5 - Consider the following time series...Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Prob. 34ECh. 17.6 - Consider the following time series...Ch. 17.6 - Refer to exercise 35.
Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies, Inc., supplies milk to several...Ch. 17 - Annual retail store revenue for Apple from 2007 to...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Prob. 47SECh. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Prob. 50SECh. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Prob. 52SECh. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise...Ch. 17 - Refer to the Hudson Marine data in exercise...Ch. 17 - Forecasting Food and Beverage Sales
The Vintage...Ch. 17 - The Carlson Department Store suffered heavy damage...
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
- There are four white, fourteen blue and five green marbles in a bag. A marble is selected from the bag without looking. Find the odds of the following: The odds against selecting a green marble. The odds in favour of not selecting a green marble The odds in favor of the marble selected being either a white or a blue marble. What is true about the above odds? Explainarrow_forwardPlease show as much work as possible to clearly show the steps you used to find each solution. If you plan to use a calculator, please be sure to clearly indicate your strategy. 1. The probability of a soccer game in a particular league going into overtime is 0.125. Find the following: a. The odds in favour of a game going into overtime. b. The odds in favour of a game not going into overtime. c. If the teams in the league play 100 games in a season, about how many games would you expect to go into overtime?arrow_forwardexplain the importance of the Hypothesis test in a business setting, and give an example of a situation where it is helpful in business decision making.arrow_forward
- A college wants to estimate what students typically spend on textbooks. A report fromthe college bookstore observes that textbooks range in price from $22 to $186. Toobtain a 95% confidence level for a confidence interval estimate to plus or minus $10,how many students should the college survey? (We may estimate the populationstandard deviation as (range) ÷ 4.)arrow_forwardIn a study of how students give directions, forty volunteers were given the task ofexplaining to another person how to reach a destination. Researchers measured thefollowing five aspects of the subjects’ direction-giving behavior:• whether a map was available or if directions were given from memory without a map,• the gender of the direction-giver,• the distances given as part of the directions,• the number of times directions such as “north” or “left” were used,• the frequency of errors in directions. Identify each of the variables in this study, and whether each is quantitative orqualitative. For each quantitative variable, state whether it is discrete or continuous. Was this an observational study or an experimental study? Explain your answer.arrow_forwardexplain the difference between the confident interval and the confident level. provide an example to show how to correctly interpret a confidence interval.arrow_forward
- Sketch to scale the orbit of Earth about the sun. Graph Icarus’ orbit on the same set of axesWhile the sun is the center of Earth’s orbit, it is a focus of Icarus’ orbit. There aretwo points of intersection on the graph. Based on the graph, what is the approximate distance between the two points of intersection (in AU)?arrow_forwardThe diameters of ball bearings are distributed normally. The mean diameter is 67 millimeters and the standard deviation is 3 millimeters. Find the probability that the diameter of a selected bearing is greater than 63 millimeters. Round to four decimal places.arrow_forwardSuppose you like to keep a jar of change on your desk. Currently, the jar contains the following: 22 Pennies 27 Dimes 9 Nickels 30 Quarters What is the probability that you reach into the jar and randomly grab a penny and then, without replacement, a dime? Express as a fraction or a decimal number rounded to four decimal places.arrow_forward
- A box contains 14 large marbles and 10 small marbles. Each marble is either green or white. 9 of the large marbles are green, and 4 of the small marbles are white. If a marble is randomly selected from the box, what is the probability that it is small or white? Express as a fraction or a decimal number rounded to four decimal places.arrow_forwardCan I get help with this step please? At a shooting range, instructors can determine if a shooter is consistently missing the target because of the gun sight or because of the shooter's ability. If a gun's sight is off, the variance of the distances between the shots and the center of the shot pattern will be small (even if the shots are not in the center of the target). A student claims that it is the sight that is off, not his aim, and wants the instructor to confirm his claim. If a skilled shooter fires a gun at a target multiple times, the distances between the shots and the center of the shot pattern, measured in centimeters (cm), will have a variance of less than 0.33. After the student shoots 28 shots at the target, the instructor calculates that the distances between his shots and the center of the shot pattern, measured in cm, have a variance of 0.25. Does this evidence support the student's claim that the gun's sight is off? Use a 0.025 level of significance. Assume that the…arrow_forwardThe National Academy of Science reported that 38% of research in mathematics is published by US authors. The mathematics chairperson of a prestigious university wishes to test the claim that this percentage is no longer 38%. He has no indication of whether the percentage has increased or decreased since that time. He surveys a simple random sample of 279 recent articles published by reputable mathematics research journals and finds that 123 of these articles have US authors. Does this evidence support the mathematics chairperson's claim that the percentage is no longer 38 % ? Use a 0.02 level of significance. Compute the value of the test statistic. Round to two decimal places.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe 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
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
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
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