Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources
Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study
Go to the blog

Renault Plant Feasibility: A Statistical Analysis, Assignments of Statistics

Adnan Menderes UniversityStatistics

assignment for statistics management

Typology: Assignments

2020/2021

Uploaded on 02/08/2021

safae-eladlouni
safae-eladlouni 🇹🇷

5

(1)

3 documents

1 / 14

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Qualification
HND in Business (RQF)
Center Name Center Registration No
ABChorizon BTEC 91667
Student name Student Registration No
SAFAE EL ADLOUNI ME28287
Assessor name Unit No/Name
SAMER HAMDOU
Assignment number and title Credit Value
The Role of Statistics in Evaluating Business and
Economic Data
Issue date Submission date Submitted on
/10/2020 /12/2020 /12/2020
Student Declaration
Student signature: SAFAE Date:
Page 1 of 14
Unit 31: Statistics for Management
15
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe

Partial preview of the text

Download Renault Plant Feasibility: A Statistical Analysis 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

The Role of Statistics in Evaluating Business and

Economic Data

Issue date Submission date Submitted on

Student Declaration

Student signature: SAFAE Date:

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 Ford 40 16 56 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

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 194 109 25 130 41 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

Nisantasi 23 29 11 10 73 Uskudar 51 54 37 23 165 Grand Total 161 191 90 58 500 frequency table 5 Educational Qualification frequency Educational Qualification frequency

High School 191 38%

Bachelor 161 32%

Master 58 12%

HND 90 18%

High School Bachelor Master HND 191 161 58 90 Educational Qualification

By using Frequency table, we recognize that most participant in the questionnaire

have a high school diploma by 38% and 32% have bachelor degree.

Brief: from this data given by questionnaire and the data analysis making in my

point of view we have to 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 like 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.

Analyzing and evaluating Renault cars’ sales data in Mersin and Bursa considering: Applying descriptive data analysis for each of them. And show how you can use the results of analyzing these two data series to determine the city where the sales were more stable.

Descriptive data analysis in Bursa

Bursa Mean 3390. Standard Error 80. Median 3474. Mode 2900 Standard Deviation 395. Sample Variance 156781. Kurtosis -0. Skewness 0. Range 1310 Minimum 2890 Maximum 4200 Sum 81373 Count 24

coefficient of variation 0.

January^ March May^ July September^ November January^ March May^ July September^ November 0 500 1000 1500 2000 2500 3000 3500 4000 4500 Bursa

January February^ March April^ May^ June^ July August September October November^ December January February^ March April^ May^ June^ July August September October November^ December 0 1000 2000 3000 4000 5000 6000 7000 8000 Mersin

From the descriptive table of Bursa and Mersin we recognize that:

the Mean of Bursa >Mean of Mersin that means profit in Bursa are more stable

Standard deviation of Bursa < Standard deviation of Mersin

Coefficient of variation of Bursa < Coefficient of variation Mersin

So, we recognize that the sales in Bursa are more stable in Mersin.

Also, we can use the line chart to determine the stable sales in Bursa using the trend

line but in Mersin line chart has a lot of fluctuations.

Evaluating the differences in application between inferential statistics and measuring associations considering: Application of inferential statistics (sampling) to suggest an interval that can contain the mean of customers’ money amount spent per shopping trip in Renault car accessories store during the next two months according to the data available in the random sample (data are available in “Customers' Purchases Sample” sheet of Excel file) at significance level of 5%.

Significance 95%

X 6535.

Z 1.

Alpha 0.

Standard deviation 400

Standard Eror 40

Margin Eror 78.

N 100

Confidence 78.

Max 6613.

Min 6457.

We are sure by 95% that the arithmetic mean of customer purchases for next

two month are between 6457.12 and 6613.

SUMMARY OUTPUT Regression Statistics Multiple R 0. R Square 0. Adjusted R Square 0. Standard Error 366. Observations 24 ANOVA df SS MS F Significance F Regression 1 36861504.7 36861505 274.4486 6.551E- Residual 22 2954845.35 134311. Total 23 39816350 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 281.047541 226.625969 1.2401383 0.227989 -188.94595 751.041 -188.946 751. Monthly Training 0.107732564 0.00650304 16.56649 0.00 0.0942461 0.12122 0.09425 0.

Multiple R 0. R Square 0. Adjusted R Square 0. Standard Error 1267. Observations 24 ANOVA df SS MS F Significance F Regression 1

3 4444547.053 2.

7 Residual 22

5 1607809. Total 23 39816350 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 2659.

6 3.55946928 0.

5 4209.190727 1110.026235 4209. Monthly Advertising Expense (Turkish Lira) 0.

4 1.662633383 0.

1 0.

0.009273481 0.

By using the regression in data analysis of excel I find that The p value of monthly

training sales in Mersin is 0.11 value >5% that mean there is no statistic relationship

between advertising sales and cars sales in Mersin.

Also, the trend line in line chart of advertising sales in Mersin show us that there is

no statistic relationship between the two variables.

We notice from the previous two scatter diagrams that there is no correlation between data

spending and sales volume in Mersin

However, the increase in the volume of training spending is leading to an increase in the

sales volume of Renault

And also calculate the correlation ratio to confirm this

By regression analysis, we note that the sales volume is measured by relationship

y = 281 + 0,107x

y represents sales volume

x represents the amount spent on ads

I used exploratory statistic to explore the relationship with values as scatter diagram

And I used confirmatory statistic for confirm the result as correlation value

15000 20000 25000 30000 35000 40000 45000 50000 55000 0 1000 2000 3000 4000 5000 6000 7000 8000 f(x) = 0.04 x + 2659. Mersin monthly car sales Monthly Advertising Expense (Turkish Lira) Mersin Monthly Sales