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 [login to view URL] 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.
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 have more than 5 years of experience with excellent knowledge in data entry and excel. please give me a chance to work on your project
Proposed Milestones
$30 USD - once project is complete
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 worked on several similar projects, but for client privacy reason I am not disclosing here. Still, we can discuss it. For a quick preview, you can check our feedback section.
Proposed Milestones
$30 USD - We are flexible to adjust as require by you.
We do provide a non-paid trial. Can we chat here? Please reply me when you will be available. Thanks
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
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 discuss the project
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 employment research as per given instructions, article writing and statistics calcuations
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 Experience
I Provide certain services :
1. MS Office
2. Web Research
3. Data Entry
4. CorelDraw ,Photoshop And Illustrator
5. eCommerce , Amazon , ebay
6. WordPress
Proposed Milestones
$30 USD - Milestone
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 produce quality work. I am qualified to take up the project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio.
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, Excel, Excel VBA, Research, Web Scraping, Web Search
Proposed Milestones
$25 USD - Project Milestone
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 Experience
I would like to assist you with my strategies and shall show you my past works once we connect for discussion.
Regards
Jyoti
Proposed Milestones
$15 USD - s
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 Milestones
$5 USD - Requirement analysis
$5 USD - Planning
$20 USD - Implementation
$5 USD - Testing and Delivery
Additional Services Offered
$20 USD - Email writing Logo design
Please let me know when we can start the project.
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 on this proposal.
I am doing great job. I am a phd student with flexible time
Relevant Skills and Experience
microsoft, engineering, phd
Proposed Milestones
$25 USD - done
Hi, I'm your preferred freelancer, available and ready for your project. Please do visit my profile. I have experience working for online multimedia companies on Data Entry, Excel and Web Research. Communication is very important for me as I will be able to deliver the project up to your satisfaction. I'm hardworking and I take responsibility for my work. Please give me a chance to help you with this project.
Hi sir, i read your description and i am willing to do the project.
As i am a new freelancer i can work for you at any bufget and im good in excel very well
I can contribute valuable and quick data for this project. Expect the deliverables to be one word file, and one excel file, with all the data contained. I am an Industrial Engineer, with MBA.
Relevant Skills and Experience
I have done business writing for numerous companies. My Engineering training, together with an MBA will be ideal to complete this project
Proposed Milestones
$18 USD - Deliver Word File Q1 and Q2
$10 USD - Deliver Excel file for Q3 and Q4
Happy with two files: Word for Q1 and Q2, Excel for Q3 and Q4?
