Quantitative Analysis #2 : 1 page memo

DeaconFoodCooperative.docx

Home >Mathematics homework help >Numerical analysis homework help >Quantitative Analysis #2 : 1 page memo

Deacon Food Cooperative[footnoteRef:1] [1: This assignment is to be done individually and in accordance with the Wake Forest University School of Business honor code. You may use any resources you like; however, you may not discuss any aspect of the assignment with anyone else. All work must be exclusively your own. The data may be based on fictitious products, companies, industries, people, and/or business conditions. Therefore, your analysis should be based only on the information provided, and NOT on specific personal knowledge you may have regarding actual products, companies, industries, people and/or business conditions.]

Deacon Food Cooperative (DFC) is a member-owned local business that conveniently provides fresh, natural grocery items of the highest quality and best value to its members.

Over the past few quarters, the board of directors for DFC has noticed a drop off in the average household amount spent on groceries each visit.

To better understand the current market, a direct mail survey was sent to the over 2,500 households within a 15 mile radius of DFC. The data from the respondents can be found in Deacon Food Cooperative.xlsx. Descriptions of the variables are provided below.

Variable Name	Description
Food Exp	Average household amount spent on groceries each visit at any brick and mortar grocery store, in US dollars
Shopping LH	Likelihood of shopping at DFC; measured using a seven point Likert scale: 1 = very unlikely, 7 = very likely
HH Size	Number of persons living in household
HH Inc	Household income received prior year, in $K
Highest Ed Head	Highest level of educational attainment for the head of household
Age Head	Age ranges of the head of household in years
Shopping Time	Average amount of time spent each week shopping for groceries in a brick and mortar grocery store, in minutes
Kid < 6	One or more children in household less than 6 years old
Kid 6-18	One or more children in household 6-18 years old
Eating Healthy	Response to question: “Eating healthy, nutritious food is important to me.” Measured using seven point Likert scale: 1= strongly disagree, 7 = strongly agree

DFC has approached you to analyze the data and provide guidance on what they should do to increase the average household amount spent on groceries each visit.

Analyze the data. Prepare a memo on what would you recommend.