Foundation Skills in Data Analytics

Running head: FOUNDATION SKILLS IN DATA ANALYTICS
Foundation Skills in Data Analytics
Name of the Student:
Name of the University:
Author Note:

FOUNDATION SKILLS IN DATA ANALYTICS
1
Table of Contents
Memorandum.............................................................................................................................2
Answer to question 1:.................................................................................................................2
Answer to question 2:.................................................................................................................3
Answer to question 3:.................................................................................................................3
Answer to question 4:.................................................................................................................4
Answer to question 5:.................................................................................................................5
Answer to question 6:.................................................................................................................5
Answer to question 7:.................................................................................................................5
Answer to question 8:.................................................................................................................5
Answer to question 9:.................................................................................................................6

FOUNDATION SKILLS IN DATA ANALYTICS
2
Memorandum
To: Paul Anderson
From: Emma Thomson
Subject: Analysis of car insurance brokerage services
Dear Paul,
Emma Thomson, as a data analyst in the Research and Analysis Group at Financial
Review Magazine, needs to report results of data analysis to senior editors at the Magazine.
Primary role of the Research and Analysis Group is to evaluate new financial products and
services and provide advice on matters affecting the company. Of specific interest to
Financial Review magazine is the increasing numbers of companies that offer brokerage
services for car insurance and potentially what this means for consumers. As, an insurance
broker and an independent insurance agent who works with many insurance companies to
find the very best available policies for his or her customers. Most of these brokers are
advertising that they are able to save owners of motor vehicles hundreds of dollars each year
on insurance.
In response of the specific concern regarding the purchased dataset, several analytical
tests and techniques are used to calculate, estimate and the evidences for previously asked
questions. The outputs are extracted using the Excel and the answers are discussed in the
below section which will help to write about Car Insurance Brokerage in the innovative
business feature section of the next issue.