Hi There,

I need help for Q1 & Q2 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

Can you please carry out an analysis of the recent car insurance brokerage services survey data (contained in the file CarInsuranceSurvey.xlsx) and prepare a report containing answers to the following questions? Q1. Summaries of key variables of interest Can you please provide me with separate summaries of the following variables, just by themselves? In other words, please investigate each variable individually without reference to any other variable in the dataset. (a) "Savings" - Annual saving on car insurance premium in dollars (b) "Customer_Sat (Ratings)" - Level of satisfaction with Insurance Broker Q.2. Exploring relationships between two variables (a) I suspect there is some differences across the performance of individual brokers ("Broker") i.e., ability of the insurance broker to save on the car insurance premium ("Savings"), but I'd still like you to establish from your sample data if there is any relationship between these two variables. (b) I'm also interested to establish if the area drivers live in (Rural vs. Urban) ("Area") affect how they rate their brokering services ("Customer_Sat (Ratings)")? (c) Further, it would be helpful to know if the variables listed below provide any explanation in the variation of current insurance premiums ("Quote_Val"). A short description of the relationship would be sufficient. Age of the car ("Age_Car") Value of the car ("Car_Val")