Question

In: Statistics and Probability

Wendy's wonders how to price its new chili salad. It test-markets five different prices in the...

Wendy's wonders how to price its new chili salad. It test-markets five different prices in the cities listed below, with the listed resultant sales (in thousands of dollars). Calculate correlation, and the regression model.

City Sales($000s) Price($) Price^2 Sales^2 Price*Sales
Rochester 75 0.99 0.98 5625.00 74.3
Ottumwa 70 1.29 1.66 4900.00 90.3
Seattle 45 1.49 2.22 2025.00 67.1
Raleigh 33 1.89 3.57 1089.00 62.4
Denair 42 2.19 4.80 1764.00 92.0
sum 265 7.85 13.23 15403.00 386.0
mean 53 1.57 2.65 3080.60 77.2
st.dev. 18.4 0.5 1.53 2037.06 13.4

Solutions

Expert Solution

X Values
∑ = 601.4
Mean = 75.175
∑(X - Mx)2 = SSx = 43565.315

Y Values
∑ = 17.77
Mean = 2.221
∑(Y - My)2 = SSy = 38.098

X and Y Combined
N = 8
∑(X - Mx)(Y - My) = 1222.75

R Calculation
r = ∑((X - My)(Y - Mx)) / √((SSx)(SSy))

r = 1222.75 / √((43565.315)(38.098)) = 0.9491

Sum of X = 601.4
Sum of Y = 17.77
Mean X = 75.175
Mean Y = 2.2213
Sum of squares (SSX) = 43565.315
Sum of products (SP) = 1222.7503

Regression Equation = ŷ = bX + a

b = SP/SSX = 1222.75/43565.32 = 0.0281

a = MY - bMX = 2.22 - (0.03*75.18) = 0.1113

ŷ = 0.0281X + 0.1113


Related Solutions

Why might a company sell its products for different prices in different markets even if the...
Why might a company sell its products for different prices in different markets even if the income levels of its target consumers were the same in all cases?
Firms often employ price discrimination. They try to segment their markets and charge different prices to...
Firms often employ price discrimination. They try to segment their markets and charge different prices to customers with different demand elasticities. The theory is simple. Identify those customers with highly-elastic demands (they're the ones who are very sensitive to price and will be driven into the arms of your competitors by high prices), and cut prices. Next, identify customers with less-elastic demands (they're the ones who are insensitive to price and are likely to buy anyway), and drive the price...
if huy fong were to introduce a new mildr version of its reowned sriracha hot chili...
if huy fong were to introduce a new mildr version of its reowned sriracha hot chili sauce ro satisfy customers who think the current product is too spicy and the orginao prodcut is kept in the product mix, this would represent a
A monopoly can discriminate prices between its New York and Los Angeles markets. The demand functions...
A monopoly can discriminate prices between its New York and Los Angeles markets. The demand functions are: QNY=50−(1/3)PNY QLA=80−(2/3)PLA The cost function is: CT = 1000 + 30Q Where Q=QNY + QLA a) Determine the prices and amounts that maximize profits for the company. b) If one can no longer discriminate and only one price has to be charged, what is the new price and quantity of profit maximizers? c) In which situation is the company and the NY and...
Why do we, as consumers, prefer the prices found in competitive markets? How are the prices...
Why do we, as consumers, prefer the prices found in competitive markets? How are the prices in perfectly competitive markets determined? Explain, Which of the four market structures that we covered is most profitable for the firm? Is this the best market structure for consumers? Why or why not? Explain. We've made a pretty big deal about the differences between fixed and variable costs. Why does variable cost change as output changes? From your perspective as a manager, why is...
A U.S. firm wants to sell its product to two different markets abroad: Belgium and New...
A U.S. firm wants to sell its product to two different markets abroad: Belgium and New Zealand, and you must decide whether to do so by exporting or by producing locally in that market through FDI (setting a subsidiary). In both destinations, the demand for the product is: P = 50 – Q, [Marginal revenue is MR = 50– 2*Q ]. P is the price your firm charges in that country in dollars and Q is the quantity sold there....
why is there emphasis on non price competition in oligopoly markets than on lowering prices to...
why is there emphasis on non price competition in oligopoly markets than on lowering prices to gain market share?
Price discrimination is the practice of charging different customers or groups of customers different prices for...
Price discrimination is the practice of charging different customers or groups of customers different prices for the same product. Why does price discrimination occur? Describe the conditions that must be present for price discrimination to occur and justify your answer.
How sustainable is Walmart’s strategy? In its traditional markets and in the new ones. Why?
How sustainable is Walmart’s strategy? In its traditional markets and in the new ones. Why?
Joe is trying out a new ride-sharing app, and wonders whether its mean waiting time is...
Joe is trying out a new ride-sharing app, and wonders whether its mean waiting time is less than the 5 minutes that his current app offers. After 30 ride shares, he records an average waiting time of 4.5 minutes, with a sample standard deviation of 3 minutes. (a) Compute the p-value of testing the null that the new app has a mean waiting time of at least 5 minutes. (Hint: in Excel, use the command T.DIST(x,degrees of freedom,true).) (b) What...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT