Download Statistics in Business and Economic Data: A Renault Case Study and more Assignments Statistics in PDF only on Docsity!
Qualification
HND in Business (RQF)
Center Name Center Registration No
ABChorizon BTEC 91667
Student name Student Registration No
SAFAE EL ADLOUNI ME
Assessor name Unit No/Name
SAMER HAMDOU
Assignment number and title Credit Value
Issue date Submission date Submitted on
Student Declaration
Student signature: SAFAE Date:
Table of Contents
Assignment Title: The Role of Statistics in Evaluating Business and Economic Data Case of study:
In order to open a new plant to expand foreign direct investment, the board of
directors in Renault Corporation require a feasibility report to justify the decision.
Based on the data and information that you provided to us in the Excel sheet I used
pivot table and frequency table to analyze each question and the results are below:
1. what is you preferred car?
The data analyzed by using by pivot table showed us the most individuals are 157
from 500 preferred Renault car
2- Your
preferred car’s price compared to other brands is: very
expensive, expensive, neither expensive nor cheap, cheap, or very cheap?
Count of
Individual
Column
Labels
Row Labels cheap
expensiv
e
neither cheap
nor expensive
very
cheap
very
expensive
Grand
Total
Fiat 7 4 79 90
Row Labels Count of Individual
Fiat 90
Ford 56
Land Rover 12
Mercedes- Benz 70
Peugeot 22
Renault 157
Toyota 34
Volkswagen 59
Grand Total 500
Mercedes- Benz Ford Peugeot^ Toyota Volkswagen^ Land Rover Fiat Renault 0 20 40 60 80 100 120 140 160 180 Preferred car
Ford 23 30 3 56
Land Rover 2 2 8 12
Mercedes- Benz 40 27 3 70
Peugeot 10 1 11 22
Renault 4 79 55 5 14 157
Toyota 5 3 24 1 1 34
Volkswagen 24 5 27 3 59
Grand Total 109 130 194 26 41 500
After analyzing the data using the pivot table, we found that 79 of individuals
preferred Renault as a low price compared to the brands quality.
reasonable price high price very high price low price very low price
Price Compared to the Brand Quality
4- What is your current disposable income?
Comparing preferred car to the disposable income:
In the questionnaire data we have the minimum of individual disposable income is
1800 and the maximum disposable income is 30000 so the range of the income is
30000-1800=28300/56=503 so I chose to dived the range to 500 groups.
We note that 156 of individuals who has the income between 1800-4799 chose
Renault as a preferred brand car and only one individual who has income between
5800-6299 chose Renault as a preferred car brand.
Count of Preferred Car's Brand Column Labels Row Labels Fiat Ford Land Rover Mercedes- Benz Peugeot Renault Toyota Volkswagen Grand Total 1800-2299 7 16 23 2300-2799 14 2 45 2 2 65 2800-3299 34 2 49 8 93 3300-3799 14 2 1 23 10 1 51 3800-4299 4 3 3 5 3 18 4300-4799 16 2 20 4 2 44 4800-5299 16 4 2 22 5300-5799 14 5 1 20 5800-6299 7 1 1 3 12 6300-6799 1 5 1 7 6800-7299 5 4 9 18 7300-7799 1 1 2 1 1 6 7800-8299 13 4 7 24 8300-8799 4 2 1 7 8800-9299 1 19 3 9 32 9300-9799 1 3 4 9800-10299 1 19 9 29 10800- 11299 2 1 3 11800- 12299 1 3 3 7 12300- 12799 1 1 2 12800- 13299 1 1 2 13800- 14299 1 1 2 14800- 15299 1 1 2 16800- 17299 1 1 1 3 17800- 18299 1 1
High School 191 38%
Bachelor 161 32%
Master 58 12%
HND 90 18%
High School Bachelor Master HND
Educational Qualification
By using Frequency table, we recognize that most participant in the questionnaire
has a high school diploma by 38% and 32% have bachelor degree.
Brief: from this data given by questionnaire and the analysis making in my point of
view I think that we have add more questions for example which car do you have? Or
do you think to buy a car in next years? If you would like to buy a car which car
would you choose? To understand the majority of people we have also to choose
more neighborhood to decide if we have to open another franchise or not in Istanbul
because the 3 neighborhoods given in the data of questionnaire are not enough to
make a certain decision.
