Explain how quartiles, percentiles and the correlation coefficient are used to draw useful conclusions in a business context

Follow the guidelines for “Pass” criteria. Do not use big words. SImple and straight to the point. I have attached the power point presentation as well because it will help to show you what is expected.

BUSINESS DECISION MAKING

Your assignment consists of two tasks for you to complete. Task 1 will include two parts. Part 1 is scenario based and asks you to prepare a professional report based on your market findings. In Part 2 of the Task 1, you will need to discuss various Management Information Systems (MIS).

Scenario: Grocery Ltd

In business, good decision making requires effective use of information. A Sales Director of Grocery Ltd, the recently established mass retail business in Dubai, seeks information on the grocery market in Dubai in order to make several important business decisions. He appointed you as his consultant to analyse relevant market data/ information and deliver a professional report based on your findings.

Grocery Ltd operate several grocery stores in Dubai; all stores were established four years ago. During the past two years the company’s turnover was growing at rates below the market average. The Sales Director is convinced that the major problem is inability of Grocery Ltd to build customer loyalty. The grocery stores offer a wide variety of food and non-food merchandise and are located in the mid-income residential neighborhoods where other competing stores also operate. Grocery Ltd do not currently run any discount or loyalty programmes. The Sales Director proposes the launch of private label foods (store brands) and home delivery shopping option.

(1) Your role as the consultant will involve investigation into current and possibly future consumer behavior and attitudes of grocery shoppers in Dubai. Based on your findings you will need to suggest the improvement opportunities to Grocery Ltd in order to boost their sales and retain customer loyalty.

(2) The Sales Director also asked you to evaluate the statistical relationship between the average monthly household income and monthly household grocery spending in Dubai market for the purposes of internal decision making.

In order to meet all the learning outcomes (L01-L03) you will be required to:

LO1: Be able to use a variety of sources for the collection of data, both primary and secondary

1.1 – Create a plan for the collection of primary and secondary data for a given business problem.

1.2 – Present the survey methodology and sampling frame used.

1.3 – Design a questionnaire for a given business problem.

LO2: Understand a range of techniques to analyse data effectively for a business

2.1 – Create information for decision making by summarising data using representative values

2.2 – Analyse the results to draw valid conclusions in a business context

2.3 – Analyse data using measures of dispersion to inform a given business scenario

2.4 – Explain how quartiles, percentiles and the correlation coefficient are used to draw useful conclusions in a business context

LO3: Be able to produce information in appropriate formats for decision making in an organisational context

3.1 – Produce graphs using spreadsheets and draw valid conclusions based on the information derived

3.2 – Create trend lines in spreadsheet graphs to assist in forecasting for specified business information

3.3 – Prepare a business presentation using suitable software and techniques to disseminate information effectively

3.4 – Produce a formal business report.

To achieve a Merit you need to:

M1 – You will need to demonstrate how the data collected can be analysed to form effective judgments about the research problem.

M2 – You will need to show evidence that a range of sources of primary and secondary data has been used to gather information for the purpose of research.

M3 – You will need to ensure that the appropriate structure and approach has been used in preparing the business report. Also, your report shall be submitted on time.

Guidelines for Task 1, Part 1

You will need to produce a detailed research plan of how you will collect the data, justifying the usage of primary and secondary sources. Primary data can be collected by administering questionnaires. Data from the Internet or other published sources can be used as examples of secondary data.

You will need to present the survey methodology used. Discuss in your report how the sample was selected from a population.

Produce a questionnaire for the investigation into the current and possibly future consumer behavior and attitudes of grocery shoppers in Dubai. The questionnaire may ask 10-15 questions; you can circulate your questionnaire within or outside of the University. You can also work on the design of the questionnaire together with a fellow student, if you wish.

You will need to classify, record and present your market findings appropriately.

Using market data collected, analyse it by the use of averages (mean, median, mode) and measures of dispersion (standard deviation, inter quarterly range).

You are required to estimate the statistical relationship between the average monthly household income and monthly household grocery spending in Dubai market using a linear regression model. For this, you can use the survey collected data. You will need to calculate and interpret the correlation coefficient and coefficient of determination, calculate the constants “a” and “b” for your linear regression model.

You will need to present your findings appropriately, using Excel spreadsheet graphs (line, pie, bar charts and histograms), tables, scatter XY graphs.

You will need to predict the monthly grocery spending for the monthly household income range outside of your collected source data.

You will need to produce a formal business report detailing your findings from the tasks above and suggesting the improvement opportunities to Grocery Ltd.

TASK 1, Part 2 – DISCUSSION PAPER (2-3 typed pages)


Last Completed Projects

# topic title discipline academic level pages delivered
6
Writer's choice
Business
University
2
1 hour 32 min
7
Wise Approach to
Philosophy
College
2
2 hours 19 min
8
1980's and 1990
History
College
3
2 hours 20 min
9
pick the best topic
Finance
School
2
2 hours 27 min
10
finance for leisure
Finance
University
12
2 hours 36 min