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 8 Solutions
Essentials of Business Analytics (MindTap Course List)
- Doctor’s care is a walk-in clinic, with locations in Georgetown mocks corner, and Aynor, at which patients may receive treatment for minor injuries, colds, and flu, as well as physical examinations. The following chart reports the number of patients treated in each of the three locations last month. Describe the number of patients served at the three locations each day. What are the maximum and minimum numbers of patients served at each of the locations? What is the average for each day?arrow_forwardJust simply answer the question.arrow_forwardReliable Furniture is a family business that has been selling to retail customers in the Oakville area for many years. It advertises extensively on radio and TV, emphasizing their its prices and easy credit terms. The owner would like to review the relationship between sales and the amount spent on advertising. Below is information on sales and advertising expense for the last four months. Ad Exp. Sales Rev. Month ($ in 000) ($ in 000) July 2 7 August 1 3 September 3 8 October 4 10 G-9 B continued Questions from G-9 e) Reproduce the excel output manually. f) Interpret the strength of the correlation coefficient. g) Determine the coefficient of determination. Interpret. h) Test the significance of the Coefficient of Correlation i) Test the significance of the slope coefficients of the regression equation.arrow_forward
- Reliable Furniture is a family business that has been selling to retail customers in the Oakville area for many years. It advertises extensively on radio and TV, emphasizing their its prices and easy credit terms. The owner would like to review the relationship between sales and the amount spent on advertising. Below is information on sales and advertising expense for the last four months. Ad Exp. Sales Rev. Month ($ in 000) ($ in 000) July 2 7 August 1 3 September 3 8 October 4 10 a) Determine the regression equation. b) Interpret the values of a and b. c) Estimate sales when $3 thousand is spent on advertising. Include the 95% confidence interval for average X d) Determine the coefficient of correlation.arrow_forwardThe Lawson Fabric Mill Produces five different fabrics. Each fabric can be woven on one or more of the mill’s 36 looms. The sales department’s forecast of demand for the next month is shown in below Table 1, along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The mill has two types of looms: draw and regular. The draw looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The mill has a total of 36 looms: 8 are draw and 28 are regular. The rate of production for each fabric on each type of loom is given in below Table 2. The time required to change over from producing one fabric to another is negligible and does not have to be considered. The Lawson Fabric Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at the…arrow_forwardThe Conch Café, located in Gulf Shores, Alabama, features casual lunches with a great view of the Gulf of Mexico. To accommodate the increase in business during the summer vacation season, Fuzzy Conch, the owner, hires a large number of servers as seasonal help. When he interviews a prospective server, he would like to provide data on the amount a server can earn in tips. He believes that the amount of the bill and the number of diners are both related to the amount of the tip. He gathered the following sample information. Customer Amount of Tip Amount of Bill Number of Diners Customer Amount of Tip Amount of Bill Number of Diners 1 $ 7.00 $ 48.97 5 16 $ 3.30 $ 23.59 2 2 4.50 28.23 4 17 3.50 22.30 2 3 1.00 10.65 1 18 3.25 32.00 2 4 2.40 19.82 3 19 5.40 50.02 4 5 5.00 28.62 3 20 2.25 17.60 3 6 4.25 24.83 2 21 5.50 44.47 4 7 0.50 6.24 1 22 3.00 20.27 2…arrow_forward
- The Conch Café, located in Gulf Shores, Alabama, features casual lunches with a great view of the Gulf of Mexico. To accommodate the increase in business during the summer vacation season, Fuzzy Conch, the owner, hires a large number of servers as seasonal help. When he interviews a prospective server, he would like to provide data on the amount a server can earn in tips. He believes that the amount of the bill and the number of diners are both related to the amount of the tip. He gathered the following sample information. Customer Amount of Tip Amount of Bill Number of Diners Customer Amount of Tip Amount of Bill Number of Diners 1 $ 6.05 $ 73.22 1 16 $ 3.30 $ 23.59 2 2 4.50 28.23 4 17 3.50 22.30 2 3 1.00 10.65 1 18 3.25 32.00 2 4 2.40 19.82 3 19 5.40 50.02 4 5 5.00 28.62 3 20 2.25 17.60 3 6 4.25 24.83 2 21 1.40 41.80 5 7 .50 6.25 1 22 3.00 20.27 2…arrow_forwardThere are hundreds of furniture stores in a county. They all sell two types of bookcases: 3-shelf ones and5-shelf ones. In a sample of 10 of these furniture stores, the bookcases are sold at the following prices:' Store 3-shelf 5-shelfA $30 $50B $30. $50C $30. $50D $35 $50E $35. $50F. $40 $55G $40 $55H. $40 $55I $40 $55J $40. $60Construct a 90% confidence interval for the mean difference between prices for the two types of book-cases.arrow_forwardThe owner of an apartment building can rent all 40 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. Rent Total Revenue $1,600 $ $1,650 $ $1,700 $ No. of Apts 40 39 38 (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 $2200. $ per montharrow_forward
- According to Zillow.com, the median sale price for homes in January for South Carolina, California, and Virginia over the last three years is given in the table below (measured in $100,000). able South Carolina California Virginia 2018 183 534 98 2019 193 555 94 2020 216 569 85 In South Carolina, realtors take 5.4% of the sale price on average as part of their commission. The average realtor commission rates in California and Virginia are 4.9% and 5.3%, respectively. Use matrix multiplication to find the total earned by realtors from their commissionsarrow_forwardTwo children are painting. The first child mixes 3 ounces of red paint with 2 ounces of yellow paint. The second child mixes 4 ounces of red paint with 4 ounces of yellow paint. Which child’s mixture looks more red? (Assume that both mixtures are well mixed.) The first child’s mixture looks more red. The second child’s mixture looks more red. Both mixtures look equally red. There is not enough information to tell.arrow_forwardEditors plan, review, and revise content for publication. Although most editors work in offices, a growing number now work remotely from home. The work can be stressful because editors often have tight deadlines. Proficiency with computers and a bachelor's in communications, journalism, or English are typically required to become an editor. The median annual wage for editors was $54,890 in May, 2014. SOURCE: Bureau of Labor and Statistics, U.S. Department of Labor,Occupational Outlook Handbook, 2016 - 2017 Edition, Editors.Editors review story ideas and decide what material will appeal most to readers. Editors evaluate submissions from writers to decide what to publish. They also typically allocate space for the text, photos, and illustrations that make up a story. A local newspaper is planning a 4-part series of articles on gun control. The editor has received 19 submissions from his writers. He must decide which articles to publish and the sequence in which to publish them. How many…arrow_forward
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman