For Katetutor only - Computer Assignment

*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”

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

Sample output for assignment 1 section 3

You have a different sample so your numbers will be different

Section 3: Summary of the data set

Add suitable comments

b) Use the filter to only include the people that like the product and find appropriate numerical summaries for the follow variable

iii) *Variable which version they prefer

iv) *Variable How much they would pay?

Bi)

So proportion of neither =5/5O=O.1 ,

proportion of version 1 = 2O/5O=O.4, proportion that like version3 = 25/5O=O.5

add a suitable comment

3bii)

Add a suitable comment

3c IFor 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

3) cii

3cii)

For the MALES the summary of the amount they would pay is

For the FEMALES the summary of the amount they would pay

Add appropriate comments.

Course description

Assessment 3 Assessment Type: Computer assignment – analysis and 1500 + 10% word report – individual assessment

Purpose: To allow students to demonstrate an understanding of statistical analysis and the ability summarise and manipulate sample data, make basic statistical inferences and interpret the results in a business context. This assessment contributes to Learning Outcome a, b, c and d.

Task Details: Students will be presented with a set of numerical data, and a business scenario. From this you will need to present, summarise and manipulate sample data, make basic statistical inferences and interpret the results. Report The analysis and conclusions you draw from the analysis needs to be presented in a short report including all relevant analysis either as part of the report or as attachments referred to in appropriate sections of the report.

Presentation: The report needs to be short report format - 1500 + 10% word report format – Word .doc or .docx Title page, executive summary, table of contents, appropriate headings and sub- headings, recommendations, in-text referencing and reference list (Harvard – Anglia style), attachments.

like male female 0.85 0.75 hate male female 0.15 0.25