The datathat you will be using for this exercise came from a surveyof two insurance carriers.
The first carrier (C1) was compared against the second competitor (C2). The insurance company management team wants to know how Carrier 1 compared to the second carrier. Data from 159 respondents are included.
All of the 5 questions are rated on a scale of 1 to 5, with 1 being “much worse” and 5 being “much better”
1. Graph the 5 main survey variables in a histogram. For each graph you are going to graph out the data values, grouped by responses. You should have categories that are the responses 1-5. You should have 5 histograms, and on each, display both the C1 and C2 data on the same graph. What can you see from these graphs?
2. Create 95% confidence intervalsfor the meanfor the 5 survey variables on Carrier 1.
3. Perform 5 t-tests on the data comparing C1 to C2 on each of the 5 questions. Indicate which of the 5 variables has a difference between C1 and C2.
4. Interpret the data and write an brief (2 paragraph) executive summary to C1 management describing your findings.
Detailed response to questions.