Question

In: Statistics and Probability

Statistics EXERCISE 2. Anna Sheehan is the manager of the Spendwise supermarket chain. She would like...

Statistics

EXERCISE 2. Anna Sheehan is the manager of the Spendwise supermarket chain. She would like to be able to predict paperback book sales (books per week) based on the amount of shelf display space (in feet) provided. Anna gathers data for a sample of 11 weeks.

Week Number of books sold, Y Feet of shelf space, X
1 275 6,8
2 142 3,3
3 168 4,1
4 197 4,2
5 215 4,8
6 188 3,9
7 241 4,9
8 295 7,7
9 125 3,1
10 266 5,9
11 200 5,0

a) Plot a scatter diagram b) What kind of relationship exists between these two variables? c) Compute the correlation coefficient. d) Determine the sample regression equation e) Estimate paperback book sales for a week in which 4 feet of shelf space are provided. Answer. b) positive c) 0,95 d) Y = 36,4053X + 32,4576 e) 178,0779.

EXERCISE 3. A random sample of 5 families shows the following information concerning annual family income and annual expenditure on durable goods (refrigerators, washing machines, stereos and so on):

Family Annual Income (thousand of euros) Expenditure on Durable Goods (hundreds of euros)
Addison 5 1
Baum 8 2
Clearly 7 1
Dunn 10 2
Evans 15 4

a) Determine the estimated regression equation Y = aX + b; b) Estimate the annual expenditure on durable goods of a family earning 12000 euros per year. Answer. a) Y = 0,31X – 0,79; b) 293 euros.

Please show your workings, I have provided you with the possible answers but they might be wrong as well due our book. Thank you in advance!

Solutions

Expert Solution

Solution:

EXERCISE 2:

a) Plot a scatter diagram

Answer:

b) What kind of relationship exists between these two variables?

Answer: Since the scatterplot shows an uphill pattern from the left to the right of the scatterplot, therefore, there exists a positive linear relationship between these two variables.

c) Compute the correlation coefficient

d) Determine the sample regression equation

Answer:

Where:

e) Estimate paperback book sales for a week in which 4 feet of shelf space are provided.

EXERCISE 3:

a) Determine the estimated regression equation Y = aX + b

b) Estimate the annual expenditure on durable goods of a family earning 12000 euros per year.

Answer:

Since expenditure is in 100's, therefore, the predicted value is 2.93 x 100 = 293 euros


Related Solutions

The marketing manager of a large supermarket chain would like to use shelf space to predict...
The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of pet food. For a random sample of 15 similar stores, she gathered the following information regarding the shelf space, in feet, devoted to pet food and the weekly sales in hundreds of dollars. . Store Shelf Space Weekly Sales 1 5 1.3 2 5 1.6 3 5 1.4 4 10 1.7 5 10 1.9 6 10 2.3 7 15 2.2 8...
The marketing manager of a large supermarket chain would like to use shelf space to predict...
The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of pet food. A random sample of 12 equal-sized stores is selected, with the following results. Shelf Space Sales Aisle Location 5 160 0 5 220 1 5 140 0 10 190 0 10 240 0 10 260 1 15 230 0 15 270 0 15 280 1 20 260 0 20 290 0 20 310 1 A. Construct a scatter plot...
1. The marketing manager of a large supermarket chain would like to use shelf space to...
1. The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of a specialty pet food. Data are collected from a random sample of 8 equal-sized stores, with the following results: Store Shelf Space (in square feet) Weekly Sales (in Dollars) 1 4 120 2 4 150 3 8 160 4 8 180 5 12 200 6 16 210 7 16 240 8 20 260 Use Excel to find the regression results...
The manager of a supermarket chain wants to determine if the location of the product -...
The manager of a supermarket chain wants to determine if the location of the product - where it is to be displayed - has any effect on the sale of a pet toys. Three different aisle locations are to be considered: the front of the aisle, the middle of the aisle, or the rear-aisle. Twenty-one stores are randomly selected, with 7 stores randomly assigned to sell the pet toy at the front-aisle, the middle-aisle, and the rear-aisle. Front Middle Rear...
Anna would like to study more because she feels as if her scores on tests can...
Anna would like to study more because she feels as if her scores on tests can be better. Outline a step-by-step behavior modification program that might help her achieve her goal.
Imagine what the balanced scorecard of a supermarket chain could be like. Focus on the customer...
Imagine what the balanced scorecard of a supermarket chain could be like. Focus on the customer as well as learning and growth perspectives. Write two objectives that a supermarket chain would be likely to set for the customer perspective and also for the learning and growth perspective and add a possible measure to each objective.
Imagine what the balanced scorecard of a supermarket chain could be like. Focus on the customer...
Imagine what the balanced scorecard of a supermarket chain could be like. Focus on the customer and internal processes perspectives. Write two objectives that a supermarket chain would be likely to set for both the customer and internal processes perspective and add a possible measure to each objective.
Assume that a risk manager would like to purchase property insurance on a building. She is...
Assume that a risk manager would like to purchase property insurance on a building. She is analyzing two insurance coverage bids. The bids are from comparable insurance companies, and the coverage amounts are the same. The premiums and deductibles, however, differ. Insurer A’s coverage requires an annual premium of $70,000 with a $3000 per-claim deductible. Insurer B’s coverage requires an annual premium of $25,000 with a $9,000 per-claim deductible. The risk manager wonders whether the additional $55,000 in premiums is...
Assume that a risk manager would like to purchase property insurance on a building. She is...
Assume that a risk manager would like to purchase property insurance on a building. She is analyzing two insurance coverage bids. The bids are from comparable insurance companies, and the coverage amounts are the same. The premiums and deductibles, however, differ. Insurer A’s coverage requires an annual premium of $70,000 with a $3000 per-claim deductible. Insurer B’s coverage requires an annual premium of $25,000 with a $9,000 per-claim deductible. The risk manager wonders whether the additional $55,000 in premiums is...
The marketing manager of a large supermarket chain faced the business problem of determining the effect...
The marketing manager of a large supermarket chain faced the business problem of determining the effect on the sales of pet food of shelf space and whether the product was placed at the front ​(equals​1) or back ​(equals ​0) of the aisle. Data are collected from a random sample of 12​ equal-sized stores and are given below. Complete parts​ (a) through​ (g). For parts​ (a) through​ (d), do not include an interaction term. Store Shelf_Space_(Feet) Location Weekly_Sales_($) 1 5 Back...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT