# I need an Excel expert

The goal for the final project is for you to utilize the tools, techniques, and ideas from the class to make some type of quantitative decision. The following instructions must be followed in order to receive full credit towards your final project.

There are two deliverables that need to be submitted with your project:

An excel sheet that includes your data and decision making model

A word document that explains your data, how you collected it, and how your decision model works.

The following are the requirements for each of the deliverables:

Excel Sheet with Decision Making Model Requirements

Your decision making model must make some type of quantitative decision.

We have mostly discussed business/start-up types of decisions, however, you are free to choose any type of quantitative decision.

Your decision making model must be using a data set that includes at least 50 observations for four different variables.

You may use other variables that have less observations in addition to the four required above.

You may use multiple sources for your data for the four required or any optional additional variables.

**TIP** Think back to the multiple ways we talked about collecting data. Primary data collection is an option, but you can also use secondary data that is publicly available.

**ANOTHER TIP** Remember that sometimes you can model a variable even if you do not have data on it if you have summary statistics along the lines of averages, SD, assumptions about distributions, etc...

Your decision making model must be informed by at least two of the following analytical techniques we have used in class:

Correlation

Expected Value

Distribution Analysis (Histograms, Skewness, and Kurtosis)

T-Test

ANOVA

Regression

Your decision making model must utilize Monte Carlo analysis.

**TIP** The analytical techniques should help your form some of the assumptions of the Monte Carlo along with how the metrics/variables interact with each other in the Monte Carlo itself.

Word Document Requirements

A introductory section that describes the exact quantitative decision you would like to be able to make with your model.

A section that explains the exact variables you collected data on and how you collected that data (including the sources).

A section that explains what variables/metrics that you are including in your decision making model.

A section that describes the steps you went through to put together your decision making model. This should include:

How you arrived at all of the assumptions behind your model.

**TIP** This is probably where you would use your analytical techniques to inform your assumptions.

How the model actually works in terms of running the Monte Carlo.

**TIP** This is probably where you would use your analytical techniques to inform how your variables/metrics interact.

What the different findings and outcomes of the model are.

How the findings/outcomes of the model help in making the decision you set out to make.

Rubric

( 1 review ) Fort Myers, United States

Project ID: #22769228

## Awarded to:

Hello it's Aq. Hope you're doing fine. I'm capable of doing this for you and I hope you're having a great day and I will be thank full to you if you consider me for this task and also you won't regret it because my wor More

\$25 USD in 7 days
(3 Reviews)
1.8

## 13 freelancers are bidding on average \$20 for this job

atyourservice475

Let's chat and discuss regarding the project .I can assure you A grade quality work. Running Academic writing firm since 2005. Have served over 200,000 of students all over the world in their online course and deg More

\$10 USD in 1 day
(1 Review)
1.5
devishsingh9675

I am a hardworker. I will do your work very well with my own responsibility. I am punctual also. I am studying [login to view URL] Mechanical engineering from Moradabad India. I have type of knowledge about Excel and Microsoft and More

\$20 USD in 6 days
(0 Reviews)
0.0
RumanNehra80

Hey, I have good knowledge in excel. I will do your work properly and timely. Please don't go on my reviews because am new on Freelancer but I have real life experience in this field. All I need is an opportunity to More

\$19 USD in 3 days
(0 Reviews)
0.0
debjit81pal

Excel expart do you hire me in a low cost

\$10 USD in 2 days
(0 Reviews)
0.0
gujariya97

I can do the job better to you and quality is my best policy. I experienced person who do better the job

\$35 USD in 5 days
(0 Reviews)
0.0
mizkyubaidillah

PRO EXCEL

\$25 USD in 2 days
(0 Reviews)
0.0
mbasera99

I am willing to do your project and ready to start work. I will provide you a good result with accuracy. please response

\$15 USD in 1 day
(0 Reviews)
0.0
Mamtachavan

Have been working in this feild from last 15 years. On this site I have just started but once work offered will do it as required

\$17 USD in 1 day
(0 Reviews)
0.0
\$15 USD in 1 day
(0 Reviews)
0.0
Anuarulfreelance

Dear Sir, I have experience in website and excel data entry, and I have the ability to give back to you fine results. I am a student of MBA (Office System and Management). I always prefer a part time jobs. I have good More

\$20 USD in 7 days
(0 Reviews)
0.0
tigerkhach

I work with excel more than 15 years.

\$23 USD in 1 day
(0 Reviews)
0.0
\$25 USD in 1 day
(0 Reviews)
0.0