# 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.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel

Về Bên Thuê:
( 7 nhận xét ) Columbia, United States

ID dự án: #15202751

## 30 freelancer đang chào giá trung bình \$33 cho công việc này

Teloquence

\$35 USD trong 1 ngày
(330 Nhận xét)
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 Thêm

\$30 USD trong 1 ngày
(245 Nhận xét)
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 Thêm

\$30 USD trong 1 ngày
(200 Nhận xét)
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 Thêm

\$50 USD trong 0 ngày
(167 Nhận xét)
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 trong 1 ngày
(30 Nhận xét)
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 Thêm

\$30 USD trong 3 ngày
(2 Nhận xét)
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 Thêm

\$188 USD trong 10 ngày
(12 Nhận xét)
4.2
ritvijpandey872

A proposal has not yet been provided

\$23 USD trong 1 ngày
(6 Nhận xét)
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 Thêm

\$30 USD trong 1 ngày
(20 Nhận xét)
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 Thêm

\$105 USD trong 1 ngày
(7 Nhận xét)
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, Thêm

\$25 USD trong 1 ngày
(3 Nhận xét)
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 Thêm

\$15 USD trong 1 ngày
(4 Nhận xét)
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 Thêm

\$35 USD trong 3 ngày
(3 Nhận xét)
0.7
arunac68

A proposal has not yet been provided

\$30 USD trong 1 ngày
(0 Nhận xét)
0.0
\$25 USD trong 1 ngày
(0 Nhận xét)
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 Thêm

\$10 USD trong 1 ngày
(1 Nhận xét)
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 Thêm

\$11 USD trong 1 ngày
(0 Nhận xét)
0.0
sunny1586

A proposal has not yet been provided

\$15 USD trong 1 ngày
(0 Nhận xét)
0.0