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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
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...
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...
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...
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...
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:...
A business statistics professor would like to develop a regression model to predict the final exam...
A business statistics professor would like to develop a regression model to predict the final exam scores for students based on their current GPAs, the number of hours they studied for the exam, the number of times they were absent during the semester, and their genders. The data for these variables are given in the accompanying table. Complete parts a through d below. Score   GPA   Hours   Absences   Gender 87   3.75   2.0   0   Female 77   3.20   4.5   3   Male 82   3.16  ...
The owner of a movie theater company would like to predict weekly gross revenue as a...
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.3 94 2.5 4.1 94 3 2.5 (a)Use α = 0.01 to test the hypotheses H0: β1 = β2 = 0 Ha: β1 and/or...
The owner of a movie theater company would like to predict weekly gross revenue as a...
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 90 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: β1...