# statistical/Data analysis

Background to the project (Assumed names): 7Eleven fuel sites has experience less sales volume and they believe it is because of their competitor CX. For this purpose, we are going to check how close are 7eleven sites to CX and if their price has any impact on 7eleven fuel sites. For this purpose, I have geolocations for 7eleven sites and CX sites. You will have to the find the distance between the two sites and then check if at any sites price has impact the 7eleven sales. The key question is that since Coles Express (CX) has brought their fuel pricing back in line with the market (they were way above the average market price ) what has been the impact on our stores (7eleven) that are located close to Coles Express compared to those that are not located near them and what is the size of this impact in terms of fuel transactions and therefore combined merchandise sales.

For this task you only have to look at last 5 months. You can simply calculate the distance and then divide the distance into categories such as less than 500m, between 1km-2km, 2km-3km, 3km-4km and more than 5km.

You can use your own skills to help understand the impact.

Attached files:

Example done in [login to view URL]: This is example for you to help. You can replicate the similar and add more.

Copy of [login to view URL]: This is geolocation data for own sites and competitor sites

Merchandise sales & transactions (Jan2019-Sep2019).xlsx: This is merchandise sales and transaction data to see growth in merchandise sales and transaction within the distance calculated.

Fuel transactions (Jan2019-Sep2019).xlsx: These are fuel transactions data to see if the fuel transactions have been impacted

The merchandise and fuel data is only for own sites. For competitor sites- you can find the competitor fuel price and geolocation in "COPY of DATA"

You are to give submission in powerpoint presentation with different charts and tables explaining what has been the impact on our stores (7eleven) that are located close to Coles Express compared to those that are not located near them and what is the size of this impact in terms of fuel transactions and therefore combined merchandise

Über den Arbeitgeber:
( 0 Bewertungen ) Nairobi, Kenya

Projekt-ID: #21745760

## 25 Freelancer bieten im Durchschnitt \$468 für diesen Job

suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Mehr

\$750 AUD in 7 Tagen
(136 Bewertungen)
7.0
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Mehr

\$750 AUD in 8 Tagen
(34 Bewertungen)
5.9

Hello there, i am a well-knowledgeable statistician and would gladly accept your offer for this statistical/Data analysis project. My professionalism is unmatched and thus you should expect nothing but A+ work. Pleas Mehr

\$250 AUD in 3 Tagen
(60 Bewertungen)
5.9
Mendeznatera

You can see my Google Academics profile at [login to view URL] and ResearchGate profile at [login to view URL] I will do all the tasks that you assign. I Mehr

\$250 AUD in 7 Tagen
(23 Bewertungen)
5.0
citijayamala

1.I am an expert in Statistics, regression analysis, using both Excel and SPSS, also expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. [login to view URL] done many projects in Exce Mehr

\$250 AUD in 3 Tagen
(10 Bewertungen)
5.2
thenuv

Hi There! I am proficient in R programming and have handled different scenarios in Data science projects. Have developed different projects using R shiny, Markdown to build Dashboards, Predictions, Statistical reports Mehr

\$700 AUD in 7 Tagen
(17 Bewertungen)
4.9
MasterKym

Hello, I am a data scientist specialized in R programming and recognized by Freelancer.com as an "R programming expert" I have seen your project and I am very interested in it. I believe I can help you approach it in a Mehr

\$633 AUD in 7 Tagen
(17 Bewertungen)
4.9
mahumshabbir01

Hello I am an expert in statistical data analysis in SPSS and Excel. I have 7 years of experience in Statistical work. I have published various research papers and dissertation using statistical analysis. I can do your Mehr

\$250 AUD in 2 Tagen
(40 Bewertungen)
4.5
TellezMiotta

Hi! My name is Fernando Téllez. I am a senior year student of electrical engineering at Universidad Simón Bolívar (USB), one of the most prestigious universities in my country (Ranked 34° at the QS University Rankings: Mehr

\$500 AUD in 7 Tagen
(10 Bewertungen)
4.0
skfaroo123

Pro Statistics/Mathematics/R Programming Language/Statistical Analysis/SPSS Statistics Expert! Hi client. Once saw a your project, it was very attracted my mind because I am very interested in your project and also, h Mehr

\$500 AUD in 7 Tagen
(5 Bewertungen)
4.0
sajedali784

Dear Sir/Madam, Hello Expert in SPSS statistical analysis. I am the most relevant person for your work as I am working in a leading university as Associate Professor. Kindly go through my profile. Regards! Dr Sajed Ali Mehr

\$500 AUD in 7 Tagen
(4 Bewertungen)
3.9
qaisrani123

HI, I am data scientist and have good experience in python and R programming. My area of interest is statistical Analysis of dataset and apply ML/deep learning algorithm. I can intern your tasks. Kind Regards

\$500 AUD in 7 Tagen
(6 Bewertungen)
3.8
ITtechsol

Hello! I am very interested in your post project. While I read your description carefully, I was excited with feeling that I would be able to satisfy for your requirements in this job. We can negotiate on price/Budget Mehr

\$250 AUD in 3 Tagen
(3 Bewertungen)
3.3
muratalper99

I have Ph. D in statistics with vast experience in studying and running data analysis. I can do your project efficiently

\$666 AUD in 10 Tagen
(2 Bewertungen)
2.8
popov4sa

hello ! I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. Awaiting an affirmative response from Mehr

\$500 AUD in 7 Tagen
(2 Bewertungen)
2.2
Saimi786

Hello Thanks for your posting. I am a senior developer so i can do it very easily if you want.I’ve read your job description carefully and I am very interested in your project. I am sure that I can finish this project Mehr

\$399 AUD in 7 Tagen
(2 Bewertungen)
1.8
free20lancer20

HI I CAN ASSIST CONTACT ME

\$266 AUD in 2 Tagen
(0 Bewertungen)
1.2
Anannyakonar

I did my Master's in [login to view URL] data analytics is my core domain.I would like to help you and solve this problem within stipulate time [login to view URL] please let me help [login to view URL] Relevant Skills and Experience R progra Mehr

\$500 AUD in 5 Tagen
(0 Bewertungen)
0.0
craigsyms

Hi I would like to tender for your Fuel prices project. My background is in ecological research: using advanced numerical methods to address ecological problems. I received my PhD in 1998, and have worked as a biostat Mehr

\$750 AUD in 7 Tagen
(0 Bewertungen)
0.0
Marceresearcher

Dear customer, I would love to help you to identify the impact of competitors on your sales. I'm going to analyze your data to show you how distance, fuel price and the interaction between price*distance are affecting Mehr

\$250 AUD in 1 Tag
(0 Bewertungen)
0.0