Present the survey methodology and sampling frame

Assignment Help Basic Computer Science
Reference no: EM13935723

1. Present the survey methodology and sampling frame A2D Ltd will use for the research (AC 1.2)
- Describe various survey methods to collect Primary Data. Note you can use different methods to collect Data from different Sources.
- What Sampling methods would you like to use to collect Primary Data. Note, you can use different sampling methods for different study group.
- Define the Sampling frame and describe how sampling frame will be prepared for conducting a probability sampling for the proposed market research for A2D Ltd.
Sampling Frame is the list of all the collected Data
- Show how the secondary data will be collected.
Internet, library, magazines and television

2. Design an appropriate questionnaire using both open and closed ended questions A2D Ltd will use for data collection (AC 1.3)
- Prepare around 20 survey questions.
- The Questionnaire should include both open and closed ended questions.
- The closed questions should have a variety of questions styles - Likert Scale, Rating, Semantic differential, intention to buy and dichotomous questions etc.
- Include questions about respondent's profile, buying behaviour (How often they buy -Frequency), likeness, attitudes, sensitivity to price, quality, service, accessibility (Proximity, Postcode) references etc.

- Provide justification for the questions presented.
Use the following formulae to carry out the calculations

Mean

=Average(Data range)
Put the curser in the cells where you want to place the results of Mean.
Go to ‘Formulas'in the main menu, then select ‘More functions'for the menu that appears. Select ‘statistics'from the drop down menu that appears and look for ‘Average' and click. Enter the range of the required sets of data in the dialogue box that opens up and click OK. The result will be displayed in the cell chosen at the beginning.

Mode
=Mode(Data range)
Put the curser in the cells where you want to place the results of Mode.
Go to ‘Formulas'in the main menu, then select ‘More functions'for the menu that appears. Select ‘statistics'from the drop down menu that appears and look for ‘Mode' and click. Enter the range of required sets of data in the dialogue box that opens up and click OK. The result will be displayed in the cell chosen at the beginning.

Median
=Median(Data range)
Put the curser in the cells where you want to place the results of Median.
Go to ‘Formulas'in the main menu, then select ‘More functions'for the menu that appears. Select ‘statistics'from the drop down menu that appears and look for ‘Median' and click. Enter the range of required sets of data in the dialogue box that opens up and click OK. The result will be displayed in the cell chosen at the beginning.

Copy and paste the excel worksheet to your word document. (Your lecturer will let you practice this in class.)

3. Analyse data using representative values
You must analyse the results to draw useful and realistic conclusions and provide valid recommendations to support the board in decision making.

Briefly explain the mean mode and median as measures of location. Compare the mean median and mode and also comment on their merits and demerits.

Interpret the results of the mean median and mode calculated above.
-Compare the results with the last year's sales and advertising expenditure. Is advertising expenditure above or below the average?
-Are last year's sales above or below average? What are the implications for the business?
-Are their any extreme values in the data set?
Conclude which is the most ideal to analyse the data given for you?
-Explain the relation between mean and median data.

4.  Analyse data using measures of dispersion Calculate 1 ) range 2 ) interquartile range and 3 ) standard deviation Open an excel workbook and enter the sales and expenditure data and use the formulas ribbon to carry out the calculation.

Use the following formulae to carry out the calculations

First find the maximum and minimum values using the sort functions in excel.

Range
Type in the formula bar
=Cell containing Max value- cell containing Min value

Inter-quartile range
First find Q1 and Q3 using the following steps:
Put the curser in the cell where you want to place the results of Q1 and Q3.
Go to ‘Formulas'in the main menu, then select ‘More functions' for the menu that appears. Select ‘statistics'from the drop down menu that appears and look for quartile-Inc and click. Enter the range of data in the dialogue box that opens up and enter 1 or 3 for quartiles 1 or 3 respectively and click OK. The result will be displayed in the cell chosen at the beginning.

Standard deviation
=STDVA(Data range)
Put the curser in the cells where you want to place the results of Standard Deviation.
Go to ‘Formulas'in the main menu, then select ‘More functions'for the menu that appears. Select ‘statistics'from the drop down menu that appears and look for STDEVp and click. Enter the range of data in the dialogue box that opens up and click OK. The result will be displayed in the cell chosen at the beginning.

5. Quartiles percentiles and correlation coefficient

Quartiles
Describe briefly what are quartiles 1 , 2 and 3 and explain what information they provide for decision making. Relate it to the values of different quartiles you have calculated.

Percentiles
Describe briefly what percentiles and explain what information they provide for decision making. Relate it to the values of different quartiles you have calculated.

Correlation coefficient
-Calculate Correlation coefficient using the excel spread sheet. It follows the same process as for mean, median and standard deviation. -
Put the curser in the cells where you want to place the results of Correlation Coefficient.
Go to ‘Formulas'in the main menu, then select ‘More functions'for the menu that appears. Select ‘statistics'from the drop down menu that appears and look for ‘Correl' and click. Enter the range of both sets of data in the dialogue box that opens up and click OK. The result will be displayed in the cell chosen at the beginning.

-Interpret the result of correlation coefficient between advertising expenditure and food sales.
- Explain its implication to the business.
- Give recommendations to the business for the way forward.

Reference no: EM13935723

Questions Cloud

Contrast different organizational structures and culture : Compare and contrast different organizational structures and culture. Explain how the relationship between an organization's structure and culture can impact on the performance of a business.
Why would mncs desire to enter given countries : Why would MNCs desire to enter such countries? If these countries relaxed their restrictions, would their economies continue to be independent of other economies? Explain.
Compare mechanisms of pathogenicity developed by foodborne : Compare and contrast the mechanisms of pathogenicity developed by foodborne enteropathagenic E. coli, Salmonella and Shigella species that cause infections in the human host. Include : adherence, invasion, intracelluler locomotion.
What would your diversity training look like : Training is one of the ways you can address cultural issues; however, do you think it is necessary in this case? What would your diversity training look like? Provide details on the time, format, and topics covered
Present the survey methodology and sampling frame : Describe various survey methods to collect Primary Data. Note you can use different methods to collect Data from different Sources. What Sampling methods would you like to use to collect Primary Data. Note, you can use different sampling methods fo..
Define back-end and front-end applications. : Define procedures (subroutines) and functions and the difference between them.
Why hrm issue needs improving in the organisation : An analysis of the HRM issue. Describe the issue in detail. Explain why the issue needs improving in the organisation; make a case for change.
What are some risks of international business : What are some risks of international business that may not exist for local business? What does this chapter reveal about the relationship between an MNC's degree of international business and its risk?
Presentation that you will use to present training plans : Design a presentation that you will use to present your training plans to your supervisor and the HR department. Include a definition of diversity, a description of the cultural issues you intend to cover, strategies you will use to convey the messa..

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  What are your thoughts regarding monopolies

What are your thoughts regarding Monopolies? Do you think Microsoft still runs a Monopoly? Why should they be penalized for having "all the ideas

  Most important benefit of virtualization

Green computing is the study and practice of ecofriendly computing resources. Green computing is often seen where huge data centers apply server virtualization to reduce the number of servers that would otherwise have to be installed. Determine wh..

  Explore tables forms queries reports

1) Make sure that you review the introduction and Chapter1 from the text  book, you can download the practice files from microsoft.com/fwlink/? 2) Explore Tables, Forms, Queries, reports and printing objects.

  Design and test in logic works

Design and test in Logic works

  Write an if or else statement that compares the value

Write an if/else statement that compares the value of the variables soldYesterday and soldToday , and based upon that comparison assigns salesTrend the value -1 or 1 . -1 represents the case where soldYesterday is greater than soldToday

  How to call the function to update the statistics

A function which takes as in the parameters the three counters and displays them to the screen as shown in he example below.

  Database construction using mysql and php

Database Construction Using MySQL and PHP

  Show how they can detect what the other person has sent

Alice send (6) in hexadecimal and Bob sends (B) in hexadecimal - show how they can detect what the other person has sent.

  Explain how to satisfy storeitrite-s requirements

StoreItRite is interviewing candidates for position of Chief Information Officer (CIO). They are asking candidates to describe briefly how they would satisfy StoreItRite's requirements as stated above. How would a successful candidate respond?

  Create account ease of use age appropriateness

Go through and find2 NETS standardshttp://www.iste.org/standards/nets-for-studentsfor each of the above lesson plans you chose and explain why they would be met when using this Web 2.0 tool with the lesson plan you chose.

  It-corporate transformation

List and explain all the business opportunities or the business values that are created by the network economy.  How do human capital, structural capital, and customer capital differ? Please analyse each and provide supporting facts.

  Important considerations in the design of performance

What are some of the important considerations in the design of performance benchmarks for mobile devices? Why?

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