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.