Which zip codes appear to more or less likely to profitable

Assignment Help Business Management

Reference no: EM133801415

Homework: Trends and Patterns

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.

You must analyze this data to help inform marketing decisions. To begin your analysis, you must be able to answer your stakeholders' questions through your analysis and visualizations of the given data. You will use MS Excel to complete these tasks.

In Module One, you identified some stakeholder requirements and performed data wrangling to clean, transform, and merge the two data sets. In this homework, you will use the cleaned customer sales data to begin your analysis by performing statistical tests to further identify the trends and patterns in the given data. These tests will produce accurate results that will help organizations forecast and plan better and test theories and strategies.

Prompt

Analyze the given data and create a report summarizing the trends and patterns in the data set. You may refer to the Trends and Patterns Report Process Document for this activity. You must include the relevant screenshots in your report.

Specifically, you must address the following criteria:

A. Statistical Techniques and Tests: Conduct exploratory data analysis, generate histograms, perform requisite diagnostics, and apply statistical tests.

a. Generate frequency tables and histograms for the variables (column attributes).
b. Calculate the chi-square statistic (x2).
c. Determine the correlations between the variables.
d. Perform t-tests.

B. Trends and Patterns: Select and apply appropriate statistical tests to answer the following questions about the trends and patterns in the data:

a. Which categories of restaurants represent the largest and smallest share of the overall total? Are they concentrated in any U.S. state?
b. Does the data indicate a particular day of the week or month of the year that sees more (or fewer) orders?
c. Which zip codes appear to be more or less likely to be profitable?

C. Rationale: Justify your choice of statistical tests for each of the above analyses.

a. How are the different statistical techniques appropriate for the different types of data contained in this data set?

Reference no: EM133801415

Questions Cloud

Organisation as machine and employees as components : Classical organisational theory is an approach that views an organisation as a machine and employees as its components.

Design the analogue butterworth filter prototype : ENG3049-N Digital Control and Instrumentation, Teesside University - Design the analogue Butterworth filter prototype for the high-pass filter and convert

Who originally came up with the term gilded age : Explain why the period between 1870 and 1900 is known as the Gilded Age. Who originally came up with the term, Gilded Age?

Endangering the welfare of child charge : Consider a defense argument against an endangering the welfare of a child charge in a case where police seized a dog based upon the living conditions

Which zip codes appear to more or less likely to profitable : Does the data indicate particular day of the week or month of the year that sees more orders? Which zip codes appear to be more or less likely to be profitable?

Create a report that presents the data using visualization : QSO 560- Create a report that presents the data using visualization techniques best suited for the types of data included in your data set.

Describe the options in sentencing process : Describe the options in the sentencing process. Describe how a judge determines an appropriate sentence.

What financial figure do you believe was the determinant : What financial figure do you believe was determinant to your decision and why? How you be able to apply this particular financial information to other situation

What are provisions the attorney must prove : What are the provisions the attorney must prove? Please discuss the strengths/weaknesses of the above facts as they relate to the Violation requirements?

User Account

All Pages