Reference no: EM131201672

Instructions for the task

*It is a report with many sections , all of the answers to all of the sections need to go into a single word document.

*students should do section 3 first, If they understand it is basic market research they should have a rough idea of what is going on, sample output is given on pages 4,5 and 6 the end of this document

Overview :Each student will be given a sample from a large population and each student will analyse their own sample.

The data and a short description of the data is given in a separate excel file .

NOTE: - Please refer to my attachment "Assignment data set with pivot table". Use this data to manipulate sample.

Section 0: Cover sheet

You do need a cover sheet with the following

Student number, (this is very important it lets the marker check you have used numbers based on your student

Name
Subject: bus105 business statistics
Assignment: Computing Assignment

Section 1: Introduction

Give an introduction to the assignment by giving a similar examples of a sample and a population and explain how it is useful in business.
NOTE: - Please refer to the attached file "Ëxamples that explain the introduction to the assignment"

OR you can look at https://www.youtube.com/watch?v=QQCpZ_J8EmY

Section 2: Description of the data set

Describe the dataset and describe each of the variables,

For each variable answer the question is it categorical or numerical?

The dataset is based on survey questions so propose 2 other survey questions

Section 3: Summary of the data set

a) For the variable how much they would pay?below give graphical and numerical summaries that describes the variable (in other words give the appropriate univariate statistics and graphical displays)

Also provide give appropriate comments

b) Use the filter to exclude the people that do not like the product and find appropriate numerical summaries for the follow variable

i) *Variable which version they prefer
ii) *Variable How much they would pay?

Also provide suitable comments

c) For each pair of variables below give appropriate graphical and numerical summaries that describes the variable

(in other words give the appropriate bivariate statistics and graphical displays)

i) The variables: Gender and do they like the product?
ii) The variables How much they would pay?and gender

Section 4: Confidence intervals

Note: you will have to use the information in section 3b to answer these questions.

Excluding people that do not like the product

i)Find a 90% confidence interval for the proportion of people that prefer version 1
ii)Find a 90% confidence interval for the average amount they would pay

Section 5: Hypothesis tests

Note: use the information from question 3c to answer these questions

Perform the appropriate Hypothesis test,

i) *The variables: Gender and do they like the product
ii) *The variables How much they would pay? and gender

Section 6 : the problems of getting survey data in the real world

The data set in the assignment is not real world data because every student needs their own sample to prevent copying,Discuss the problems of getting survey data in the real world , Also give an example of an actual product and give appropriate survey questions.

Section 7: conclusion

Discuss what you learnt after thinking about the previous sections. Make sure you give a discussion of the results from section 4 and 5.

https://www.dropbox.com/s/70vpz14qf0455kw/Assignment_Data_Set_With_Pivot_Tables.rar?dl=0