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.