Reference no: EM132372209 , Length: word count : 1500
Assignment instructions
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.
You need to obtain your individual data set and paste it into an excel file and submit it without adding summaries to the “excel file just your dataset” tab so staff can check you summarized the data set properly.
You need to discuss the dataset in a word file and submit it to the “word file” tab in Turnitin.
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.
Attachment:- Assignment instructions and details.rar