7-2 report: interpret t-tests results

Overview

You are a business analyst for an organization that distributes pizza ingredients to various restaurants. These ingredients include dough, sauces, and toppings. Your organization wants to expand its customer base but does not know what kind of restaurant or which U.S. region to target. You have been given a Clean Customer Sales Data Set that is a representative sample of the sales at your customers’ restaurants for 2015 and 2016. This also contains household income data for the restaurant zip codes.

Your organization’s leadership is concerned about rising delivery costs and is considering whether they should specifically target pizzerias as customers. They are also considering whether they should only offer morning deliveries. Currently, the organization’s roster of customers includes a wide range of restaurants, many of which are open for business before noon. You have been asked to analyze your customer data set and provide insight and recommendations. First, you must determine differences in the orders placed at different times of the day and compare orders placed in pizzerias with those in other restaurants. You will then need to analyze these differences to determine whether these differences are due to chance or are statistically significant and determine how these may impact your recommendations.

For this activity, you will use MS Excel to perform t-tests on the given data set to determine whether the differences that you see between two groups are significant or due to chance.

Prompt

Create a report that presents the results of the t-tests on the data included in your data set to inform leadership’s decision making. Include the relevant screenshots in the report.

Specifically, you must address the following rubric criteria:

  • Perform T-Tests: Perform t-tests on identified binary (dichotomous) variables to determine differences between data groups.
    • Perform a t-test to investigate customers’ orders based on time of day. Group the orders according to those placed in the morning and those placed after noon.
      • Differentiate between the two groups of orders in terms of:
        • The average number of orders (or volume)
        • The average total amount
    • Perform a t-test by creating a new variable to group the restaurants based on whether or not they are categorized as “Pizza Place.”
      • Determine if there is a difference in the volume and the average order amount between restaurants categorized as Pizza Place and those that are not.
  • Interpret Statistical Results: Determine the statistical significance of your t-test results using the p values generated.
    • Determine whether there’s a statistically significant difference at the p < .05 level.
      • Differentiate between the volume of orders placed in the morning and in the afternoon.
    • Interpret the impact of limiting deliveries to only mornings and the impact on restaurants with significant pre-noon sales.
    • Recommend the time for deliveries if the level of significance was relaxed to p < .10.
    • Interpret the differences between pizzerias and other restaurants and how they influence your recommendation to leadership.
  • Summarize T-Test Results : Summarize the t-test results for a non-technical audience.
    • Explain why you performed a t-test instead of any other statistical test to answer leadership’s questions.
    • Explain your findings in terms of the p < .05 level and how confident you can be in any conclusions drawn from your analysis.

What to Submit

Submit an MS Excel sheet with the t-test results.

Submit a 2-page Word document using double spacing, 12-point Times New Roman font, and one-inch margins. Sources should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more