UNIT 10 BIG DATA ANALYTICS ASSIGNMENT C May 24, 2024
PEARSON BTEC LEVEL 3
EXTENDED DIPLOMA IN
INFORMATION
TECHNOLOGY
BIG DATA ANALYTICS ASSIGNMENT C
LEARNING AIM C - CARRY OUT ANALYSIS OF STATISTICAL DATA TO MEET THE NEEDS OF
AN ORGANIZATION
Assessor:
Issue date: 1st May 2024
Hand in deadline: 20th May 2024
Name:
Student No:
Introduction.....................................................................................................3
STUDENT ) 1
,UNIT 10 BIG DATA ANALYTICS ASSIGNMENT C May 24, 2024
P4.....................................................................................................................4
Regression Analysis of Uk Car Industry............................................................7
Ford............................................................................................................7
Normal distribution ford.............................................................................9
Normal distribution VOLKSWAGEN...........................................................10
Audi..........................................................................................................11
Normal distribution for AUDI....................................................................12
BMW.........................................................................................................12
Normal distribution for BMW....................................................................13
Mercedes..................................................................................................14
Normal distribution for Mercedes.............................................................15
Probability distribution...................................................................................15
Trends............................................................................................................16
The decrease and increase in car sales...................................................19
P6...................................................................................................................21
Recommendations/considerations for the analysis.....................................21
Considerations.........................................................................................21
Recommendations...................................................................................22
M4/M5............................................................................................................23
M6/D3............................................................................................................24
Conclusion...................................................................................................24
Factors affecting car sales..........................................................................24
Final Thought..............................................................................................27
Bibliography...................................................................................................28
STUDENT ) 2
,UNIT 10 BIG DATA ANALYTICS ASSIGNMENT C May 24, 2024
Introduction
As an IT development trainee at a car dealership in Southern England, I am
tasked with a critical project. The directors are considering whether to switch
car brands or add new ones. I need to examine the rise in new automobile
registrations for different automakers to help me make this selection. The
data will be prepared by focusing on new car registrations and combining it
over several years. I will be using basic and advanced statistical methods, I
will analyze trends, averages, variations, mean, range etc. and comparisons
between different data sets. This analysis will result in two reports: a detailed
report for the directors, providing in-depth insights, and a summary for
branch sales managers, presenting key findings in a concise format. These
reports will provide accurate and relevant information, even for those with a
mathematical background, and will be presented clearly and appropriately.
My goal is to make the data accessible and useful, also guiding the
dealership's leadership through this critical business decision with
confidence and clarity.
STUDENT ) 3
, UNIT 10 BIG DATA ANALYTICS ASSIGNMENT C May 24, 2024
P4
P5
STUDENT ) 4
PEARSON BTEC LEVEL 3
EXTENDED DIPLOMA IN
INFORMATION
TECHNOLOGY
BIG DATA ANALYTICS ASSIGNMENT C
LEARNING AIM C - CARRY OUT ANALYSIS OF STATISTICAL DATA TO MEET THE NEEDS OF
AN ORGANIZATION
Assessor:
Issue date: 1st May 2024
Hand in deadline: 20th May 2024
Name:
Student No:
Introduction.....................................................................................................3
STUDENT ) 1
,UNIT 10 BIG DATA ANALYTICS ASSIGNMENT C May 24, 2024
P4.....................................................................................................................4
Regression Analysis of Uk Car Industry............................................................7
Ford............................................................................................................7
Normal distribution ford.............................................................................9
Normal distribution VOLKSWAGEN...........................................................10
Audi..........................................................................................................11
Normal distribution for AUDI....................................................................12
BMW.........................................................................................................12
Normal distribution for BMW....................................................................13
Mercedes..................................................................................................14
Normal distribution for Mercedes.............................................................15
Probability distribution...................................................................................15
Trends............................................................................................................16
The decrease and increase in car sales...................................................19
P6...................................................................................................................21
Recommendations/considerations for the analysis.....................................21
Considerations.........................................................................................21
Recommendations...................................................................................22
M4/M5............................................................................................................23
M6/D3............................................................................................................24
Conclusion...................................................................................................24
Factors affecting car sales..........................................................................24
Final Thought..............................................................................................27
Bibliography...................................................................................................28
STUDENT ) 2
,UNIT 10 BIG DATA ANALYTICS ASSIGNMENT C May 24, 2024
Introduction
As an IT development trainee at a car dealership in Southern England, I am
tasked with a critical project. The directors are considering whether to switch
car brands or add new ones. I need to examine the rise in new automobile
registrations for different automakers to help me make this selection. The
data will be prepared by focusing on new car registrations and combining it
over several years. I will be using basic and advanced statistical methods, I
will analyze trends, averages, variations, mean, range etc. and comparisons
between different data sets. This analysis will result in two reports: a detailed
report for the directors, providing in-depth insights, and a summary for
branch sales managers, presenting key findings in a concise format. These
reports will provide accurate and relevant information, even for those with a
mathematical background, and will be presented clearly and appropriately.
My goal is to make the data accessible and useful, also guiding the
dealership's leadership through this critical business decision with
confidence and clarity.
STUDENT ) 3
, UNIT 10 BIG DATA ANALYTICS ASSIGNMENT C May 24, 2024
P4
P5
STUDENT ) 4
