Reference no: EM132415748

Assignment Instructions

The word count can be less than 1500 words ,

Dataset overview
Suppose cruise liner company XYZ has 2 cruise ships and it does market research on a food product and it obtains a data set with the following fields (variables)

"How much ingredient X?"
"How much would they pay?"
"Which ship?"
"Which country?" Note that is the country the passenger is from not where the ship is from.

Task overview

Instructions explaining how to discuss the dataset in a word file

Use the dataset summarizer and your dataset to answer the following

Investigate the relationship between the fields (variables) "How much ingredient X?" and "How much would they pay?" . Paste in appropriate sample statistics and a graph and add comments.

Investigate the relationship between the fields (variables) "Which ship?" and "How much would they pay?"
Paste in appropriate sample statistics and graphs and add comments.

Investigate the relationship between the fields (variables) "Which country?" and "How much would they pay?"
Paste in appropriate sample statistics and graphs and add comments.

Investigate the relationship between the fields (variables) "Which country?" and "which ship"
Paste in appropriate sample statistics and a graph and add comments.

Work out the zscore of the sample proportion of customers from country A, if the hypothesis p=0.9 is true

Work out the zscore of the sample proportion of customers from country A, if the hypothesis p=0.5 is true

Find a 95% confidence interval for the average of the variable "How much would they pay?" if the hypothesis they are on ship A is true.

Find a 95% confidence interval for the average of the variable "How much would they pay?" if the hypothesis they are on ship B is true.

Paste in the output for testing the claim there is a relationship between the variables "How much ingredient X?" and "How much would they pay?" and add suitable comments.

Paste in the output for testing the claim there is a relationship between the "Which ship?" and "Amount they would pay?" and add suitable comments.

Paste in the output for testing the claim there is a relationship between the "Which country?" and "Amount they would pay?" and add suitable comments.

Paste in the output for testing the claim there is a relationship between the "Which country?" and "which ship?" and add suitable comments.

Discuss at least two of the following topics it is OK if there is no connection between your discussions of the different topics.
Topic 1: demographics
Topic 2: snack food ingredients
Topic 3: cruise ships
Topic 4: Histograms

If you write a total of 600 words is OK it is also OK to use less words if you are making well considered points, If you use references cite the references and add a reference list at the end of the assignment, however you can work out some obvious points that are related to the dataset yourself without using references.

Answer one of the following questions

Question 1
Are your discussions in part (m) related to any of the previous parts? Explain why or why not.
300 words is OK it is also OK to use less words if you are making well considered points

Question 2
Discuss what you learnt about summarizing datasets when doing parts
a),b),c) and d) of the assignment ? Do your discussions in part m) give you an example of why you want to summarize datasets.

Comment on the format of the sample report. Given at the end of this document (pages 6 to 19)

Refer to following examples to what is required, the comment on format of the report is given at the start of each example.
300 words is OK it is also OK to use less words if you are making well considered points,

Example 1
Example 2

Note that this task means it OK just to answer the questions in this document, you do not have present your answers in report format.

Instructions for the Excel file

Paste your sample into and excel and before summarizing data submit this to moodle so KOI can check you have properly selected your sample

Use excel commands to make a graph that lets you investigate the relationship between the fields (variables) "How much ingredient X?" and "How much would they pay?".

Use excel PivotTable commands to find appropriate sample statistics that let you investigate e the relationship between the fields (variables) "Which ship?" and "Amount they would pay?"

Use excel PivotTable commands to find appropriate sample statistics that let you investigate the relationship between the fields (variables) "Which country?" and "Amount they would pay?"

Use excel PivotTable commands to find appropriate to find appropriate sample statistics that lets you investigate the relationship between the fields (variables) "Which country?" and "which ship"

Attachment:- Market research on a food product.rar