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

Cookie Sales by Region

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.

スキル： データ入力, 情報処理, エクセル

( 6件のレビュー ) Columbia, United States

プロジェクトID： #15202751

## この仕事に、30人のフリーランサーが、平均\$33で入札しています。

Teloquence

Excel expert at your [url removed, login to view] check my past reviews for your [url removed, login to view] forward for your reply so that i can start with the implementation Relevant Skills and Experience Excel Proposed Milestones \$35 USD もっと

\$35 USD 1日以内
(330件のレビュー)
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 もっと

\$30 USD 1日以内
(245件のレビュー)
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 もっと

\$30 USD 1日以内
(200件のレビュー)
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+[url removed, login to view] Proposed Mi もっと

\$50 USD 0日以内
(167件のレビュー)
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 1日以内
(30件のレビュー)
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 もっと

\$30 USD 3日以内
(2件のレビュー)
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 もっと

\$188 USD 10日以内
(12件のレビュー)
4.2
ritvijpandey872

A proposal has not yet been provided

\$23 USD 1日以内
(6件のレビュー)
3.6
muradeltaher

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 もっと

\$30 USD 1日以内
(20件のレビュー)
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 もっと

\$105 USD 1日以内
(7件のレビュー)
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, もっと

\$25 USD 1日以内
(3件のレビュー)
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 もっと

\$15 USD 1日以内
(4件のレビュー)
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 もっと

\$35 USD 3日以内
(3件のレビュー)
0.7
arunac68

A proposal has not yet been provided

\$30 USD 1日以内
(0件のレビュー)
0.0
\$25 USD 1日以内
(0件のレビュー)
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 もっと

\$10 USD 1日以内
(1レビュー)
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 もっと

\$11 USD 1日以内
(0件のレビュー)
0.0
sunny1586

A proposal has not yet been provided

\$15 USD 1日以内
(0件のレビュー)
0.0
priyasad994

i would like to join this project.

\$16 USD 4日以内
(0件のレビュー)
0.0
AG91

Hi, I'm Anuj. I am working in this field for more the 10 Years and have been working online since 2006. I specialize in Internet marketing, SEO, Date Entry, Localization to multiple Languages. Relevant Skills and Expe もっと

\$15 USD 1日以内
(0件のレビュー)
0.0