# Do some Excel Work

1. Search online and find 5 different career opportunities available to an Industrial Engineer. Include an estimate of starting salary of an entry-level industrial engineering position. You must cite your sources (web pages, books, technical articles, etc.).

2. Research and write between 200-250 words on an engineering field that will likely emerge during your lifetime (i.e. a field that does not currently exist). Include the background an industrial engineering student should obtain to prepare for this emerging field.

The following exercises will introduce you the Excel basics. It is a tool you will use throughout your IE education and beyond. Complete each problem on a different Excel sheet (within a single Excel file). Number and highlight (in Yellow, except where instructed to do otherwise) the answers you obtained to the questions. Submit your Excel file to Blackboard.

3. Go to the website [url removed, login to view] of the National Weather Service Forecast Office. Choose the following options:

1. Product: Preliminary Monthly Climate Data (CF6)

2. Location: Columbia, MO

3. Timeframe: Archived Data, Select August 2017

Save the data into a text file.

Import into Excel and erase everything except for the first 4 columns. The first column is Day and runs from 1 (the first of August) to 31 (the last day of the August).

a. Compute the average, median and sample standard deviation (using the Excel functions AVERAGE, MEDIAN and STDEV) for the Maximum, Minimum, and Average columns and format these results to two decimal places.

b. Next create a Scatter chart that shows the Maximum, Minimum, and Average versus Day all on one graph.

c. If Maximum temperature in a day is more than 90, highlight those days with red color. If Maximum temperature is below 75, highlight those days with blue color.

4. Considering following 2016 sales data for a Cookie factory:

Sales Rep

Region

# Orders

Total Sales

Bill

West

217

\$46,107

Frank

West

268

\$71,707

Bill

North

224

\$51,676

Janet

North

286

\$83,852

Janet

South

226

\$75,601

Martha

East

228

\$59,016

Martha

West

234

\$37,965

Frank

East

267

\$74,702

Janet

East

279

\$67,738

Martha

South

261

\$79,456

a. Calculate the total sales in 2016.

b. What is the average sale per representative?

c. Determine the best and worst sales representative in terms of their total sales?

d. Is there a sale price difference between regions? How about between sales representatives?

e. Calculate the average sales per sales representative for each region and draw a bar chart.

f. Calculate the total sales for each sales representative and draw a bar chart.

g. Determine the best sales representative for each region.

Dovednosti: Zadávání dat, Zpracování dat, Excel

O zaměstnavateli:
( 7 recenzí ) Columbia, United States

Identifikační číslo projektu: #15202751

## 30 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě \$33

Teloquence

\$35 USD za 1 den
(330 Recenzí)
7.6
vsolcorp

Sir, I am from vSol CORP. We are a team of 19 people. I have checked your project requirement, we are professional with data entry. I have few questions for you, can we discuss? Relevant Skills and Experience We have Další

\$30 USD za 1 den
(245 Recenzí)
7.6
schoudhary1553

Hi, I can start immediately and complete the work before mentioned deadline. I have read the brief project description and would like to be invited for further discussion to proceed Relevant Skills and Experience I ha Další

\$30 USD za 1 den
(200 Recenzí)
7.2
priyal1997

Hi There, I just went trough this assignment and 100% sure that I can do this task PERFECTLY for you. Relevant Skills and Experience Advanced excel skills Excellent academic background - Masters + CA+[login to view URL] Proposed Mi Další

\$50 USD za 0 dní
(167 Recenzí)
6.6
dynamitewebsol

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you Relevant Skills and Experience I have 7 years experience. Proposed Milestones \$50 USD - Milestone

\$50 USD za 1 den
(30 Recenzí)
5.8
liveexperts123

please ignore the bid amount we will discuss the price later in the chat after we have discussed the project thoroughly Relevant Skills and Experience: . Proposed Milestones: 30 - . Hi hdel47afc! please inbox me to dis Další

\$30 USD za 3 dní
(2 Recenzí)
4.1
Naumaan

The report for the four tasks mentioned in the project description can be created. Plz check my Bid Relevant Skills and Experience statistical data processing and market research Proposed Milestones \$188 USD - IE emp Další

\$188 USD za 10 dní
(12 Recenzí)
4.2
ritvijpandey872

A proposal has not yet been provided

\$23 USD za 1 den
(6 Recenzí)
3.6

Hi , I’d like to be considered for your position. For years I’ve worked in Engineering and so I am accustomed to working with all sorts of products and services, and in a variety of industries. Relevant Skills and E Další

\$30 USD za 1 den
(20 Recenzí)
3.9
NoelReubenMuturi

Hello, I am Noel. I have read your brief; you need a data entry expert. I am competent freelancer with a keen attention to detail. I endeavor to offer a personalized product, meet the client’s specifications, and produ Další

\$105 USD za 1 den
(7 Recenzí)
4.0
SidhuDN

Hello Sir I read your job carefully and I can do this job professionally. I can follow instructions really well. So you can expect me to the job exactly as you want me to do. Relevant Skills and Experience Data Entry, Další

\$25 USD za 1 den
(3 Recenzí)
2.7
jyotisingh10

Hey, I have gone through your post and want to discuss some points regarding your requirements. Therefore, would request you to initiate the chat in order to clarify my queries/comments. Relevant Skills and Experienc Další

\$15 USD za 1 den
(4 Recenzí)
2.0
suganyasivaraj

Hi I am expert in Excel. I already worked on Similar projects. We will provide excellent delivery on time. Relevant Skills and Experience Excel including calculation, Email writing and Data entry Proposed Mi Další

\$35 USD za 3 dní
(3 Recenzí)
0.7
arunac68

A proposal has not yet been provided

\$30 USD za 1 den
(0 Recenzí)
0.0
\$25 USD za 1 den
(0 Recenzí)
0.0
andreatrabucco

Hola, me llamo Andrea tengo conocimiento de Excel, búsqueda y entrada de datos. Habilidades y experiencia relevante Excel, búsqueda y entrada de datos. Htos propuestos \$10 USD - total Stay tuned, I'm still working Další

\$10 USD za 1 den
(1 recenze)
0.0
AhSoron

I have read your job post carefully and understood clearly about your need. I am really interested to work for you. Relevant Skills and Experience I am also fully expert in Internet Research, File Management, Email Ma Další

\$11 USD za 1 den
(0 Recenzí)
0.0
sunny1586

A proposal has not yet been provided

\$15 USD za 1 den
(0 Recenzí)
0.0