Using the data in the Excel file InsuranceSurvey, determine if the company can claim, at 90% confidence, that the proportion of those that want to pay a lower premium for a higher deductible (i.e.P1. Using the data in the Excel fileInsurance Survey, determine if the company can claim, at 90% confidence, that the proportion of those that want to pay a lower premium for a higher deductible (i.e.Premium/Deductible = "Y") is lessthan 0.30. Use the template developed in class or from the textbook to complete the hypothesis test.

Age Gender Education Marital Status Years Employed Satisfaction" Premium/Deductible 36 Some college Divorced T 55 F Some college Divorced 2 61 M Graduate degree Widowed 26 65 F Some college Married 9 53 F Graduate degree Married 6 50 F Graduate degree Married 10 10 28 F College graduate Married 11 62 F College graduate Divorced 12 48 M Graduate degree Married 13 31 M Graduate degree Married 14 57 F College graduate Married 15 44 M College graduate Married ZZZ