Jorge Jones, a recent management graduate has a new job as a shelf stocker at the...

Jorge Jones, a recent management graduate has a new job as a shelf stocker at the local Shop and Stop (bad job market). In order to maintain some of the knowledge he gained in college, Jorge wants to apply regression analysis to predict weekly sales on the cereal aisle.

He believes there would be a relationship between the shelf space that a particular product takes up and the sales of that product. Jorge has gathered the following data:

Shelf Space	Weekly Sales
5	160
16	230
7	220
15	270
6	140
17	280
10	190
21	260
11	240
25	350
14	260
22	310

a. Which is the independent/explanatory variable?

b. Which is the dependent/response variable?

Enter the data into an Excel spreadsheet.

c. Create a scatterplot for these data. How would you interpret the scatterplot?

Run a regression analysis using Data Analysis/Regression Tool and use the output to answer the following questions:

d. What is the value of the correlation coefficient? How would you interpret it?

e. What is the value of the coefficient of determination? How would you interpret it?

f. Write the hypotheses for the test of the slope.

g. What is the p-value for the test of the slope? How would you interpret the p-value?

h. What is the regression formula resulting from this analysis between Shelf Space and Weekly Sales?

i. Use the regression formula to estimate the Weekly Sales for a product that has a Shelf space of 23.

j. Use the regression formula to estimate the Weekly Sales for a product that has a Shelf space of 8.

Solutions

Expert Solution

orchestra answered 11 months ago

Next > < Previous

Related Solutions

A recent college graduate has taken a new job at Work LLC, and since the company...

A recent college graduate has taken a new job at Work LLC, and since the company does not offer a traditional pension plan, she plans to take advantage of a tax-free investment account backed by a reputable financial institution that offers a guaranteed 8% annual return for as long as she lives. The graduate plans on working for 45 years before retiring and will save a fixed amount each year until retirement, starting at the end of this year and...

A recent college graduate has taken a new job at Work LLC, and since the company...

A recent graduate moving to a new job collected a sample of the monthly rent (in...

A recent graduate moving to a new job collected a sample of the monthly rent (in dollars) and the size (in square feet) of 3-bedroom apartments in one area of a city. Use Excel to find the best fit linear regression equation, where size of the apartment is the explanatory variable. Round the slope and intercept to two decimal places. Size Rent 961 "909 " 949 1048 924 "841 " 920 "704 " 902 1131 893 "867 " 888 2532...

You're a recent graduate of Champlain College and landed a great job in New York as...

You're a recent graduate of Champlain College and landed a great job in New York as a junior financial analyst for Chuck Schwable, a leading investment firm whose name bears no resemblance to a well known investment firm. Schwable has recently been hired by Giggle, a leading IT corporation, to provide some capital budgeting recommendations for a major building project in downtown Manhattan. This is it...it's your big chance to make a great first impression and show off the skills...

Final Scenario You're a recent graduate of Champlain College and landed a great job in New...

Final Scenario You're a recent graduate of Champlain College and landed a great job in New York as a junior financial analyst for Chuck Schwable, a leading investment firm whose name bears no resemblance to a well known investment firm. Schwable has recently been hired by Giggle, a leading tech giant, to provide some capital budgeting recommendations for a major building project in downtown Manhattan. This is it...it's your big chance to make a great first impression and show off...

Your friend Nigel is a management graduate and therefore has little chance of finding a job...

Your friend Nigel is a management graduate and therefore has little chance of finding a job outside the fast-food industry. Luckily for him, Nigel's rich uncle has left him $20 million in his will. Having been a management student, Nigel partied while you studied. In fact, he took no courses in finance and thus knows nothing about investment. In a drunken stupor, late one Saturday night Nigel watched an interview with the Guru Jack ma. The Guru claims material wealth...

Use Worksheet 9.1. Lexi Thomas, a recent college graduate, has decided to accept a job offer...

Use Worksheet 9.1. Lexi Thomas, a recent college graduate, has decided to accept a job offer from a nonprofit organization. She’ll earn $44,000 a year but will receive no employee health benefits. Lexi estimates that her monthly living expenses will be about $2,000 a month, including rent, food, transportation, and clothing. She has no health problems and expects to remain in good health in the near future. Using the Internet or other resources, gather information about three health insurance policies...

Bridgette, a new audit associate, and recent graduate, has been assigned to a major insurance company...

Bridgette, a new audit associate, and recent graduate, has been assigned to a major insurance company for a two-week period to help the existing audit team complete the audit. Although the company is not her client, Bridgette is excited about the opportunity. Everyone on the engagement is professional and pleasant; however, the team is constrained to complete the audit in a short time period to meet the filing deadline. Being the newest staff member on the client, Bridgette is feeling...

A recent college graduate from Clayton State University has the choice of buying a new car...

A recent college graduate from Clayton State University has the choice of buying a new car for $33,500 or investing the money for four years with an 11% expected annual rate of return. He has an investment of $41,000 in equities and bonds which yields 8% expected annual rate of return. If the graduate decides to purchase the car, the best estimate of the opportunity cost of that decision is ________. Question 2 options: $3,280 $18,040 $14,740 $41,000

Angle, age 24 and single, is a recent college graduate. They have just accepted a job...

Angle, age 24 and single, is a recent college graduate. They have just accepted a job offer with Financial Planning Pals, LLC, as a financial planner making $100,000/ yr. Angle has some student debt and lives in an apartment without any roommates. They have $0 savings currently. Additionally, Financial Planning Pals, LLC is a cheap employer and they do not offer any type of Qualified Retirement Plan. Angle is confused about how to pay down their student loan debt, establishing...

Subjects