Hogs & Dawgs is an ice cream parlor on the border of north-central Louisiana and southern Arkansas that serves 43 flavors of ice creams, sherbets, frozen yogurts, and sorbets. During the summer Hogs & Dawgs is open from 1:00 p.m. to 10:00 p.m. on Monday through Saturday, and the owner believes that sales change systematically from hour to hour throughout the day. She also believes her sales increase as the outdoor temperature increases. Hourly sales and the outside temperature at the start of each hour for the last week are provided in the file IceCreamSales.
- a. Construct a time series plot of hourly sales and a
scatter plot of outdoor temperature and hourly sales. What types of relationships exist in the data? - b. Use a simple regression model with outside temperature as the causal variable to develop an equation to account for the relationship between outside temperature and hourly sales in the data. Based on this model, compute an estimate of hourly sales for today from 2:00 p.m. to 3:00 p.m. if the temperature at 2:00 p.m. is 93°F.
- c. Use a multiple linear regression model with the causal variable outside temperature and dummy variables as follows to develop an equation to account for both seasonal effects and the relationship between outside temperature and hourly sales in the data in the data:
Hour1 = 1 if the sales were recorded between 1:00 p.m. and 2:00 p.m., 0 otherwise;
Hour2 = 1 if the sales were recorded between 2:00 p.m. and 3:00 p.m., 0 otherwise;
M
Hour8 = 1 if the sales were recorded between 8:00 p.m. and 9:00 p.m., 0 otherwise.
Note that when the values of the 8 dummy variables are equal to 0, the observation corresponds to the 9:00-to-l0:00-p.m. hour.
Based on this model, compute an estimate of hourly sales for today from 2:00 p.m. to 3:00 p.m. if the temperature at 2:00 p.m. is 93°F.
- d. Is the model you developed in part (b) or the model you developed in part (c) more effective? Justify your answer.
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Essentials Of Business Analytics
- A friend who lives in Los Angeles makes frequent consulting trips to Washington, D.C.;50% of the time she travels on airline #1, 30% of the time on airline #2, and the remaining 20% of the time on airline #3. For airline #1, flights are late into D.C.30% of the time and late into L.A.10% of the time. For airline #2,these percentages are 25% and 20%,whereas for airline #3 the percentages are 40% and 25%.If we learn that on a particular trip she arrived late at exactly one of the two destinations, what are the posterior probabilities of having flown on airlines #1,#2, and #3? Assume that the chance of a late arrival in L.A.is unaffected by what happens on the flight to D.C. [ Hint: From the tip of each first generation branch on a tree diagram, draw three second-generation branches labeled, respectively, 0 late,1late, and 2 late.]arrow_forwardAn electronics retailer list the sales (in thousands) of certain products in three cities for the prior quarter. During that period tablets sold for $245, laptops sold for $960, cell phones sold for $402, and DVR sold for $523. City 1 City 2 52 City 3 61 Tab"ts Laptop Computers 65 54 60 76 Cell Phones 68 72 67 Personal DVR 64 48 66 City 1's total sales : thousand dollars City 2's total sales : thousand dollars City 3's total sales : thousand dollarsarrow_forward. In 2010, of a total of 67,000 rooms on the Las Vegas Strip, Caesars Entertainment managed 22,880, while MGM Resorts managed over 12,000. However, owing to the Great Recession and new hotel openings, between 2008 and 2010, MGM's hotel occupancy decreased from 92% to 89%, while its average daily room rate fell from $148 to $108. Meanwhile, CityCenter, managed by MGM Resorts, and the Cosmopolitan opened with 4,000 and 3,000 rooms respectively, and the 1,720-room Sahara closed. (Sources: Caesars Entertainment Corp., Annual Report 2010; MGM Resorts, Annual Report 2010; "Sahara's closure on May 16 will mark `the end of an era'," Las Vegas Sun, March 11, 2011.) (a) Using a suitable figure, explain how the opening of CityCenter and the Cosmopolitan affects the residual demand for an existing hotel and how it should adjust prices. (b) If MGM Resorts had not reduced its room rates, what would have been the effect on occupancy? (c) Use the Cournot model to explain…arrow_forward
- A researcher believed that the number of rental cars in service by a car rental company would have an impact on the total annual revenue for that car rental company. Five small car rental companies were surveyed, with the number of Cars in service recorded in units of 1000 (so if a car rental company had 54000 cars in service, a 54 would be recorded) and Annual Revenue measured in millions of dollars (so an Annual Revenue of $10,000,000 would be recorded as 10). The data follows: Cars (1,000s) Annual Revenue ($ millions)11.5 118 10.0 135 9.0 100 5.5 37 3.3 32 Part of the Excel-generated Simple Linear Regression output is provided below: ANOVA df SS MS F Significance F Regression 1 7891.863897 7891.863897 22.91180151 0.017339231 Residual 3 1033.336103 344.4453677 Total 4 8925.2 Coefficients Standard Error t Stat P-value Intercept -19.12490108 23.1658578…arrow_forwardA researcher believed that the number of rental cars in service by a car rental company would have an impact on the total annual revenue for that car rental company. Five small car rental companies were surveyed, with the number of Cars in service recorded in units of 1000 (so if a car rental company had 54000 cars in service, a 54 would be recorded) and Annual Revenue measured in millions of dollars (so an Annual Revenue of $10,000,000 would be recorded as 10). The data follows: Cars (1000s) Annual Revenue ($ millions)11.5 118 10.0 135 9.0 100 5.5 37 3.3 32 Part of the Excel-generated Simple Linear Regression output is provided below: ANOVA df SS MS F Significance F Regression 1 7891.863897 7891.863897 22.91180151 0.017339231 Residual 3 1033.336103 344.4453677 Total 4 8925.2…arrow_forwardA researcher believed that the number of rental cars in service by a car rental company would have an impact on the total annual revenue for that car rental company. Five small car rental companies were surveyed, with the number of Cars in service recorded in units of 1000 (so if a car rental company had 54000 cars in service, a 54 would be recorded) and Annual Revenue measured in millions of dollars (so an Annual Revenue of $10,000,000 would be recorded as 10). The data follows: Cars (1000s) Annual Revenue ($ millions)11.5. 11810.0. 1359.0. 1005.5. 373.3. 32 Part of the Excel-generated Simple Linear Regression output is provided below: ANOVA df SS MS F Significance F Regression 1 7891.863897 7891.863897 22.91180151 0.017339231 Residual 3 1033.336103 344.4453677 Total 4 8925.2…arrow_forward
- A researcher believed that the number of rental cars in service by a car rental company would have an impact on the total annual revenue for that car rental company. Five small car rental companies were surveyed, with the number of Cars in service recorded in units of 1000 (so if a car rental company had 54000 cars in service, a 54 would be recorded) and Annual Revenue measured in millions of dollars (so an Annual Revenue of $10,000,000 would be recorded as 10). The data follows: Cars (1000s) Annual Revenue ($ millions)11.5 118 10.0 135 9.0 100 5.5 37 3.3 32 Part of the Excel-generated Simple Linear Regression output is provided below: Regression Statistics Multiple R 0.940331133 R Square 0.884222639 Adjusted R Square 0.845630185 Standard Error 18.55923942…arrow_forwardThe owner of an apartment building can rent all 60 apartments if she charges $1,600 per month, but she rents one fewer apartment for each $50 increase in monthly rent. (a) Construct a table that gives the revenue generated if she charges $1,600, $1,650, and $1,700. No. of Apts 60 59 58 Rent Total Revenue $1,600 $ $1,650 $ $1,700 $ (b) Does her revenue from apartment rentals increase or decrease as she increases the rent from $1,600 to $1,700? O revenue increases O revenue decreases (c) Write an equation that gives the revenue R, from apartment rentals if she makes x increases of $50 in the rent. R(x) = (d) Find the revenue if she increases rent to $3100. $ per montharrow_forwardArianna Estefan manages Salmon Falls Park, which has two flagship roller coasters, the Flyer and the Destroyer. When Arianna walks around the park during hours of operation, she notices that there are fewer people waiting in line for the Flyer than for the Destroyer. Since both roller coasters have similar capacities and similar run times, both roller coasters should have about the same number of riders. Based on the anecdotal evidence, Arianna claims that the population mean number of riders per hour on the Flyer is less than the population mean number of riders per hour on the Destroyer. Arianna reviews data collected in the past and assumes that the population standard deviation is 48.29 for the Flyer and 51.86 for the Destroyer. Arianna randomly selects hours during which the attendant of each ride counts the number of riders. The sampling occurs over the course of several weeks. The results are provided in the table shown below. Assuming the conditions needed for the hypothesis…arrow_forward
- Arianna Estefan manages Salmon Falls Park, which has two flagship roller coasters, the Flyer and the Destroyer. When Arianna walks around the park during hours of operation, she notices that there are fewer people waiting in line for the Flyer than for the Destroyer. Since both roller coasters have similar capacities and similar run times, both roller coasters should have about the same number of riders. Based on the anecdotal evidence, Arianna claims that the population mean number of riders per hour on the Flyer is less than the population mean number of riders per hour on the Destroyer. Arianna reviews data collected in the past and assumes that the population standard deviation is 48.29 for the Flyer and 51.86 for the Destroyer. Arianna randomly selects hours during which the attendant of each ride counts the number of riders. The sampling occurs over the course of several weeks. The results are provided in the table shown below. Assuming the conditions needed for the hypothesis…arrow_forwardA Toot can be made in 30 minutes and has a feather attached to it. A Wheet requires 15 minutes, has two feathers, and is sprinkled with 0.5 oz of sequin powder. A Honk requires 30 minutes, has three feathers, and one oz. of sequin powder. The net profit is $0.40 per Toot, $0.50 per Wheet, and $0.80 per Honk. The following resources are available: 4800 minutes of labor, 360 feathers, and 90 oz. of sequin powder. Determine the quantity of each type of noisemaker that maximizes profit.arrow_forwardA group of sales reps receive bonuses if they exceed theier monthly quotas for unit sales. Over a particular six-month period, their monthly comparisons to their quotas were: -24, -16, +33, +12, -19, and +8 units. How far above or below the quotas were they for the entire six-month period?arrow_forward
- Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell