Đã Đóng

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.

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

Xem thêm: 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

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

Mã Dự Án: #15202751

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

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 Thêm

$35 USD trong 1 ngày
(330 Đánh Giá)
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 Giá)
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 Giá)
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 Thêm

$50 USD trong 0 ngày
(167 Đánh Giá)
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 Giá)
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 Giá)
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 Giá)
4.2
ritvijpandey872

A proposal has not yet been provided

$23 USD trong 1 ngày
(6 Đánh Giá)
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 Thêm

$30 USD trong 1 ngày
(20 Đánh Giá)
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 Giá)
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 Giá)
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 Giá)
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 Giá)
0.7
arunac68

A proposal has not yet been provided

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
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 Giá)
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 Giá)
0.0
sunny1586

A proposal has not yet been provided

$15 USD trong 1 ngày
(0 Đánh Giá)
0.0
priyasad994

i would like to join this project.

$16 USD trong 4 ngày
(0 Đánh Giá)
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 Thêm

$15 USD trong 1 ngày
(0 Đánh Giá)
0.0