Write a Python script (preferred) or use Excel file to generate an analytical report

Write a Python script (preferred) or use Excel file to generate an analytical

report to address following problem.

2. Submit in a group with a .zip file (report in pdf and script file or Excel file)

The case(s) of Smartwater

You’re the regional manager at Amazon, in charge of 350 wholefood market warehouses in the

region, and the next project you’re going to take on is to optimize the weekly re-stocking of

Glaceau Smartwater. How many cases of Smartwater do you need to re-stock every week?

You want to know many cases of Smartwater to order weekly, for each store, so you minimize the

amount of inventory that ends up sitting idle in wholefood shelves.

You know there has to be a better way to get to a plausible answer that doesn’t involve visiting

every single wholefood in your region and get their sales numbers every single week.

You don’t need to know the population distribution. Since you’ve taken a few statistics classes,

the Central Limit Theorem comes to mind. You know that, applied to real-world problems, the

Central Limit Theorem helps you balance the time and cost of collecting all the data you need to

draw conclusions about the population.

You remember the definition of Central Limit Theorem for sample:

When we collect a sufficiently large sample of n independent observations from a population with

mean μ and standard deviation σ, the sampling distribution the sample means will be nearly

normal with mean = μ and standard error = σ/ √n

Do following steps:

1. Create the population dataset by using random generator and save as CSV and saving it

to avoid always recreating the dataset

a. Picked at random. Why do you need random?

b. Representative of the population.

c. Big enough to draw conclusions from, which in statistics is a sample size greater or

equal to 30.

d. Include less than 10% of the population, if you’re sampling without replacement.

Why you need less than 10% ?

2. Read the output CSV in case you've already generated the population dataset

3. Take a different number of samples with size n=30 and 100, all with the same and plot

the sales data just to see how it looks like.

4. Does the distribution of the sample data by itself have the shape of a Normal Distribution?

Explain about the different standard deviation, or the distance from the mean in both

sample size.

5. How close are you to the population mean?

6. Write a conclusion (itemized) as take away for your boss

Habilidades: Python, Análise estatística, Programming

Veja mais: python script read comma delimited file, use excel file standalone, powershell script add users excel file, python script parse tab delimited file, add excel file generate reports program, script find word excel file, python script read data text file, powershell script add user excel file, perl script read data excel file, need help write python script operate telit module, need write python script telit gc864quad module, script php convert excel file html, compare excel file generate, script move data excel file excel file, python script parse csv text file, python script scrape text html file, write script rename sheet excel file, powershell script to read excel file and write-output, how to write a python script to process a file and get all phone numbers from it

Acerca do Empregador:
( 0 comentários ) Denton, United States

ID do Projeto: #31827147

12 freelancers estão ofertando em média $150 nesse trabalho


Hi there,I'm biddin on your project "Write a Python script (preferred) or use Excel file to generate an analytical report " I have read your project description and i'm an expert in Python and machine learning therefor Mais

$250 USD in 6 dias
(35 Comentários)
(79 Comentários)

Hi, How are you? Very exited and happy to bid your project because my skills are fitted in your project. I have 12 years experience in Python programming. I am very familiar with instogram, trading bot, deep learning, Mais

$140 USD in 3 dias
(13 Comentários)

Hi,  I am a electronics and communication engineer with more than 2 years of experience but I am also a software/Program developer. The languages I use to work on are : 1. Python :- Web automation, Scraping, ML, Da Mais

$30 USD em 1 dia
(35 Comentários)

We will do your python work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in pr Mais

$140 USD in 7 dias
(16 Comentários)

Hi there, I am a talented python dev, and I think I can handle this task perfectly. Please give me your chance, I look forward to hearing from you. Regards!

$139 USD in 7 dias
(3 Comentários)

Hi! I am expert in Python, Matlab, ML, C++, C, C# and have 12 years experience. I work according to your requirement to provide the best quality and customer satisfaction. Thank you!

$170 USD in 3 dias
(2 Comentários)

Hello there, Hope you are doing well. I'll be glad to work on your statistical analysis project. I have years of experience in Python, Statistics, Excel, Data science, and Machine learning. Please, feel free to see s Mais

$190 USD in 7 dias
(2 Comentários)

I have a vast experience in the use of Excel statistical tool packs for report generation. For this project, Excel will be the best choice and I guarantee very impressive results.

$160 USD em 1 dia
(0 Comentários)

~~~~~ Hello. there! I read your project with great interest. When I saw the predicates on probability and statistical mathematics after a long time, I remembered my college days. I was a genius in this field when I was Mais

$200 USD in 5 dias
(0 Comentários)

Hello there, i m data scientist and I m in this field for 2 years and I m new to this site ths project really interest me to do as it fit my skills if you interested to do work with me. ping me communication will be Mais

$120 USD in 10 dias
(0 Comentários)

Hi, I just read your post titled "Write a Python script (preferred) or use Excel file to generate an analytical report". I can see that you need an experienced Data Scientist/Data Analyst for your project. I have Mais

$200 USD in 3 dias
(0 Comentários)