# Excel Assignment Assignments | Online Homework Help

Now that you have Excel, you’re going to need to use it. If you have no idea how see the document “Intro to Excel” on the course webpage.

Don't use plagiarized sources. Get Your Assignment on
Excel Assignment Assignments | Online Homework Help
Just from \$13/Page

You have three major goals in this exercise. First, you’re going to convert the numbers in a data table from one unit to another. Second, you’re going to make a plot of your converted numbers. Third, you’ll use your plot to interpolate between the data points; that is, use the numbers that are there to figure out one that isn’t.

1. A person buys five different quantities of apples on five different days. Each time they pay a slightly different price per pound. The pounds they bought and the price in dollars are listed in this table. Enter this data into a blank Excel spreadsheet. Each data piece should be in a separate cell, just like the table below. Give each of your columns a title (again, like the table).

When you enter numerical data, just enter the numbers and no units. This will let you perform calculations on them later.

Pounds

Apples

Price

(U.S. Dollars)

1.30

2.31

2.11

3.43

3.69

7.31

4.20

7.60

5.12

9.41

1. Convert each number in pounds into kilograms. Assume there are 2.20 pounds in a kilogram (2.20 pound/kg). You can do this quickly and easily for all your rows if you follow the instructions for using Excel on the course Blackboard page.
2. Convert the prices in U.S. Dollars to Euros. Assume 1 U.S. Dollar equals 0.9010 Euros (0.9010 Euro/dollar).
3. If you divide the price paid in Euros by the mass of apples bought, you’ll arrive at the price paid in Euros per kilogram (€/kg). Do this for all the data rows.
4. Use Excel’s AVERAGE function to average the Euros per kilogram numbers you just calculated. Do this in a cell below the cells where you calculated €/kg.
5. Use Excel’s standard deviation function, STDEV.S, to calculate the standard deviation of the price per kilogram figures you just averaged. You can put this number right below your average.
6. Highlight all the cells you have numbers in and copy them into a Word document.
7. Construct a scatter chart (plot) of your price in Euros and masses in kilograms numbers (not the price per kilogram numbers). Give your chart a title and enter titles for the x and y axes.
8. Add a linear trendline to the chart you just created. Set the equation for this line to appear on your chart.
9. Copy the chart into your Word document below the cells you pasted earlier. Size your graph so it fits into the document.
10. Use your plot to determine how many kilograms of apples you could buy for 5.00 Euros.
11. Save your Word file as a PDF for submission to Canvas.  More instructions for this are on the course Canvas page.

Each version of Excel is slightly different, so make sure you can navigate the version you have available to you at home or in computer labs. Excel can come in handy in other classes, especially if you continue on to Chem 106.

Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

At Myhomeworkwriters.com, we always aim at 100% customer satisfaction. As such, we never compromise o the quality of our homework services. Our homework helpers ensure that they craft each paper carefully to match the requirements of the instruction form.

With Myhomeworkwriters.com, every student is guaranteed high-quality, professionally written papers. We ensure that we hire individuals with high academic qualifications who can maintain our quality policy. These writers undergo further training to sharpen their writing skills, making them more competent in writing academic papers.

Affordable Prices

Our company maintains a fair pricing system for all academic writing services to ensure affordability. Our pricing system generates quotations based on the properties of individual papers.

On-Time delivery

My Homework Writers guarantees all students of swift delivery of papers. We understand that time is an essential factor in the academic world. Therefore, we ensure that we deliver the paper on or before the agreed date to give students ample time for reviewing.

100% Originality

Myhomeworkwriters.com maintains a zero-plagiarism policy in all papers. As such, My Homework Writers professional academic writers ensure that they use the students’ instructions to deliver plagiarism-free papers. We are very keen on avoiding any chance of similarities with previous papers.

Our customer support works around the clock to provide students with assistance or guidance at any time of the day. Students can always communicate with us through our live chat system or our email and receive instant responses. Feel free to contact us via the Chat window or support email: support@myhomeworkwriters.com.

Try it now!

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Homework Writing Services

My Homework Writers holds a reputation for being a platform that provides high-quality homework writing services. All you need to do is provide us with all the necessary requirements of the paper and wait for quality results.

## Essay Writing Services

At My Homework Writers, we have highly qualified academic gurus who will offer great assistance towards completing your essays. Our homework writing service providers are well-versed with all the aspects of developing high-quality and relevant essays.