Hi There,

I need help for Q3 & Q4 with analytical formula using excel. Please find the questions in the screenshot and google link to data set or reference file to work on. Thanks!

https://docs.google.com/spreadsheets/d/1gtOKVOoeZy8Pc0EKswgjd5qr-WtS4qgUSCy6hWiGbz8/edit?usp=sharing

Q3. Estimating car insurance broker service measures {a} Can you estimate the average saving of car insurance premiums for all customers? {b} I'm also interested to know if you can estimate the proportion of all customers who are worse off using a broker [i.e., savings from using a broker are negative}? Q4. Car insumnce broker service claims (3) Some prominent business commentators argue that the average savings on car insurance premiums has gradually declined during the last two yea rs. The National Insurance Brokers Association's report two years ago stated that the average savings on car insurance premium is around $260. Is there any evidence to suggest that the average savings on car insurance premiums has decreased? Are you able to confirm that this claim is supported by your survey data? (b) A recent study suggests that male drivers are less likely to seek the services of an insurance broker than female drivers. The study asserts that the proportion of male drivers that use car insurance brokers is no more than 35%. Can you check whether this claim can also be substalitiated