Resources: Pastas R Us, Inc. Database & Microsoft Excel®, Wk 1: Descriptive Statistics Analysis Assignment
Purpose
This assignment is intended to help you learn how to apply statistical methods when analyzing operational
data, evaluating the performance of current marketing strategies, and recommending actionable business
decisions. This is an opportunity to build critical-thinking and problem-solving skills within the context of data
analysis and interpretation. Youâll gain a first-hand understanding of how data analytics supports decisionmaking and adds value to an organization.
Scenario:
Pastas R Us, Inc. is a fast-casual restaurant chain specializing in noodle-based dishes, soups, and salads.
Since its inception, the business development team has favored opening new restaurants in areas (within a 3-
mile radius) that satisfy the following demographic conditions:
Median age between 25 â 45 years old
Household median income above national average
At least 15% college educated adult population
Last year, the marketing department rolled out a Loyalty Card strategy to increase sales. Under this program,
customers present their Loyalty Card when paying for their orders and receive some free food after making 10
purchases.
The company has collected data from its 74 restaurants to track important variables such as average sales per
customer, year-on-year sales growth, sales per sq. ft., Loyalty Card usage as a percentage of sales, and
others. A key metric of financial performance in the restaurant industry is annual sales per sq. ft. For example,
if a 1200 sq. ft. restaurant recorded $2 million in sales last year, then it sold $1,667 per sq. ft.
Executive management wants to know whether the current expansion criteria can be improved. They want to
evaluate the effectiveness of the Loyalty Card marketing strategy and identify feasible, actionable opportunities
for improvement. As a member of the analytics department, youâve been assigned the responsibility of
conducting a thorough statistical analysis of the companyâs available database to answer executive
managementâs questions.
Report:
Write a clear statistical report that includes the following sections:
Section 1: Scope and descriptive statistics
Section 2: Analysis
Section 3: Recommendations and Implementation
Section 1 – Scope and descriptive statistics
State the reportâs objective.
Discuss the nature of the current database. What variables were analyzed?
Summarize your descriptive statistics findings from Excel. Use a table and insert appropriate graphs.
Section 2 – Analysis
Using Excel, create scatter plots and display the regression equations for the following pairs of variables:
âBachDeg%â versus âSales/SqFtâ
âMedIncomeâ versus âSales/SqFtâ
âMedAgeâ versus âSales/SqFtâ
âLoyaltyCard(%)â versus âSalesGrowth(%)â
In your report, include the scatter plots. For each scatter plot, designate the type of relationship observed
(increasing/positive, decreasing/negative, or no relationship) and determine what you can conclude from these
relationships.
Section 3: Recommendations and implementation
Based on your findings above, assess which expansion criteria seem to be more effective.Could any
expansion criterion be changed or eliminated? If so, which one and why?
Based on your findings above, does it appear as if the Loyalty Card is positively correlated with sales growth?
Would you recommend changing this marketing strategy?
Based on your previous findings, recommend marketing positioning that targets a specific demographic. (Hint:
Are younger people patronizing the restaurants more than older people?)
Indicate what information should be collected to track and evaluate the effectiveness of your recommendations.
How can this data be collected? (Hint: W ï· ould you use survey/samples or census?)
Sample Solution
The enticement of a casual lady spies me and a deceiver to my nation “Sexual orientation has driven me to socialism” Volume from individual to individual. In 1951, the most unhindered weapon for ladies heavily influenced by men 2, 2, SEX demonstrated one of the best and tricky gadgets of the Communist Party’s unmistakable advantages . What’s more, it meddles with extraordinary war presentation against the United States and every single not too bad individuals. Under the steady endeavors of Kremlin, the entire world will turn into a slave without faces, as their official tune “Universal” demands for “global Soviets to be human” Network benefactors effectively bolster the development pace of the VeChain people group and biological system in regions, for example, network commitment, network the executives, aptitude, and so on. They additionally speak to the interests of the network in stage the executives. You can utilize the gained VeThor to advance network exercises and further extend the extent of the VeChain biological system. The Foundation surveys all applications dependent on the definition models of every classification and step by step allots specialists’ mediators to candidates considered qualified by the Foundation after dispatch of the primary system. As the stage advances, the Foundation can distinguish members in different classifications. Network Foundation. These establishments gather assets from the nearby network and contribute and rejoin the network. They regularly deal with a few little families and corporate establishments and gather assets from the general. Since they for the most part have a lot of adaptability as far as financing, their endowments can frequently be utilized to improve offices in different manners. Activists of the network dissident network, notwithstanding acting naturally inhabitants, may at first assistance sort out the work and may think a lot about issues and related facilities.Although the meaning of socialism is exact and totally precise, it just shows the hypothesis of socialism, it doesn’t clarify how it works. It is difficult to make it work, so it doesn’t state that the hypothesis has never been settled. My folks lived there always, yet when I was conceived it vanished. In this way, a large portion of what I need to state depends on what my folks and grandparents informed me regarding the living of the Soviet Union. There are two essential kinds of network networks, networks characterized by geologically characterized networks and topographically various factors. Instances of geologically characterized networks are networks or neighborhoods. The accumulated houses share a typical space. Nearby economies and local organizations are additionally viewed as a major aspect of the neighboring network. Individuals from the network are invested individuals in network wellbeing, and I am keen on this The foundation of national security has been found in neighborhood networks. There are two sorts of networks. These are domains and affiliations. The previous alludes to a gathering of individuals living in explicit regions close to urban areas and towns and the last in reality is shared and advanced and supported normal interests despite the fact that they are scattered and away in a few urban areas and nations It alludes to a gathering of individuals to do. Instances of the last incorporate graduated class affiliations and professional gatherings. Since the start of progress, every single human gathering have consistently taken two structures. Network and Society The people group the world over need to make individual discussions out in the open spots without conversing with the entire society. It is a discussion, it makes network awareness, not different things. The likely vitality of messages in these discussions influences the entire society. Cypherpunks showed us this. The correspondence field I am generally inspired by is powerful correspondence. I imagine this is the most normally utilized field of correspondence in our general public. It is to persuade your educator to give your folks an extra ‘A’ point whether your folks are to cause you to accept that you have to go to Cancun to spend the spring excursion Regardless of whether. This specific correspondence field is the region that I am generally inspired by. I don’t have a clue what number of relational connections, life, influence, and wellbeing correspondence are utilized in our every day life. I found that each of these was especially fascinating to me. In the above site, you can promptly know insights concerning relationship, life cycle, enticing force, and sound correspondence. Political way of thinking dependent on network dynamic, social balance, and avoidance of the standards of financial and social rejection overshadow network objectives over individual objectives. As communists contend, social fairness, aggregate dynamic, pay conveyance dependent on pay, financial and political way of thinking of creation capital and free enterprise and full socialism backing the open ownership of regular assets Interim phase of social advancement between. This is a system contrasted with free-laundromat private enterprise where the state oversees all significant asset creation ventures and deals with most of the economy.>
The enticement of a casual lady spies me and a deceiver to my nation “Sexual orientation has driven me to socialism” Volume from individual to individual. In 1951, the most unhindered weapon for ladies heavily influenced by men 2, 2, SEX demonstrated one of the best and tricky gadgets of the Communist Party’s unmistakable advantages . What’s more, it meddles with extraordinary war presentation against the United States and every single not too bad individuals. Under the steady endeavors of Kremlin, the entire world will turn into a slave without faces, as their official tune “Universal” demands for “global Soviets to be human” Network benefactors effectively bolster the development pace of the VeChain people group and biological system in regions, for example, network commitment, network the executives, aptitude, and so on. They additionally speak to the interests of the network in stage the executives. You can utilize the gained VeThor to advance network exercises and further extend the extent of the VeChain biological system. The Foundation surveys all applications dependent on the definition models of every classification and step by step allots specialists’ mediators to candidates considered qualified by the Foundation after dispatch of the primary system. As the stage advances, the Foundation can distinguish members in different classifications. Network Foundation. These establishments gather assets from the nearby network and contribute and rejoin the network. They regularly deal with a few little families and corporate establishments and gather assets from the general. Since they for the most part have a lot of adaptability as far as financing, their endowments can frequently be utilized to improve offices in different manners. Activists of the network dissident network, notwithstanding acting naturally inhabitants, may at first assistance sort out the work and may think a lot about issues and related facilities.Although the meaning of socialism is exact and totally precise, it just shows the hypothesis of socialism, it doesn’t clarify how it works. It is difficult to make it work, so it doesn’t state that the hypothesis has never been settled. My folks lived there always, yet when I was conceived it vanished. In this way, a large portion of what I need to state depends on what my folks and grandparents informed me regarding the living of the Soviet Union. There are two essential kinds of network networks, networks characterized by geologically characterized networks and topographically various factors. Instances of geologically characterized networks are networks or neighborhoods. The accumulated houses share a typical space. Nearby economies and local organizations are additionally viewed as a major aspect of the neighboring network. Individuals from the network are invested individuals in network wellbeing, and I am keen on this The foundation of national security has been found in neighborhood networks. There are two sorts of networks. These are domains and affiliations. The previous alludes to a gathering of individuals living in explicit regions close to urban areas and towns and the last in reality is shared and advanced and supported normal interests despite the fact that they are scattered and away in a few urban areas and nations It alludes to a gathering of individuals to do. Instances of the last incorporate graduated class affiliations and professional gatherings. Since the start of progress, every single human gathering have consistently taken two structures. Network and Society The people group the world over need to make individual discussions out in the open spots without conversing with the entire society. It is a discussion, it makes network awareness, not different things. The likely vitality of messages in these discussions influences the entire society. Cypherpunks showed us this. The correspondence field I am generally inspired by is powerful correspondence. I imagine this is the most normally utilized field of correspondence in our general public. It is to persuade your educator to give your folks an extra ‘A’ point whether your folks are to cause you to accept that you have to go to Cancun to spend the spring excursion Regardless of whether. This specific correspondence field is the region that I am generally inspired by. I don’t have a clue what number of relational connections, life, influence, and wellbeing correspondence are utilized in our every day life. I found that each of these was especially fascinating to me. In the above site, you can promptly know insights concerning relationship, life cycle, enticing force, and sound correspondence. Political way of thinking dependent on network dynamic, social balance, and avoidance of the standards of financial and social rejection overshadow network objectives over individual objectives. As communists contend, social fairness, aggregate dynamic, pay conveyance dependent on pay, financial and political way of thinking of creation capital and free enterprise and full socialism backing the open ownership of regular assets Interim phase of social advancement between. This is a system contrasted with free-laundromat private enterprise where the state oversees all significant asset creation ventures and deals with most of the economy.>
