+1(323)689-1506 support@essayhubmarket.com

Looking for help with an assignment? Connect with an assignment Expert Now!

Data Analysis And Business Analytics

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 750-word 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: Would you use survey/samples or census?)

Get a Quick Quote

Approximately 250 words
Total price (USD) $: 10.99

Reviews from Clients who Ordered From Us:

Kate Hogan

They are my go to assignment helper and have been a great help. Thank you!

Sheena easton

I`ve been working with this website for over a year! Here`s what I liked the most about them. First, quality of writing (creative and with catchy titles).

Our Benefits

Get your essay writing needs completed by us and enjoy these and more benefits:

Fast

Whether you have a last minute discussion post due in a couple of hours or the last day in class and you totally forgot to work on that research paper, we always put everything aside to save your grade

Custom Essay

Our qualified team of experts have access to varied online library databases to help with recent and well researched tools that help in writing your paper to deliver a profound research that earns you a stellar grade

80+ Subjects

We do not turn down any type of work. We have qualified writers holding bachelors, graduate and Doctoral certificates matched with skill and expertise. Get help with homework acroos varied subject

Real Time Tracking

We have a user friendly interface to help you track the progress on your order from your client portal. Additionally, with each and every step, you will get notified on the status of your paper to give you an easy time to do other kinds of stuff

Order Our Custom Essay Writing Service

1. Making an Order Tip and Tricks

  • Choose the type of assignment, topic, subject, length, and deadline for your paper.
  • Indicate the following order parameters: service, chosen writer level, number of cited sources, and citation style.
  • Add your document or provide instructions for paper in a specific form.
Image showing step 1 of making an order
Image showing how to make payment for your order

2. Tips and Tricks for Choosing the Right Writer

  • Log in using your email address or your Facebook account.
  • A list of suitable writers will be offered to you. Before making a selection, you can read testimonials or engage in a Live Chat with authors.
  • Check your balance and, if necessary, add funds to your account. Here you will also find exclusive bargains.
  • Put money into the account of the chosen writer.

3. Tips and Tricks for Supervising the Writing Process

  • Get the chance to keep track of the process and connect with your writer.
  • If required, include updated instructions.
  • Have a conversation with your author.
Image showing how to supervise writing process
Image showing how to download your completed results

4. Tips and Tricks to Enjoy the Results

  • You will receive the paper. You have the option of requesting modifications if they are required. Before giving it back to the writer, make a list of the adjustments that need to be made.
  • Accept the paper and send the money to the author.
  • Rate your writer, submit your request, then sit back and enjoy the results.

How can we even make your school life easier with our services?

We always strive to provide the best techniques and skills that help your essay a stellar paper. We have achieved this through the years by offering features such as:

Progressive Delivery

Your order is assigned to a writer who delivere’s your bulk research projects in small chunks and making edits upon feedback from the professor

Native Writers

Our writers are varied across different coutnries such s Canada, Australia, U.K and the United States. Request a native speaker writer to help you ace that paper

Powerpoint slides & other visuals

Order a visual such as Powerpoint to better expound your research paper at $10 per slide including speaker notes

Top rated writers

Order from among the top 10 rated writers at no extra cost