8. For 12 straight weeks, you have observed the sales (in the number of cases) of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
8. For 12 straight weeks, you have observed the sales (in the number of cases) of canned tomatoes at Mr. D's Supermarket. Each week, you keep track of the following information of your marketing activities: (a) Was an advertisement for canned tomatoes placed in all shopping carts? You use a variable to indicate if your canned tomatoes advertisement was placed in all shopping carts. That is, CartAD =1 if yes, CartAD = 0 if no. (b) Was a coupon for canned tomatoes given to each customer? You also use a variable to indicate if a coupon was issued in the respective week. That is, Coupon =1 if yes, Coupon = 0 if no. (c) Was a price reduction given? You use 1 to indicate 1 cent off, 2 to indicate 2 cents off...... and 0 if there was no price reduction given. To determine how these marketing activities influence sales, you have run a regression analysis using the data you collected and obtained regression analysis results as shown in tables below: Regression Statistics Multiple R 0.940 R Square 0.884 Adjusted R Square 0.840 Standard Error 5.045 Observations 12 df SS MS F Significance F Regression 3 18.953 4.738 4.258 0.00462 Residual 8 58.978 1.113 Total 11 77.931 Coefficients Standard Error t Stat P-value Intercept 24.042 3.089 4.545 0.002 CartAD 20.167 2.913 6.923 0.000 Coupon 30.487 2.566 0.401 0.699 PriceReduction 6.375 1.784 3.574 0.007 All the tests in this question are conducted under a significance level of 0.05. a) Which marketing activity is the most influential strategy on your canned tomatoes' sales? Provide the reason. (3 points) b) When there is no shopping cart in Mr. D's Supermarket available for placing your advertisement, how many cents off do you have to give so that you can achieve the same number of sales as placing a shopping cart advertisement. Please round to the nearest hundredth (two decimals). (3 points) 8. For 12 straight weeks, you have observed the sales (in the number of cases) of canned tomatoes at Mr. D's Supermarket. Each week, you keep track of the following information of your marketing activities: (a) Was an advertisement for canned tomatoes placed in all shopping carts? You use a variable to indicate if your canned tomatoes advertisement was placed in all shopping carts. That is, CartAD =1 if yes, CartAD = 0 if no. (b) Was a coupon for canned tomatoes given to each customer? You also use a variable to indicate if a coupon was issued in the respective week. That is, Coupon =1 if yes, Coupon = 0 if no. (c) Was a price reduction given? You use 1 to indicate 1 cent off, 2 to indicate 2 cents off...... and 0 if there was no price reduction given. To determine how these marketing activities influence sales, you have run a regression analysis using the data you collected and obtained regression analysis results as shown in tables below: Regression Statistics Multiple R 0.940 R Square 0.884 Adjusted R Square 0.840 Standard Error 5.045 Observations 12 df SS MS F Significance F Regression 3 18.953 4.738 4.258 0.00462 Residual 8 58.978 1.113 Total 11 77.931 Coefficients Standard Error t Stat P-value Intercept 24.042 3.089 4.545 0.002 CartAD 20.167 2.913 6.923 0.000 Coupon 30.487 2.566 0.401 0.699 PriceReduction 6.375 1.784 3.574 0.007 All the tests in this question are conducted under a significance level of 0.05. a) Which marketing activity is the most influential strategy on your canned tomatoes' sales? Provide the reason. (3 points) b) When there is no shopping cart in Mr. D's Supermarket available for placing your advertisement, how many cents off do you have to give so that you can achieve the same number of sales as placing a shopping cart advertisement. Please round to the nearest hundredth (two decimals). (3 points)
Expert Answer:
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Posted Date:
Students also viewed these general management questions
-
For 12 straight weeks you have observed the sales (in number of cases) of canned tomatoes at Mr. Ds supermarket. Each week you kept track of the following: Was a promotional notice placed in all...
-
For several consecutive weeks you have observed the sales (in number of cases) of canned tomatoes at Mr. Ds supermarket. Each week you kept track of the following: Was a promotional notice placed in...
-
Suppose the management of the First National Bank of New York decides that it needs to expand its fee-income-generating services. Among the services the bank is considering adding to its service menu...
-
On January 2 of year 1, XYZ Corp. acquired a piece of machinery for $50,000. The asset recovery period for the assets is seven years for both regular tax and AMT purposes. XYZ uses the double...
-
Business Travel News (July 28, 2014) reported the results of its annual Travel Manager Salary & Attitude survey. A total of 248 travel professionals, 76 males and 172 females, participated in the...
-
List some examples of things that retailers (online or in-store) do to increase convenience for their customers.
-
On July 1, 2014, Flanagin Corporation issued $2,000,000, 10%, 10-year bonds at $2,271,813. This price resulted in an effective-interest rate of 8% on the bonds. Flanagin uses the effective-interest...
-
In 1985, 29 year old Anthony Ray Hinton was found guilty on two counts of capital murder and sentenced to death by electric chair. He spent nearly 30 years on death row for crimes he did not commit....
-
Santana Rey created Business Solutions on October 1, 2019. The company has been successful, and its list of customers has grown. To accommodate the growth, the accounting system is modified to set up...
-
Consider the following countries: China (mainland), Indonesia, Japan, Malaysia, the Philippines, Singapore, South Korea, Thailand, and Vietnam to answer the following: a) Among these countries, which...
-
As it relates to productive resource deployment within a society, define the difference between a socialistic and a capitalistic method of making these determinations.
-
We read this week that opportunity cost must be used to make rational decisions, we also read that people should make decisions after considering marginal benefit versus marginal cost. Could you...
-
Explain how fractional reserve banking creates money out of thin air and the potential consequences to the economy if banks over-extend themselves.. Do you think that banks should have a reserve...
-
The risk structure and the term structure of interest rate both signal following; 1. Financial Markets( Liquidity Premium Theory). 2. expectations of future economic activity.( Expectations...
-
Ms Jamie Smithtrading history in these shares is given below from her TD Secutiesaccount On August 27, 2018, shesold 250 shares of QuadarentLtd, a public corporation, for $20 per sha
-
How has the globalization of firms affected the diversity of their employees? Why has increased diversity put an additional burden on accounting systems?
-
For the cell range D4:G15, count the cells containing a numeric value. Count the number of blank cells. Count the number of nonblank cells.
-
The workbook PQPROBLEM5DATA.XLSX contains product sales in a flat file. Use the Power Query Editor to put the data in a tabular format.
-
Compute the mean, variance, and standard deviation of the number of dots showing when a die is tossed.
-
Reverse-current readings (in nanoamperes) are made at the location of a transistor on an integrated circuit. A sample of size 10 is taken every half hour. Since some of the units may prove to be...
-
In order to establish control charts for an extraction job, 30 samples of five measurements of the extracted ores are taken, and the results are \(\overline{\bar{x}}=25.96\) tons and \(\bar{s}=1.5\)...
-
If the sample standard deviations instead of the sample ranges are used to estimate \(\sigma\), the control limits for the resulting \(\bar{x}\) chart are given by \(\overline{\bar{x}} \pm A_{1}...
Study smarter with the SolutionInn App