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.
- 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? - 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.
- 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.
- 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.
- e. Which of the three models you developed in parts (b), (c), and (d) is most effective? Justify your answer.
Want to see the full answer?
Check out a sample textbook solutionChapter 8 Solutions
Essentials of Business Analytics (MindTap Course List)
- A marketing company surveys 1,200 people. They surveyed twice as many females as males. How many males and females did they survey?arrow_forwardThe amount of money spent on a pizza for club activities varies directly with the number of pizzas bought. If $135 will pay for fifteen pizzas, then how many pizzas can be bought with $252? a'arrow_forwardThere is a new food delivery company that charges $6 to deliver 4 meals and $10 to deliver 12 meals. If the charging rate remains constant, how much will it cost to deliver 7 meals?arrow_forward
- A life insurance policy costs $13.01 for every $1,000 of insurance. At this rate, what is the cost of $80,000 of insurance?arrow_forwardThe average expenditure of 100 labourers is Dollar 20. If the average expenditure of all 150 labourers is Dollar 25, calculate the average expenditure of remaining 50 labourers?arrow_forwardIn 14 weeks, the value of Bob Treatman's day trading account decreased by $588. What was the average weekly change in the value of the account? .... A. $40 per week O B. - $44 per week O C. - $42 per week O D. - $48 per weekarrow_forward
- From January through April (15 weeks), a local accounting and tax firm must complete the 3,000 tax filings. Of these filings, 70% are businesses and the remaining are individuals. Each business filings takes 20 manhours to complete and individual tax filings take six (6) manhours to complete. If each tax accountant is limited to 60 hours per week, what is the average rate (hours per return) to complete these tax filings?arrow_forwardCasa Vana Inn has 500 guest rooms, has an ADR of $110 per room, and is currently operating at an 80% average occupancy. The hotel offers 200 one-bed and 300 two-bed guestrooms. Management has established single and double rack rates for each room type. Any one-bed room as a single at $100; as a double, it sells for $120. Any two-bedroom sold as a single is priced at $115; as a double sell for $ 130. Hint:(Assume Casa Vana 210 of 400 rooms sold at 70% occupancy) 1. Potential Average Single Rate 2. Potential Average Double Rate 3. Multiple Occupancy Percentage 4. Rate Spread 5. Potential Avg. Rate 6. Room rate achievement factor 7. Yield Statisticarrow_forwardA taxi charges $3.50 for up to and including the first mile, and $1.40 for each mile thereafter. What would the taxi charge for a trip of 12 miles?arrow_forward
- Break.com is an ad-supported video-sharing website. Its advertisers can choose to have their ad displayed for some amount of time on particular page within the website. Break.com charges per impression made of an ad, i.e., per visitor that sees the ad. The cost for displaying an ad is usually quoted in cost-per-thousand impressions (CPM). For the homepage, the CPM is $9. The number of visitors per day to Break.com is random. Break.com claims that over the past 60 days the average number of visitors to the homepage per day is 1 million. Furthermore, Break.com claims the population standard deviation is 0.25 million. Calculate a 95% confidence interval for the average number of visitors to the homepage per day.arrow_forwardA scientist visited Amazon.com to purchase a book. To his amazement, he found the book priced at $23,698,655.93. He discovered that there were two vendors selling this book on Amazon, and each was using a computer to adjust the price based on the other seller's price. The result was that each day the first vendor's price was multiplied by 1.27. Assume that the initial price was $134.27, and determine how many days it took for the first vendor's price to reach the exorbitant figure above. Round your answer to the nearest day. daysarrow_forwardA waitress is paid $15.50 per hour. If her workweek is 37.50 hours, what is her monthly pay?arrow_forward
- Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal LittellElementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice UniversityHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillAlgebra for College StudentsAlgebraISBN:9781285195780Author:Jerome E. Kaufmann, Karen L. SchwittersPublisher:Cengage Learning