# 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.

Posted in Uncategorized