Closed

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.

Skills: Data Entry, Data Processing, Excel

See more: excel work from home, excel spreadsheet jobs from home, work from home creating spreadsheets, work from home excel projects, excel jobs from home part time, freelance excel work uk, online excel jobs without investment, get paid to make excel spreadsheets, want to do excel work, do some excel work updated, do some excel work spreasheet set up, do some excel work powerpoint, do some excel work ocr, do some excel work bitcoin, Do some excel work 2

About the Employer:
( 6 reviews ) Columbia, United States

Project ID: #15202751

30 freelancers are bidding on average $33 for this job

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 More

$35 USD in 1 day
(330 Reviews)
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 More

$30 USD in 1 day
(245 Reviews)
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 More

$30 USD in 1 day
(200 Reviews)
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 More

$50 USD in 0 days
(167 Reviews)
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 in 1 day
(30 Reviews)
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 More

$30 USD in 3 days
(2 Reviews)
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 More

$188 USD in 10 days
(12 Reviews)
4.2
ritvijpandey872

A proposal has not yet been provided

$23 USD in 1 day
(6 Reviews)
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 More

$30 USD in 1 day
(20 Reviews)
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 More

$105 USD in 1 day
(7 Reviews)
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, More

$25 USD in 1 day
(3 Reviews)
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 More

$15 USD in 1 day
(4 Reviews)
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 More

$35 USD in 3 days
(3 Reviews)
0.7
arunac68

A proposal has not yet been provided

$30 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
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 More

$10 USD in 1 day
(1 Review)
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 More

$11 USD in 1 day
(0 Reviews)
0.0
sunny1586

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)
0.0
priyasad994

i would like to join this project.

$16 USD in 4 days
(0 Reviews)
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 More

$15 USD in 1 day
(0 Reviews)
0.0