Essentials of Business Analytics (MindTap Course List)
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
Book Icon
Chapter 8, Problem 28P

Donna Nickles manages a gasoline station on the corner of Bristol Avenue and Harpst Street in Arcata, California. Her station is a franchise, and the parent company calls her station every day at midnight to give her the prices for various grades of gasoline for the upcoming day. Over the past eight weeks Donna has recorded the price and sales (in gallons) of regular-grade gasoline at her station as well as the price of regular-grade gasoline charged by her competitor across the street. She is curious about the sensitivity of her sales to the price of regular gasoline she charges and the price of regular gasoline charged by her competitor across the street. She also wonders whether her sales differ systematically by day of the week and whether her station has experienced a trend in sales over the past eight weeks. The data collected by Donna for each day of the past eight weeks are provided in the tile GasStation.

  1. a. Construct a time series plot of daily sales, a scatter plot of the price Donna charges for a gallon of regular gasoline and daily sales at Donna’s station, and a scatter plot of the price Donna’s competitor charges for a gallon of regular gasoline and daily sales at Donna’s station. What types of relationships exist in the data?
  2. b. Use a multiple regression model with the price Donna charges for a gallon of regular gasoline and the price Donna’s competitor charges for a gallon of regular gasoline as causal variables to develop an equation to account for the relationships between these prices and Donna’s daily sales in the data. Based on this model, compute an estimate of sales for a day on which Donna is charging $3.50 for a gallon for regular gasoline and her competitor is charging $3.45 for a gallon of regular gasoline.
  3. c. Use a multiple linear regression model with the trend and dummy variables as follows to develop an equation to account for both trend and seasonal effects in the data:

Monday = 1 if the sales were recorded on a Monday. 0 otherwise;

Tuesday = 1 if the sales were recorded on a Tuesday, 0 otherwise;

M

Saturday = 1 if the sales were recorded on a Saturday, 0 otherwise;

Note that when the values of the six dummy variables are equal to 0, the observation corresponds to Sunday.

Based on this model, compute an estimate of sales for Tuesday of the first week after Donna collected her data.

  1. d. Use a multiple regression model with the price Donna charges for a gallon of regular gasoline and the price Donna’s competitor charges for a gallon of regular gasoline as causal variables and the trend and dummy variables from part (c) to create an equation to account for the relationships between these prices and daily sales as well as the trend and seasonal effects in the data. Based on this model, compute an estimate of sales for Tuesday of the first week after Donna collected her data a day if Donna is charging $3.50 for a gallon for regular gasoline and her competitor is charging $3.45 for a gallon of regular gasoline.
  2. e. Which of the three models you developed in parts (b), (c), and (d) is most effective? Justify your answer.
Blurred answer
Students have asked these similar questions
You recently received a job with a company that manufactures an automobile anti theft device. To conduct an advertising campaign for the product, you need to make a claim about the number of automobile thefts per year. Since the population of various cities in the United States varies, you decide to use rates per 10,000 people. (The rates are based on the number of people living in the cities.) Your boss said that last year the theft rate per 10,000 people was 44 vehicles. You want to see if it has changed. The following are rates per 10,000 people for 36 randomly selected locations in the United States. Assume σ = 30.3. U s e α = 0.05   Car Thefts 55 42 125 62 134 73 39 69 23 94 73 24 51 55 26 66 41 67 15 53 56 91 20 78 70 25 62 115 17 36 58 56 33 75 20 16 Use the traditional method to conduct the hypothesis test.   a/ Write the conjuncture b/ Find the critical value(s) c/ Find the test value d/ Make a decision e/ Write the summary
Rahul p.
A new self­tanning lotion for everyday use is to be sold. First, an experimental lotion mixture is made by mixing 800 ounces of everyday moisturizing lotion worth $0.30 an ounce with self­tanning lotion worth $3 per ounce. If the experimental lotion is to cost $1.20 per ounce, how many

Chapter 8 Solutions

Essentials of Business Analytics (MindTap Course List)

Knowledge Booster
Background pattern image
Statistics
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Text book image
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Algebra for College Students
Algebra
ISBN:9781285195780
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
what is Research Design, Research Design Types, and Research Design Methods; Author: Educational Hub;https://www.youtube.com/watch?v=LpmGSioXxdo;License: Standard YouTube License, CC-BY