Question
A regional manager at a supermarket chain would like to develop a model to predict weekly...
A regional manager at a supermarket chain would like to develop a model to predict weekly sales of pet food based on the shelf space. The following table shows the results of data collected from nine randomly selected stores. Complete parts a through c below.
Shelf_Space_(Feet) Sales_($100)
2 7
2 7
2 2
5 5
5 17
2 5
4 4
5 3
6 15
a. Calculate the sample covariance.
b. Calculate the sample correlation coefficient.
c. Describe the relationship between x and y.
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
Please show work and explain. Thank you. 1. The marketing manager of a large supermarket chain...
Please show work and explain. Thank you.
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...
4. A large supermarket chain would like to determine the effect of the size of shelf...
4. A large supermarket chain would like to determine the effect
of the size of shelf space (in square feet) on the weekly sales (in
thousands) of a promotional item using a simple random sample of 28
stores. Partial output from Excel is attached. a) Use one sentence
to describe the relationship between shelf space and weekly
sales.
The marketing manager of a large supermarket chain would like to determine the effect of shelf...
The marketing manager of a large supermarket chain would like to
determine the effect of shelf space (in feet) on the weekly sales
of international food (in hundreds of dollars). A random sample of
12 equal –sized stores is selected, with the following results:
Store Shelf Space(X) Weekly Sales(Y) 1 10 2.0 2 10 2.6 3 10 1.8 4
15 2.3 5 15 2.8 6 15 3.0 7 20 2.7 8 20 3.1 9 20 3.2 10 25 3.0 11...
Case: A small convenience store chain is interested in modeling the weekly sales of a store,...
Case: A small convenience store chain is
interested in modeling the weekly sales of a store, y, as a
function of the weekly traffic flow on the street where the store
is located. The table below contains data collected from 24 stores
in the chain.
Store
Weekly Traffic Flow (thousands of cars)
Weekly Sales ($ thousands)
1
59.3
6.3
2
60.3
6.6
3
82.1
7.6
4
32.3
3.0
5
98
9.5
6
54.1
5.9
7
54.4
6.1
8
51.3
5.0...
1. The owner of a movie theater company would like to predict weekly gross revenue as...
1. The owner of a movie theater company would like to predict
weekly gross revenue as a function of advertising expenditures.
Historical data for a sample of eight weeks follow.
Weekly
Gross
Revenue
($1,000s)
Television
Advertising
($1,000s)
Newspaper
Advertising
($1,000s)
96
5
1.5
91
2
2
95
4
1.5
93
2.5
2.5
95
3
3.3
94
3.5
2.2
94
2.5
4.1
94
3
2.5
(a) Use α = 0.01 to test the hypotheses
H0:
β1 = β2 = 0
Ha:...
3.An accountant for a large department store would like to develop a model to predict the...
3.An accountant for a large department store would like to
develop a model to predict the amount of time it takes to process
invoices. Data are collected from the 30 working days and the
number of invoices processed and completion time (in hours) are
used to obtain the following PHStat output. 1. The value of the
t-test statistic to test whether time is linearly
dependent on the number of invoices to be processed is? 2. The
value of the coefficient...
3. A sales manager collected the following data on annual sales and years of experience. Salesperson...
3. A sales manager collected the following data on
annual sales and years of experience.
Salesperson Years of Experience Annual Sales ($000s)
1 1 132
2 3 160
3 4 145
4 5 168
5 6 168
6 8 180
7 10 188
8 11 218
9 11 193
10 13 229
a. Develop a scatter diagram for these data with years of
experience as the independent variable.
b. Develop an estimated regression equation that can be used to
predict...
The manager of a supermarket would like the variance of the waiting times of the customers...
The manager of a supermarket would like the variance of the
waiting times of the customers not to exceed 3.7 minutes-squared.
She would add a new cash register if the variance exceeds this
threshold. She regularly checks the waiting times of the customers
to ensure that the variance does not rise above the allowed level.
In a recent random sample of 35 customer waiting times, she
computes the sample variance as 5.8 minutes-squared. She believes
that the waiting times are...
The manager of a supermarket would like the variance of the waiting times of the customers...
The manager of a supermarket would like the variance of the
waiting times of the customers not to exceed 3 minutes-squared. She
would add a new cash register if the variance exceeds this
threshold. She regularly checks the waiting times of the customers
to ensure that the variance does not rise above the allowed level.
In a recent random sample of 28 customer waiting times, she
computes the sample variance as 4.2 minutes-squared. She believes
that the waiting times are...
A US consumer lobby wishes to develop a model to predict gasoline usage, as measured by...
A US consumer lobby wishes to develop a model to predict
gasoline usage, as measured by miles per gallon, based on the
weight of the car in pounds. The Excel data file AUTO.xls
(contained in a folder under the CML Quizzes tab) contains data on
this for fifty recent models. Use Excel Data Analysis to estimate a
linear model for the relationship, a 95% confidence interval for
the slope coefficient and the residual plot. State all numeric
answers below correct...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 1 minute ago
asked 16 minutes ago
asked 18 minutes ago
asked 21 minutes ago
asked 24 minutes ago
asked 24 minutes ago
asked 52 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago