Calculate an estimate of mean spend for all blitz customers

Assignment Help Business Management
Reference no: EM131812902

Background

This is an individual assignment which requires you analyse a dataset, interpret the results and then report your findings to a person with little or no knowledge of statistical data analysis. The assignment uses the file "Ass2.xlsx" which is the same data set used for assignment one, and can be downloaded from the MIS171/MISP171 section in Moodle (in the Deakin College Portal).

This assignment requires you perform inferential techniques (based on Lectures and Tutorials in Weeks 8 and 9) on the Blitz dataset and then report on your findings.

There are two (2) parts to this assignment:

Part 1: Data Analysis (calculations to be performed by hand/typed up with formula and all workings to be shown. Answers should be checked using Excel)

Part 2: A reply to Jacinta Jones in the form of a memorandum addressing her questions and demonstrating how you have reached your conclusions.

Scenario

As for Assignment 1, you are playing the role of Alex Cassidy, Senior Analyst for Blitz department stores. Jacinta, the General Manager at Blitz has written to you again regarding the Blitz customer dataset. Her memorandum is reproduced on the next page.

For Attention: Alex Cassidy, Senior Analyst
From: Jacinta Jones, General Manager
Regarding: Analysis of the Blitz Store Data

Dear Alex,
Thank you for your earlier responses.

For me to finalise a report on Blitz customers required by senior management, I need the following information.
1. An estimate of:
a. the mean average amount spent per visit of ALL of our customers.
b. the true proportion of ALL shoppers who are using the internet to shop online at our Blitz stores.

2. The mean amount spent per shop at any shop (according to national data) is $100. We were wondering if there is evidence to indicate Blitz shoppers are spending less than this on average? Can you please check the validity of this claim?

3. Senior management also believes that the internet site is not performing as well as it should, and perhaps they need to invest more money on promoting it? If we can show that at least 25% of our shoppers are using the site, they would be content to leave it as is. Can you please check to see if there is sufficient evidence to indicate that the proportion of all shoppers using the site to shop is at least 25%?

4. Is there any evidence to indicate that there is a significant difference in the average amount spent by ALL male and ALL female customers?

5. I am concerned that a sample of 300 customers may not provide us with very accurate estimates. For future surveys, what sample size would be needed to be able to estimate:
a. the mean spends for ALL BLITZ customers to within $5, with 95% confidence?

b. the proportion of ALL BLITZ customers using the online website to shop within 3%, with 95% confidence?

ACTIVITIES

Part 1: ANALYSIS
You will need to apply techniques you have learned/will learn during lectures and tutorials in Weeks 8 and 9. You will also need to use the results of your assignment 1 analysis as the basis for your answers to assignment 2.

NOTE: For all confidence intervals and related calculations you can assume that a 95% confidence level is appropriate. For hypothesis tests a 5% level of significance (α = 0.05) is appropriate.

Part 2: RESPONSE TO JACINTA

This should be in the form of a report (as for Assignment 1).

GUIDELINES

The General Manager has asked for a number of tasks to be done. The following guidelines for each question should be followed:

1. ( a) A n es tim ate of the mean amount spent per shop for ALL Blitz customers.

You will need to calculate an estimate of the mean spend for ALL Blitz customers and be able to interpret your result as demonstrated in the relevant lecture and tutorial.
HINT: The Week 8 lecture and tutorial may be helpful.

1. ( b) The proportion of ALL Blitz customers who are using the online store to shop.

You will need to first determine the relevant sample proportion from your data then calculate the estimate of the proportion ALL Blitz customers who are using the online store to shop.
HINT: The Week 8 lecture and tutorial may be helpful.

2. The mean amount spent per shop at any shop (according to national data) is $100. We were wondering if there is evidence to indicate Blitz shoppers on average are spending less than this?
You will need to test to see if Blitz customers are the same as the national trend by using an appropriate technique and be able to interpret your result as demonstrated in the lecture and tutorial.
HINT: The Week 9 lecture and tutorial may be helpful.

3. Can you please check if there is evidence that the proportion of all Blitz shoppers using the site to shop is at least 25%?

Again, use an appropriate technique to test this claim and be able to interpret your result as demonstrated in the lecture and tutorial.4. Is there a significant difference in the average amount spent of ALL male and ALL female customers at Blitz department stores?
You will need to find out if there is a significant difference in the mean spend at the Blitz stores between ALL male and ALL female customers and be able to interpret your result as demonstrated in the relevant lecture and tutorial.
HINT: The Week 8 lecture and tutorial may be helpful.

5. Jacinta is concerned that a sample of 300 customers may not provide very accurate estimates. What sample size is required to ensure:

a. the mean spend for ALL BLITZ customers is true to within $5, with 95% confidence?

b. the proportion of ALL BLITZ customers using the online website to shop is accurate to within 3%, with 95% confidence?

Part 2: Report (that is, your reply to the Manager's letter)
Write a letter to the manager, explaining essential information and conclusions from your data analysis. You are allowed no more than two pages to convey your written findings.

- Keep the English simple and the explanations brief.
- Avoid the use of technical statistical terminology. Your reader will not necessarily understand even simple statistical terms, thus your task is to explain your analysis using plain, understandable language.

References APA

Reference no: EM131812902

Questions Cloud

What would the cutoff need to be in order to accomplish that : What would the cutoff need to be in order to accomplish that?
Standard normal random variable : Assume that z is a standard normal random variable. Provide the values for each of the following probability questions:
Follows a binomial distribution : Assume that the random variable x follows a binomial distribution with p = 0.32 and n = 6.
What should be the lowest acceptable transfer price : Division X makes a part that it sells to customers outside of the company. What should be the lowest acceptable transfer price from perspective of Division X
Calculate an estimate of mean spend for all blitz customers : MIS171 - Business Analytics - Write a letter to the manager, explaining essential information and conclusions from your data analysis. You are allowed no more
What is the probability that x = 2 : Suppose that the random variable X follows a binomial distribution with p = 0.70 and n = 8.
Mean or median to measure center : The "average" income of American households in 1998 was either $38,885 or $51,855, depending on whether we use the mean or median to measure center. We can say
What will be effect on the overall profit for diamond : Discontinuing furniture will reduce the utilities by $800. If the Furniture division is eliminated, what will be effect on the overall profit for Diamond
Choose a simple random sample : You must choose a simple random sample of 7 lots from a shipment of 80 lots of vaccine for testing.

Reviews

len1812902

1/13/2018 7:36:01 AM

5. Excellent Good OK Needs Work Poor Some of your output was OK. However, you have a number of mistakes. Generally poor analysis with either numerous errors or incorrect techniques used or missing results. Poor organisation of output. 12 0 Correct formulae used,calculations correct and answer statements correct. Most of the analysis was of a high standard. Perhaps some small mistakes. Some of the analysis was well done. However you have made a number of mistakes.

len1812902

1/13/2018 7:35:55 AM

4. Excellent Good OK Needs Work Poor 20 0 Both confidence intervals correct and graph correct.Correct conclusion reached Most of the analysis was of a high standard. Perhaps some small mistakes. Some of the analysis was well done. However there were either a few errors in your analysis OR you had missing analysis. Some of your output was OK. However, you may have used inappropriate techniques to analyse the data. Generally poor analysis with either numerous errors or incorrect techniques used or missing results. Poor organisation of output.

len1812902

1/13/2018 7:35:49 AM

3. Excellent Good OK Needs Work Poor 21 0 Hypothesis testing process correct and correct conclusion reached Most of the analysis was of a high standard. Some of your output may have contained small mistakes or could be improved. Results were well organised. Some of the analysis was well done. However there were either a few errors in your analysis OR you had missing analysis. Some of your output was OK. However, you have made a number of mistakes or have missing results. Organisation of output may need improvement. Generally poor analysis with either numerous errors or incorrect techniques used or missing results. Poor organisation of output.

len1812902

1/13/2018 7:35:43 AM

2. Excellent Good OK Needs Work Poor Hypothesis testing process correct and correct conclusion reached Most of the analysis was of a high standard. Some of your output may have contained small mistakes or could be improved. Results were well organised. Some of the analysis was well done. However there were either a few errors in your analysis OR you had missing analysis. Some of your output was OK. However, you have made a number of mistakes or have missing results. Organisation of output may need improvement. Generally poor analysis with either numerous errors or incorrect techniques used or missing results. Poor organisation of output. 0 21

len1812902

1/13/2018 7:35:37 AM

Available Allocated 1. Excellent Good OK Needs Work Poor Both answer statements correct and all calculations correct. Most of the analysis was of a high standard. Some of your output may have contained small mistakes or could be improved. Results were well organised. 16 0 Some of the analysis was well done. However there were either a few errors in your analysis OR you had missing analysis. Some of your output was OK. However, you have made a number of mistakes or have missing results. Organisation of output may need improvement. Generally poor analysis with either numerous errors or incorrect techniques used or missing results. Poor organisation of output.

len1812902

1/13/2018 7:35:17 AM

Your submission will comprise two (2) parts: • Part 1: Data Analysis (max. 8 pages) • Part 2 : Report (max. 2 pages). Both parts may be contained in a single file, but their content must be separated. That is, you will submit one pdf adobe acrobat file OR a word document file. Failure to separate Part 1 and Part 2 will be penalised. Furthermore, marks will be deducted for each part where the page limit is exceeded. The Assignment must be submitted both, i. electronically and ii. in print format by the due date. o 10% of available marks will be deducted if the assignment is only submitted in one format. Electronic submission: There will be a link in Moodle under the Resources and Assessment section labelled “Assignment 2 Online Submission”.

len1812902

1/13/2018 7:35:10 AM

• The report is to be written as a standalone document (that is, assume for the scenario that the manager will only read your report, and not look at your analysis output). • Avoid use of technical words and do not include formulas etc in your memorandum. • When writing your reply, make sure that you provide the information the manager requested in her letter to you. That is, answer the manager’s questions. • Number your answers in your report 1, 2 a, … etc., to match the sequence of the manager’s requests. Using a similar template for your response is a good starting point. • Include an introduction at the start of the report and a summary/conclusion at the end. • Marks will be deducted for the use of technical terms, poor grammar, awkward sentence structure, poor spelling and punctuation, irrelevant material, poor presentation/organisation and letters that are over two (2) pages long.

len1812902

1/13/2018 7:35:02 AM

For the electronic submission there will be a link in Moodle in the Resources and Assessment section. As for Assignment 1, the maximum number of pages for the analysis is 8 and for the report is 2 pages. GENERAL GUIDELINES: • Before doing any analysis, classify all your variables as either numerical or categorical. The techniques you will use depend on the type of data you have. • As mentioned above, the analysis section (Part 1) you submit should be no more than 8 pages of workings. This can be hand written so long as it is legible. • Your analysis should be presented in the same sequence as the manager’s questions, and everything should be clearly labelled and grouped around each question. • You can provide an excel check, but this should be in conjunction with the manual computations using appropriate formula.

len1812902

1/13/2018 7:34:19 AM

Please do check thoroughly through the document as there are "HINTS" that are provided by the lecturer, under the questions (Scroll to the bottom). I will be attaching the lectures that will be of help as well. 1. The solution should be plagiarism free and fulfil all the given requirements. 2. In case plagiarism found is more than 15%, we would have to deduct 50% of this order amount. 3. In case of technical order, share the screenshots also. 4. In case order is delivered after due date, penalty of 30% would be applied. 5. In case requirements seems incomplete, please login to your account and check message section..

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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