Posted: September 13th, 2017

For this coursework you are required to solve a problem using Microsoft Excel and/or SPSS. Your solution should be word-processed, including the computer output (pasted in), and submitted electronically. Your solution should include both the output itsel

For this coursework you are required to solve a problem using Microsoft Excel and/or SPSS. Your solution should be word-processed, including the computer output (pasted in), and submitted electronically. Your solution should include both the output itsel

Order Description

For this coursework you are required to solve a problem using Microsoft Excel and/or SPSS. Your solution should be word-processed, including the computer output (pasted in), and submitted electronically.

Your solution should include both the output itself and a concise account of the methods you have used. Where appropriate you should also explain the reasons you have chosen those particular methods.

The data set TASTE contains information on a tasting experiment. Volunteers were asked to rate Campbell’s Chicken Noodle Soup and an alternative – Brand R. A score from 1 to 10 was used in each case (high values indicated the soup was liked). Also in the data set is a column of 1’s and 0’s, with 1 indicating a preference for Campbell’s soup.
Assuming these scores are representative of a population calculate a 95% confidence interval for the population difference in means of the two ratings. Is the value zero in this interval? – Interpret this.
With the preferences (0’s and 1’s) calculate a 95% confidence interval for the true proportion p of people who prefer Campbell’s soup to Brand R. Is the value 0.5 in this interval? – Interpret this. Calculate also a 90% confidence interval.
Write a brief report discussing the merits of the two approaches (i) and (ii) – are they both addressing the same problem?

Key Marking criteria will include:

Accuracy of the numerical solutions
Appropriateness of the methodology
Clarity and conciseness of the descriptions of the methodology

Word Limit

The word limit for this individual assignment is 1000 words.