Reference no: EM131419288
Assignment
1. For this question you will use the Excel file posted on Blackboard titled "Homework 5 Data." The tab entitled "STORES" contains county-level data from the USDA Food Atlas. The tab "Variable List" is a data dictionary, which you will need to complete this assignment successfully. Throughout the data set and assignment, "grocery store" is taken to mean conventional supermarket.
A. Please calculate the mean, standard deviation, minimum, and maximum for every variable across all counties. Report these statistics in a table for PCH_GROC_07_12, PCH_SUPERC_07_12, PCH_CONV_07_12, and PCH_SPECS_07_12.
B. What is the primary advantage of measuring food retail store counts per thousand people, or per capita, rather than using the raw number?
C. Did the average county in the U.S. see an increase or decrease in the number of conventional supermarkets per capita? Explain your answer.
D. For each store type (GROC, SUPERC, CONV, and SPEC), report the number of counties that lost all stores of that type between 2007 and 2012. Do these numbers corroborate the statistical portrait of the U.S. food retail industry we discussed in class? Why or why not?
E. When you presented some of these numbers at a food retail conference in Hawaii, an executive from Walmart argued that you are actually understating the growth of supercenters with your statistics on PCH_SUPERC_07_12 (as well as the per capita measure). Is she right? Investigate this possibility using the raw supercenter store counts. If you agree with her assessment, why was the growth understated previously? (Hint-it has to do with measuring change in percentage terms.)
F. Calculate the correlation between GROCPTH12 and SUPERCPTH12. What does this say about the nature of competition between supermarkets and supercenters? Explain in a couple of sentences at most.
G. One big question about the food retail industry is how it interrelates with food assistance programs. SNAP and WIC are the country's two biggest and most important. Calculating correlations as you see fit, which of the store formats in the data seems most closely associated with the redemption of food assistance benefits? Which is the least?
H. Calculate and report the coefficient of variation (CV) for number of stores per thousand people, in 2012, separately for supermarkets, supercenters, and convenience stores. Which of these formats exhibits the most variability in terms of stores per capita across the country? Which exhibits the least? Does this make sense? Why or why not?
2. What are some changes in the food retail industry in recent decades that may have contributed to long-term decrease in the real, inflation adjusted prices for foods? Name two that are specific to retailers and how they have changed their characteristics and operating practices.
Attachment:- Data.rar
|
What is the annual amount that paul can spend
: What is the annual amount that Paul can spend while on his world tour if he will have no money left in the bank when he dies? Assume Paul has a remaining life of 25 years and earns 9 percent on his savings.
|
|
Discuss essential characteristics of an asset and liability
: You are required to select a product oriented company which to listed on the New Zealand Stock Exchange (NZX). Discuss the essential characteristics of an asset, liability, income and expenses by providing examples from your selected company's finan..
|
|
Why do lower economic classes idolize the wealthy
: Why do lower economic classes idolize the wealthy and what is causing the increasing divide between the economic classes?
|
|
Use in keeping track of organizational performance
: Designed originally for senior executives to use in keeping track of organizational performance, these graphics now show employees at all levels how they and the company are doing in meeting their goals.
|
|
Calculate the cv for number of stores per thousand people
: Calculate and report the coefficient of variation (CV) for number of stores per thousand people, in 2012, separately for supermarkets, supercenters, and convenience stores.
|
|
Explore ideas presented in exercise with additional work
: Explore the ideas presented in this exercise with additional work using the Simple Random Sample applet. Explain what you have done and summarize what you have learned in a short paragraph.
|
|
How do they shape a cultures view of the world
: Which world or worlds, such as sky, earth, and underworld, are represented in the myths you chose? What are the elements of these worlds?Describe the creators. Are the creators male or female, and of what significance is gender? Describe what the..
|
|
Gain market share and maintain its competitive advantage
: How does Amazon.com’s CRM software help it to gain market share and maintain its competitive advantage? How are operating efficiencies realized in order fulfillment activities of Amazon.com? Will costs continue to fall, given that their warehouses ar..
|
|
Summarize data for one variable.
: Write a summary that includes only the ones that you have encountered previously and that you believe are effective in describing the data.
|