What are worst selling product categories in terms of profit

Assignment Help Advanced Statistics
Reference no: EM131993814 , Length: word count:2000

Research Report

You are creating a business report for the CEO of NIKE. It must be professional in presentation and contain insightful content for them to make business decisions.

Both data sets are fromalarge global corporation. The businessis divided into a number of areasincludingMen's, Women's, Boys, Girls, and Customisation.The product range includes shoes, clothing, accessories and equipment. The customisation section allows customers to customise depending on use, such as lifestyle, running, gym & training, football, basketball and skateboarding. There are also options to customise the children's line (see the website for more information).

You have been given two data sets and the data is inclusive ofawholeyearof trading.

1. The first dataset labelled "NIKE customer attributes" lists the results of an online survey given to customers.
a. The variables include:
i. "User_Group" which shows how often individuals used the website, where "light user" is defined as less than once a fortnight/month, "Medium user" is once a fortnight, "Heavy user" is more than once a week.
ii. "Gender" - male or female
iii. The dataset also lists the customer attitudes which is five variables consisting of:"awareness", "satisfaction", "preference", "purchase intentions" and "loyalty" to NIKE, these items were measured on a 7-point Likert scale. See values column for exact wording.

2. The second dataset lists the website sales.
a. The variables include:
b. Day and month
c. Whether the total purchases were paid with Paypal or Credit card
d. The product category, Costs of Goods (COGS margins), and profit total.

The mainchallenges in the businessareprofit, Cost of Goods (COGSmargins) andincreasing sales.

Task instructions:

Using what you have learned in the lectures and the tutorials answer the main research questions below. Then consider the dataset and answer any other research questions you can identify that are meaningful to the CEO.

As guide - answer these main research questions:

1. What are the top/worst selling product categories in terms of profit?

2. Is there a difference in payments methods?

3. Are there any differences in the user groups on all of the customer attitudes? (5 outcomes)

4. Are there any differences in gender on all of the customer attitudes? (5 outcomes)

There are other research questions you should consider and report on. Do not worry if you are using a lot of the same analysis to report on the research questions. There are right and wrong answers when it comes to statistical analysis. You must know and demonstrate your knowledge of this.

Report structure:

• Cover page/Title Page - Name, student number, tutor information, word count
• Table of contents(could also include a list of figures / diagrams / tables)
• Introduction (2 marks) - Introduce the business and its problems.
o Describe the company, what does it do, what is the company profile, the community impact and sustainable innovation(Use the company website, make sure you paraphrase and reference the website appropriately. Also use a web search to answer these questions, for example Google Nike "culture").
• Problem definition and business intelligence required (3 marks):
o List each of the research questions and list what analytics methods you have chosen to answer each question and why
- For example, if you used an ANOVA -list the research question, explain why an ANOVA was most appropriate by defining what an ANOVA is and does (use references to statistical textbooks and websites)
• Results of the selected analytics methods and technical analysis (25 marks):
o Use each research question as a heading
o Presentthe relevant descriptive statistics through data visualization/ graphical displays (Tables, graphs, pie charts etc.).
o Present the main analysis findings and explain them.
o Higher marks for including extra research questions not defined in this document and creating nice tables/displays opposed to copy and pasting directly from SPSS output.
• Discussion of the results and recommendations (5 marks):
o Based on the analyses what conclusions about the business can be summarized/drawn and what recommendations can be offered to the CEO.
• References - list of references in either Harvard or APA formatting (you must reference the business website - include other references in your answers)

Report formatting:

Font size 12 Times New roman, double spacing, word count 1,500-2,000. Note. The word count does not include headings, tables, graphs/figures or the reference list.

Attachment:- Guideline and data.rar

Reference no: EM131993814

Questions Cloud

Describe the photoelectric effect : Can someone please describe the photoelectric effect? How did Einstein's explanation of the photoelectric effect further quantum theory?
Is the retraining program an economical investment : The current annual interest rate is 10% on funds of this type. Is the retraining program an economical investment for the state, on a present-worth basis?
What is the volume rate of flow : When water flows through this pipe at a certain rate, the gauge pressure in these two sections is 35.0 kPa and 24.0 kPa, respectively.
Explain the most effective way to improve communication : Explain the most effective way(s) to improve communication between cultures, specifically through interpersonal communication
What are worst selling product categories in terms of profit : BUS501-Business Analytics and Statistics - University of Sunshine Coast - What are the top/worst selling product categories in terms of profit
How do the returns and variance compare with the s-p 500 : Using the end date 12/31/15 and the three stocks in your portfolio, calculate the annualized return for the last 10 years, 5 years, and 1 year.
How fast does air flow in the duct : A 13 cm radius air duct is used to replenish the air of a room 9.4 m ?4.5 m ?5.0 m every 10 min. How fast does air flow in the duct?
Skin and structure of the balloon : How large a cargo can it lift, assuming that the skin and structure of the balloon have a mass of 900 kg? Neglect the bouyant force on the cargo volume itself.
What is the expected return of stock p : What is the standard deviation of a portfolio 60 percent invested in Stock P and the remainder in Stock Q?

Reviews

len1993814

5/23/2018 7:24:05 AM

Criteria 5: Report formatting (5 marks) The meaning is consistently clear. Use of discipline terminology is confident and assured. The level of presentation meets professional standards of the discipline, and there is a high level of attention to detail regarding the results tables and graphics (not just cut and paste from SPSS output. Little/no errors in grammar, syntax and spelling. Referencing and citations are appropriate and integrated. The meaning is clear. Use of discipline terminology is extensive and largely correct. The level of presentation meets professional standards of the discipline, and there is attention to detail. SPSS output has not been copied and pasted into the results. The grammar, syntax and spelling are near perfect. Referencing and citations are appropriate. Overall meaning is clear though there are minor instances of awkward/ambiguous expression. Use of discipline terminology is adequate. The level of presentation mostly meets professional standards of the discipline, with some lapses in detail in e.g. SPSS output not used, grammar, syntax and spelling good. Referencing and/or citation errors.

len1993814

5/23/2018 7:23:50 AM

Criteria 4: Discussion of the results and recommendations (5 marks) The recommendations are highly appropriate, integrated with the results, and supported by results/literature. The entire report is presented as a consistent whole. The recommendations are appropriate, integrated with the results, and supported. The recommendations are fairly appropriate and fairly supported. With some instances missing. The recommendations are appropriate, however lacking some instances and needing more. Or inappropriate suggestions are made. The recommendations are lacking and are not supported. Inappropriate suggestions are made or there are no suggestions at all.

len1993814

5/23/2018 7:23:40 AM

Basic knowledge of the use of business analytic tools to answer the report questions. The selected methods are first presented with the use of descriptive statistics and data visualisation, several elements missing. Use of statistical terminology fairly correct. The level of interpretation of the statistics meets standards but some errors in interpretation or presentation. Little or no knowledge of the use of business analytic tools to answer the report questions. Use of statistical terminology inconsistent and not correct. The level of interpretation of the statistics fails in terms of presentation and interpretation.

len1993814

5/23/2018 7:23:34 AM

Demonstrates mostly comprehensive and insightful knowledge of the use of business analytic tools to answer the report questions and others identified in the data set. The selected methods are first presented with the use of descriptive statistics and data visualisation. Use of statistical terminology is extensive and largely correct. The level of interpretation of the statistics mostly meets professional standards of the discipline with little errors in interpretation and/or presentation. Demonstrates some knowledge of the use of business analytic tools to answer the report questions. Use of statistical terminology mostly correct. The selected methods are first presented with the use of descriptive statistics and data visualisation, some elements missing. The level of interpretation of the statistics meets standards but some errors in interpretation or presentation.

len1993814

5/23/2018 7:23:29 AM

Criteria 3: Results of the selected analytics methods and technical analysis (25 marks) Demonstrates comprehensive and insightful knowledge of the use of business analytic tools to answer the report questions and others identified by the student in the data set. The selected methods are first presented with the use of descriptive statistics and data visualisation. Then the main analysis is presented. Use of statistical terminology is extensive and correct. The level of interpretation of the statistics meets professional standards of the discipline with no errors in interpretation and/or presentation.

len1993814

5/23/2018 7:23:06 AM

Criteria 2: Problem definition and business intelligence required (3 marks) 85 to 100 % Each problem and the business intelligence/statistics required are described and explained with references where appropriate to literature. 75 to 84 % Each problem and the business intelligence/statistics required are mostly explained with some references where appropriate to literature. 65 to 74 % Demonstrates some knowledge of the problems and the business intelligence/statistics required. With minimal references to literature. 50 to 64 % Basic knowledge of the business questions and the statistics used are outlined with some explanation as to why these were used. 0 to 49 % Little information concerning the report questions and the statistics used to answer them. The analyses are outlined but no explanations given.

len1993814

5/23/2018 7:23:00 AM

Levels of Achievement Criteria High Distinction Distinction Credit Pass Fail Criteria 1: Introduction (2 marks) 85 to 100 % Demonstrates comprehensive and insightful knowledge of the business with an in-depth introduction to the business and the problems. The introduction covers who the company is, what it does, what the profile is, the community impact and the sustainable innovation. The website and other internet sources are well referenced. 75 to 84 % Demonstrates mostly comprehensive and insightful knowledge of the business. Most elements of the business are covered such as, what the business does, what the company profile is, the community impact and sustainable innovation. The website is well referenced. 65 to 74 % Demonstrates some knowledge of the business with the problems mostly outlined. Some elements of what the company profile is, the community impact and sustainable innovation are missing. Some reference to the website. 50 to 64 % Basic knowledge of the business demonstrated with the assignment information given but no extra information included. The company website is minimally referenced.

Write a Review

Advanced Statistics Questions & Answers

  Find a right eigenvector for each distinct eigenvalue

Find a right eigenvector for each distinct eigenvalue, and show that the eigenvalue of multiplicity 2 does not have two linearly independent eigenvectors.

  Importance of math in analyzing business

What is an independent variable? What is a dependent? What is the relationship between independent and dependent variables? What is the purpose of differentiating these terms?

  Construct a leading economic indicator

The index of leading economic indicators, compiled and published by the U.S. National Bureau of Economic Research, is composed of 12 time series, such as the average work hours of production in manufacturing, manufacturers

  What is the null and the alternative hypotheses

What is the Null and the Alternative Hypotheses - what is your level of alpha and what is your conclusion - Has there been a significant reduction in the national unemployment rate between January and June

  Construct the equation of the regression line

Construct the equation of the regression line and interpret the coefficients and using the output of the regression above, determine the slope and the intercept.

  Range and mean not good predictor of variability

Four sets are listed in the table below. Each set represents a sample. Find the range, mean, and standard deviation for each set. Use your results to fill in the table.

  Draw a graph of state transitions and find steady-state pmf

Draw a graph of the state transitions for i ≤ 2, j ≤ 2. Find the steady-state PMF, {p(i, j); i, j ≥ 0}, for the Markov process.

  Develop a forecasting model

Develop a forecasting model justifying its selection over other techniques, and project the expected number of cases to be ordered in 2014. Provide a summary of the cell phone industry outlook using Internet resources as part of Paul’s response.

  Determine the area of the shaded region

Evaluate the area of the shaded region (z=0.99). The graph depicts the standard normal distribution of bone density scores with mean 0 and standard deviation 1.

  Id numbers of the sample size of 301 4400316 410792 4330317

id numbers of the sample size of 301. 4400316. 410792. 4330317. 102263. 3597418. 405184. 1189319. 326095. 1003020.

  Statistical programming for data science

COMP 5070 - Write a short explanation of the analysis to be performed and an explanation of the question(s) you are investigating within the data

  Explain process for finding the p-value and critical value

Write the null and alternative hypothesis symbolically and identify which hypothesis is the claim - is the test two-tailed, left-tailed, or right-tailed?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd